By default, Excel place the Standard and Formatting toolbars on the same row at the top of the screen. This is fine if you are using large screen with high resolution. But if you use small screen in low screen resolution such as 800 x 600 or 1024 x 768, it’s impossible to have all the buttons on either toolbar display at the same time and where you’re often forced to waste time in clicking the Toolbar Options button to have access to options that are currently hidden.
For any reason, if you would like to display all the buttons on both Standard and Formatting toolbars bye default, you can configure the following option:
- Choose View -> Toolbars->Customize to open the Customize dialog box.
- Select the Options tab in the Customize dialog box
- Select the Show Standard and Formatting Toolbars on Two Rows check box and then click the Close button.
To show all of a menu’s options the moment you open it:
- select the Always Show Full Menus check box on the Options tab of the Customize dialog box.
- This stops the program from shortchanging you on how many options you see when you first open a particular menu. Menus don’t show all their options until the menus are open for several moments — moments that often seem like a lifetime.