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:
Add buttons to the standard toolbar
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.
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:
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 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.
All contents Copyright 1998-2008 by MrExcel Consulting.