Separating Toolbars & Displaying Complete Dropdown Menus
The Excel default window contains the Menu Bar, the Standard Toolbar, the Formatting Toolbar, and the Formula Bar. Sometimes, the Standard and Formatting toolbars share one row. In addition, when you click on Menu Bar options, complete dropdowns do not always appear. To separate the toolbars and view complete dropdown menus, follow the instructions below.
  1. Open Excel.
  2. Right-click on a blank space in the Menu Bar (i.e., to the right of the Help option).
  3. A pop-up menu will appear.
  4. Click on the Customize option.
  5. The Customize dialog will appear.
  6. Go to the Options tab.

  7. Make sure there is a checkmark to the left of the Show Standard and Formatting Toolbars on Two Rows field.
  8. Make sure there is a checkmark to the left of the Always Show Full Menus field.
  9. Click on the Close button.
  10. The Standard and Formatting toolbars will now appear in separate rows, and you will see complete menus when you click on a Menu bar option.

Note: If you don’t know what an icon does, hold your mouse cursor over the icon without pressing any buttons. A ToolTip will appear, displaying the name and a brief explanation of the icon.

Click HERE to return to the Table of Contents.