Are You a Frustrated Windows User?

Do you ever feel like you want to chuck your computer out the door? I've felt that way before; there are some things that are very frustrating about working with computers.

If you want to better use your computer, the key is to learn more about the operating system that runs your computer. If your system uses Windows 7 or a version of Windows 8, you could benefit by my free WindowsTips newsletter. It provides great, bite-sized pieces of information that can help you learn more about using Windows.

Check it out today by visiting the WindowsTips website. The sign-up form for the newsletter is at the right side of any page on the site.

—Allen
     

ExcelTips (ribbon) for 28 March 2015

Editing
Can't Enter Years in a Cell

Sometimes getting the right thing to show up in a cell can be a bit tricky when working with dates. If you enter a year number and Excel does some funky interpretation of what you entered, this tip explains what is happening.

Read this tip »

(Thanks to Mohammad Al Khalidy, Martyn Passmore, Andrija Vrcan, Martin Nicol, Steve Aprahamian, Danijel Namjesnik, Daryl Braun, David Prout, Jim Shearouse, Susan Jorgensen, Nora Abbott, Guy Goodwin, Steve Lindquist, Fletch Brownlee, Mark Groessl, Barb Lange, Erik Oberg, Paul Sprunken, Dave Onorato, John Louws, John Vander Linden, Jacques Raubenheimer, Mike Hodkinson, Simon Paterson, Bob Beechey, Jonathan Clipston, Mike Shellito, Bob Hall, Tom Mullan, Henry Arthur, Dave Kerr, Tom Van Dam, Brent Montague, Monica Birren, Damian Fennelly, Colin Delane, Peter Aitken, Mark Marikos, Arturo Lopez, Gonzalo Pereyra, Teri Buchanan, Scott Renz, Aldo Santolla, Erik Ersser, David Gray, Peter Shepherd, and Bud Beaty for contributing to this tip.)

 
Files
Sorting Files

The Open dialog box allows you to sort the files it presents to you. How you do the sorting depends on the version of Word and Windows you are using.

Read this tip »

 
Macros! Macros! Get Your Macros Here!

Learn all the best methods for creating and using Excel macros. ExcelTips: The Macros is the best single source for learning about macros or improving your existing skills. Be the person everyone looks to when something needs to happen in Excel. Get yours today!

 
Tools
Fixed-Width Settings when Converting Text to Columns

The Convert Text to Columns capabilities of Excel are very helpful when pulling apart information. When working with fixed-width data, you may want a way to "override" what Excel suggests as breaking places for the data. Here are some ideas.

Read this tip »

 
Macros extend Excel
Editing Macros

Even if you do nothing but record macros, sooner or later you will have a need to edit what you record. Here's how to get to the place where you can make the macro changes directly.

Read this tip »

 
     

Help Wanted

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

 
Using a Cell Value as a Worksheet Name in a Formula

I have a formula that references a cell in another workbook, as ='[Timesheets.xlsm]Week01'!L6. I would like to have the formula pick up the name of the worksheet (Week01) from another cell, so that the formula becomes more general-purpose. How should I change the formula so it can use whatever worksheet name is in cell B9?
—Roy Jude (provide an answer for this Help Wanted question)

 
ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 794  •  Orem, UT  84059  •  801-607-2035