MS Excel

Get the Info Quick Do you use the Research feature found under the Review tab on the ribbon in MS Word 2007? You know, the handy function that provides a definition, translation and thesaurus information all in one concise location. Yes? How do you access it? Do you go to the Review tab, click on … Continue reading Get the Info Quick

The Case of the Missing Labels Have you used MS Excel 2007 to make a chart lately? Did you feel like you missed a step or something? I mean, you highlighted your data, used the Insert tab on the ribbon to select a chart type and poof! A chart appeared in your worksheet. Sounds nice … Continue reading The Case of the Missing Labels

Painting by the Rows? Or, if you please, by the columns! I don't know about you, but I just love the MS Office Format Painter button. That amazing little feature can quickly transfer formatting aspects to other locations in your file, without changing the actual text or data. Marvelous! Much to my amazement, despite the … Continue reading Painting by the Rows?

Page Setup in Excel 2007 Are you using Excel 2007? Having trouble locating the Page Setup options you frequently use? I'm sure by now you've found many things under the Page Layout tab on the ribbon. You've probably noticed that a lot of the options are there as separate buttons, allowing you to quickly set … Continue reading Page Setup in Excel 2007

Excel Sorting: The Basics In MS Excel, you often have a database of information that needs to be ordered in a certain way (whether it's alphabetical, by date or whatever). The first step to sorting data is to tell Excel what database it's going to be sorting. To accomplish that, select a cell in the … Continue reading Excel Sorting: The Basics

One More Filter Discussion: For Excel 2007 As you can see, I'm not quite done with the AutoFilter discussion for MS Excel 2007! For those of you who have been working with it, you have probably noticed that your filter down arrow gave you several more choices than the older versions ever showed. So, as … Continue reading One More Filter Discussion: For Excel 2007

Print Some or Print All Today's tip comes from a reader who wanted to know how to print an entire MS Excel workbook all at once. That's a good question. After all, it's a royal pain to print each worksheet individually. So, how exactly can you print an entire workbook at one time? The answer … Continue reading Print Some or Print All

I Need a Little Help Here! I don't know about you, but I sometimes find myself guessing what arguments are needed in an MS Excel function. If it's something I haven't used in awhile, I may not be able to come up with the exact components that actually go into the parenthesis. At that point, … Continue reading I Need a Little Help Here!

Do you set print areas in MS Excel to quickly print the cells that are only needed time and time again? Ever have times when you want to print a different range of cells, without resetting the print area? Yes? Then you need to give this a try! First, highlight the cells you want to … Continue reading Temporarily Ignore the Print Area

Find It Where? Did you know that when you do a Find/Replace in MS Excel, you can control how much of the file is searched? Yep, that's right! You can choose to work on a single worksheet or the entire workbook. It's all up to you. You just have to know where to look for … Continue reading Find It Where?