Excel Tips

Excel Filter by Selection »

September 2, 2014

There is a great Filter by Selection icon in Access. Excel offers the same functionality, but it is hidden and mislabeled!

Convert Excel Dates to Month Names »

September 1, 2014

Need to Subtotal or Group by Month? The TEXT function will take any number or date and convert it to text using a particular custom number format.

Excel Fill Alphabet or Roman Numerals »

August 29, 2014

Sure, Excel can fill January, February, March, but what about A, B, C or I, II, III?

Excel Search Entire Workbook »

August 28, 2014

You need to find something, but you don’t know what worksheet it is on.

Copy Excel Worksheet - Easy and Fast »

August 27, 2014

You've created the perfect report for January. Now you need to make 11 copies for the other months.

Use Mouse Wheel to Scroll Left & Right in Excel »

August 26, 2014

Can I use mouse to scroll left & right in Excel?

Move to Top of Selection in Excel »

August 25, 2014

You start at the top of the data set. You press Ctrl + Shift + Down Arrow and Ctrl + Shift + Right Arrow. This is great... you’ve selected the whole data set, but now how do you get back to see the top of the selection?

Easy Territories in Excel Pivot Tables »

August 22, 2014

Your pivot table has a list of cities, but no Territory field. There is an easy way to create a virtual Territory field.

View 2 Excel Workbooks Side by Side where both Scroll! »

August 21, 2014

Need to see two workbooks side by side? With both workbooks open, go to the View tab and click View Side by Side. This column of 3 icons are the first to shrink on this ribbon tab, so most of the time it is a tiny unlabeled column as you see on the right.