Show full toolbars all the time

While learning Excel, use the Tools Customize feature to show the complete version of Standard and Formatting toolbars.Microsoft only show the most common menu choices from Excel’s two most important toolbars: Standard and Formatting.

The Standard toolbar has icons for a New Workbook, Saving, Printing, Print Preview, Spell Check, Cut, Copy, Paste, Undo, and Redo. These are all fairly important items.

The Formatting toolbar has icons for Font, Font Size, Bold, Italic, Underline, Left Align, Center, Right Align, Number, Bullets, Indent, Outdent, Borders, Cell Color, and Font Color. These are also all fairly important items.

In order to use any of the other icons on the Standard toolbar, you have to choose the double-right arrow on the toolbar.

Most users with a default installation will only see a portion of these icons and will have to use the double-right arrow on the toolbar to see all of the icons.

Microsoft does this in order to show you more rows of data in the spreadsheet. This may have been a problem in the days of VGA monitors. However, with today’s high screen resolutions, you can afford to have the toolbars displayed on two rows and to see all of the available options at a glance.

Display the toolbars on two rows. From the Tools menu => select Customize.

On the Options tab, select the option for Show Standard and Formatting toolbars on two rows.

This option was called Display Standard and Formatting Toolbars on One Row.