Find the Excel Toolbar

Go beyond Standard and Formatting toolbars with hidden toolbars

Find and Show Toolbars in Excel
© Ted French

Before the Ribbon made its first appearance in Excel 2007, the previous versions of Excel used toolbars. If you are working in a version of Excel 97 through Excel 2003 and a toolbar is missing or if you need to find a seldom-used toolbar that is not normally visible, follow these steps to find and show the toolbar in Excel.

How to Locate and Show Hidden Toolbars

Hidden toolbars include AutoText, Control Toolbox, Database, Drawing, E-mail, Forms, Frames, Mail Merge, Outlining, Picture, Reviewing, Tables and Borders, Task Pane, Visual Basic, Web, Web Tools, Word Count, and WordArt.

To open any of these toolbars:

  1. Click on the View menu to open the drop-down list.
  2. Click on the Toolbars option in the list to open the second drop-down list containing all available toolbars.
  3. Click on the name of a toolbar in the list to make it visible in Excel.
  4. After you complete this process, the toolbar should remain visible in Excel the next time you open the program. If you don't need it open, choose View > Toolbars and click it again to remove the check mark.

The chosen toolbars appear beneath the Standard and Formatting toolbars.

About Toolbars

The Standard and the Formatting toolbars are the most commonly used toolbars. They are turned on by default. Other toolbars must be turned on for use.

  • The Standard toolbar is located at the top of the screen just below the menu bar. It contains basic actions such as New, Save, Open, Copy, Paste, and Print.
  • The Formatting toolbar is next to the Standard toolbar. It contains text commands such as font, text size, bullets, bolding, and numbering. 

    By default, these two toolbars appear side by side at the top of the Excel screen. Because of this, some of the buttons on each toolbar are hidden from view. Click the double arrows at the end of the toolbar to show the hidden buttons. Click on a button to move it to a place on the toolbar where it will be visible.

    It takes the place of a different button, which moves to the hidden section of the toolbar.

    mla apa chicago
    Your Citation
    French, Ted. "Find the Excel Toolbar." ThoughtCo, Jan. 13, 2018, French, Ted. (2018, January 13). Find the Excel Toolbar. Retrieved from French, Ted. "Find the Excel Toolbar." ThoughtCo. (accessed March 20, 2018).