Excel: Learn Excel from MrExcel Episode 101

Episode 101 of the MrExcel Podcast

Transcript of the video:

The “Learn Excel from MrExcel” podcast!

Today we're going to take a look at Excel’s menus. Starting back in Excel 2000, Microsoft thought that the menu structure just contained too many items, and so their solution was to hide them from us. If you look at most menus, you'll see just a few items on the list, and a double drop-down arrow at the bottom that will expand the full menu. I think this is a really lousy way to try and learn Excel, It’ll be much better if Microsoft will show us the full menus all of the time. To fix this, we're going to go to the Tools menu, and then to Customize. There are three tabs on the Customize dialog. We want to go to the rightmost tab, the Options tab in Excel 2002 and in 2003, check the box for Always Show Full Menus. Now, when you go to Excel’s menus, you'll see the entire structure of the menu first time, every time.

Stop back tomorrow for another tip from MrExcel!

Keywords for this video: Excel

This video is current as of July 23, 2006

For more resources for Microsoft Excel