Microsoft KB Archive/105451

= Not All Toolbars Listed on Popup Menu =

Article ID: 105451

Article Last Modified on 8/15/2003

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q105451



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.

