Customizing Excel

Back

About MrExcel

Consulting Services

Learn Excel Resources

Challenge of the Month

Customizing Excel

Amber MacArthur, Bill Jelen, Leo LaPorte, Andy Walker on the set of Call for Help on TechTV Canada.

The tip in this show is from Learn Excel from MrExcel.

Here are some simple tips to make Excel easier

Show Full Menus all the time.
It is annoying that Excel doesn't show you all of the items in the menu, or all of the items in the standard toolbar. To change this setting, use:

1. Tools - Customize
2. On the Options tab, check the top two boxes shown below.

Add buttons to the standard toolbar

1. Tools - Customize
2. Go to the Commands tab
3. You can drag any new command to any visible toolbar and drop it.

Close All Open Workbooks
Say you have many workbooks open. You want to close the workbooks, but keep Excel open. Rather than doing File - Close, File - Close, File - Close, etc. - you can hold down the shift key and do File - Close All.

Bump up the number of files in the recently used file list
At the bottom of the file menu, there is a list of the last four files you opened. You can increase this from 4 to 9.

From the menu, select Tools - Options - General.
Dial the spin button for Recently Used Filelist up to 9 entries.

Here is one gotcha; the file list doesn't instantly increase to 9. You have to open 5 more files in order to have the file list hit the full potential.

Move cell pointer in direction after enter
When you type a number in Excel and hit Enter, the cell pointer usually moves down one cell. You can change this behavior by typing the number and then the right arrow key. But, if you are keying many numbers with the number keypad, it is easier to hit Enter than the arrow key.

If you need to have the cell pointer move to the right after entering a number, follow these steps:

From the menu, select Tools - Options - Edit.
In the dropdown for Move Cell Pointer Direction after Enter from Down to Right.

There you have it - five simple tips to make your use of Excel easier. For the BEST TV show on technology, check out Call for Help.

This tip was originally published on July 19, 2006 and aired on TechTV in Canada and Australia on July 20, 2006.

The permanent URL for this page is http://www.mrexcel.com/tip128.shtml.

If you are looking for show notes from another episode, visit my complete list of TechTV appearances.

MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.