How To Customize Quick Access Toolbar In Excel For Mac

  пятница 14 февраля
      19
This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.

For using Excel with all these customized tabs and Quick Access toolbar on another system, first you need to export ribbon settings. Navigate to File menu and click Options. From left side bar, select Customize Ribbon and from main dialog window, under Customizations and from Import/Export options, click Export all Customizations.

Note: You cannot customize the menus or toolbars inEntourage.

  • Office for Windows
  • Office for Mac OS X

Office for Windows

Office 2010 and 2007 feature the Quick Access Toolbar and theRibbon. The default location of the Quick Access Toolbar is in theupper-left corner of the window, to the right of the program icon. Itcontains icons for actions within the program, which remain the sameregardless of which tab is visible on the Ribbon.

The Ribbon is a set of menus and tools that spans the top of Office2010 and 2007 programs. It replaced the menus (e.g., File,Edit, View) that were available in earlier versionsof Office. The Ribbon groups commands previously found in menus ortoolbars into collections based on activities.

Customizing the Quick Access Toolbar

You can display the Quick Access Toolbar in the upper-left cornerof the program or below the Ribbon. To move the Quick Access Toolbar,click the down arrow to the right of the Quick Access Toolbar andchoose Show Below the Ribbon or Show Above theRibbon. Alternatively, you can right-click any blank space in theQuick Access Toolbar or Ribbon, click Customize Quick AccessToolbar.., and then check or uncheck Show Quick AccessToolbar below the Ribbon.

To add and remove commands from the Quick Access Toolbar:

  1. Right-click the Quick Access Toolbar or Ribbon and selectCustomize Quick Access Toolbar... In Office 2007, makesure the drop-down menu under 'Customize Quick Access Toolbar:' is setto For all documents (default).
  2. Select commands you wish to add from the column on the left andclick the Add >> button to move them to the QuickAccess Toolbar.

Note: You can also add commands by locating thedesired command on the Ribbon, right-clicking the command, andchoosing Add to Quick Access Toolbar.

MetaClean is specially designed to clean hundreds documents at once. Offers you three ways to find the files you need in order to view, edit or remove metadata: By navigation window. By selecting. Metaclean for mac.

Customizing the Ribbon

  1. In Office 2010, click the File tab, thenOptions, and then, from the menu on the left, clickCustomize Ribbons.

    In Office 2007, click the Microsoft Office Button, then WordOptions, and then, from the menu on the left, clickCustomize.

  2. Under 'Choose commands from:', use the drop-down menu to specifythe group of commands you want to browse. Under 'Customize theRibbon:', use the drop-down menu to specify the tabs you want tocustomize.
  3. Use the Add >> and << Removebuttons to add and remove commands from the Ribbon. You can alsochoose New Tab.

Customizing Office for Mac OS X

Customizing an existing menu or toolbar

  1. In Office 2011, from the View menu, selectToolbars and then Customize Toolbars andMenus... In Office 2008, from the View menu,select Customize Toolbars and Menus...
  2. To remove an item, click and drag it out of its menu or toolbar.
  3. If you want to add an item to a toolbar or menu, in thecustomize window, click the Commands tab. Under'Categories:', click the category that best describes the item youwant to add. To the right, a listing of items within that categorywill appear. Click the item you wish to add, and drag it into thetoolbar or menu where you wish to place it.
  4. Click OK. The item is now added to the toolbar or menu.

Adding a new menu

  1. In Office 2011, from the View menu, selectToolbars and then Customize Toolbars andMenus... In Office 2008, from the View menu,select Customize Toolbars and Menus...
  2. Click the Toolbars and Menus tab and check MenuBar. This will produce a toolbar that looks like the menu bar atthe top of the screen.
  3. Click the Commands tab. Under 'Categories:', clickNew Menu. In the window to the right, click the new menu anddrag it to the position in the Menu Bar toolbar where you want it toappear.
  4. Right-click or Ctrl-click the new menu baritem and, from the contextual menu, selectProperties... Apply a name to your new menu.
  5. Now you can add items to your new menu. In thecustomize window, click the Commands tab, and thenclick the category that best describes the item that you want toadd. In the window to the right, click and drag the item into thesmall box below your new menu. Repeat this process for all items youwish to add to your menu. When you are finished adding items, clickOK. Your new menu will now appear at the top of the screen,and you will be able to select the items within it to use.