Show ALL Menu Items
The default setting for Excel's Menu items is usually installed and rarely changed by most users. You may or may not like the default settings of displaying only the menu items that were last used. Perhaps you would prefer to see all of the menu choices rather than just a few. It doesn't take very long, and isn't very difficult if you wanted to make a shift.
It's not a bad default setting - you see an abbreviated listing of what's behind that menu option and you can see the rest of the choices by clicking the down arrow at the bottom of the menu to see the rest of the choices.
Take a look under the Tools menu to the Customize menu view option.
![]()
Click on the Options Tab and check the box beside - Always show full menus option.
Then click on the Close button.
The next time you click on a Menu option, you should see the full range of choices.
![]()
Clicking on the Insert menu listing will show all of the choices under Insert. The same pattern will continue if there are choices with sub-menu decisions.
It might be of interest to remember the location of customizing the settings if you make a change and decide you want to revert to the default settings.
All you have to do is to "uncheck" the setting for Always Show Full Menus and you will return to the way your computer installed the current copy of Excel.
(Note: Once you change Excel, you may find your preferences of Menu views in Excel will also be changed in other Office applications as well!)