Excel Tips

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.

F2 Stops Excel RefEdit Boxes From Inserting Cell Addresses »

August 20, 2014

Maybe you are setting up Conditional Formatting, or defining a Name. It could be any dialog where you have a RefEdit control (the boxes with the red arrow at the right). You mis-type something and instinctively press Left Arrow Left Arrow Left Arrow to correct it. But Excel starts inserting cell addresses instead of moving left.

Add a ToolTip to Any Cell in Excel »

August 19, 2014

ToolTips are awesome, right? You see them all the time in the Ribbon. If you are creating a worksheet for someone else to use, why not add reminders and notes to the cells they are supposed to fill out?