Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/105451

From BetaArchive Wiki

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.

REFERENCES

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


Additional query words: 8.00 97 98 XL98 XL97 XL7 XL5 XL

Keywords: kbui KB105451