XL: Not All Toolbars Listed on Popup Menu

Last reviewed: February 2, 1998
Article ID: Q105451

The information in this article applies to:

Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0, 5.0c
Microsoft Excel for Windows NT, version 5.0
Microsoft Excel for the Macintosh, versions 4.0, 5.0, 5.0a
Microsoft Excel for Windows 95, versions 7.0, 7.0a
Microsoft Excel 97 for Windows
Microsoft Excel 98 Macintosh Edition

SUMMARY

In Microsoft Excel, not all available toolbars are shown on the toolbar shortcut menu. This behavior is by design.

MORE INFORMATION

The toolbar shortcut menu does not display all available toolbars. Because of this, you may need to use the Toolbars or Customize dialog box to show or hide some toolbars. To show or hide a toolbar that is not on the toolbar shortcut menu, do either of the following:

On the toolbar shortcut menu, click Toolbars or Customize, and then make the appropriate changes in the Customize dialog box. Or, click the View menu, point to Toolbars, and click Customize.
```
    -or-
```
Create a custom toolbar that contains the buttons you want: the custom toolbar will be shown on the shortcut menu.

The toolbar shortcut menu provides a quick way to show or hide toolbars. It also gives quick access to the Toolbars dialog box. To show the toolbar shortcut menu, do the following:

In Microsoft Excel for Windows, use the right mouse button to click on any visible toolbar.
In Microsoft Excel for the Macintosh, press and hold the COMMAND and OPTION keys, and then click any visible toolbar.
In Microsoft Excel 98 Macintosh Edition, press and hold the CONTROL key, and then click any visible toolbar.

The following toolbars are displayed on the toolbar shortcut menu.

Microsoft Excel 98 Macintosh Edition

   On toolbar shortcut menu               Not on toolbar shortcut menu
   -------------------------------------------------------------------

   Standard                               Stop Recording
   Formatting                             Auditing
   Chart                                  Full Screen
   Drawing                                Circular Reference
   External Data                          Exit Design Mode
   Forms                                  Shadow Settings
   Movie                                  3-D Settings
   Picture
   PivotTable
   Reviewing
   Visual Basic
   Web
   WordArt
   [any custom toolbars you create]

Microsoft Excel 97

   On toolbar shortcut menu               Not on toolbar shortcut menu
   -------------------------------------------------------------------

   Standard                               Stop Recording
   Formatting                             Full Screen
   Chart                                  Circular Reference
   Control Toolbox                        Exit Design
   Drawing                                Shadow Settings
   External Data                          3-D Settings
   Forms
   Picture
   PivotTable
   Reviewing
   Visual Basic
   Web
   WordArt
   [any custom toolbars you create]

Excel 5.0 and 7.0

   On toolbar shortcut menu               Not on toolbar shortcut menu
   -------------------------------------------------------------------

   Standard                               Query and Pivot
   Formatting                             TipWizard
   Chart                                  Stop Recording
   Drawing                                Full Screen
   Forms
   Visual Basic
   Auditing
   WorkGroup
   Microsoft
   [any custom toolbars you create]

Excel 4.0

   On toolbar shortcut menu               Not on toolbar shortcut menu
   -------------------------------------------------------------------

   Standard                               Stop Recording
   Formatting                             Macro Paused
   Utility
   Chart
   Drawing
   Microsoft Excel 3.0
   Macro
   [any custom toolbars you create]

For more information about toolbars, click the Contents and Index tab in Microsoft Excel 97 or Microsoft Excel 98 Help, type the following text

   toolbars, displaying

and then double-click the selected text to go to the "Show or hide a toolbar" topic.

REFERENCES

"User's Guide," version 5.0, Chapter 34

Additional query words: 4.00 5.00 7.00 8.00 97 98 XL98 XL97 XL7 XL5
Keywords : xlui kbui
Version : WINDOWS:4.0,5.0,5.0c,7.0,97; MACINTOSH:4.0,5.0,98
Platform : MACINTOSH WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.