Not All Toolbars Listed on Popup Menu

Retired KB Content Disclaimer

View products that this article applies to.

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.

Back to the top

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.

Back to the top

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]

Back to the top

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]

Back to the top

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]

Back to the top

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.

Back to the top

REFERENCES

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

Back to the top

APPLIES TO

Microsoft Excel 97 Standard Edition
Microsoft Excel 98 for Macintosh

Back to the top

kbui KB105451

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top