Customize Toolbar Excel

The Customize Status Bar popup menu stays open so you can select and deselect multiple options. Simply click anywhere outside the popup menu to close it. In this article, we will describe how some of these options work, and you can also read more about all of the status bar options in Excel. Right-click on the Quick Access Toolbar. Choose Customize the Quick Access Toolbar. Under Choose Commands from, select Separator at the top of the list. Click Add to add to the toolbar. In this, a user needs to select customize quick access toolbar in excel and select the ‘more commands’ option to add the commands. As shown in the below figure of the customize window, the user has to select the commands and click on the add option to add the feature to the toolbar. Toolbar on Excel Step by Step Guide to Customize & Use. Excel Details: Method 1. We can add new, open, save, email, quick print, and redo in excel features to the toolbar. For that, select the customize quick access toolbar button and click on the command you want to add to the toolbar. Click the name of the macro to add in the Choose Commands From list box. Click Add button. To customize the macro button, click the Modify button to change the text and choose a different icon for the macro. When you finish making your Quick Access Toolbar customizations, click OK to close the Excel Options dialog box.

Customize toolbar excel 2016


For use with Word, Excel or PowerPoint


Standard | Formatting | Drawing | Customize

2016

Customize the toolbars


Removing items from active toolbars

If any item on the toolbar is not useful to you it can be removed. I am going to use a floating copy of the Standard toolbar as an example:


In the above toolbar I plan to remove the Insert Hyperlink button


  • From the View menu select Toolbar
  • From the Toolbar submenu select Customize
  • Click on the button you want to remove
  • Click and drag the button until you see an x attached to the pointer
  • Let go of the button and it is removed from the toolbar

Excel
If you can not see the QuickTime movie, select this link.

The same procedure can be used to move a toolbar button to a new location on any toolbar


Restoring items to an active toolbar

To restore any buttons that you removed from a toolbar follow this procedure:

  • From the View menu select Toolbar
  • From the Toolbar submenu select Customize
  • Choose the Toolbars tab
  • Click on the name of the toolbar
  • Select the Reset button
  • Click OK in the Reset Toolbar window

Adding buttons to a toolbar

A large number of toolbars can be added to the window from the View/Toolbar window. However, you may wish to add only a button or two to the open toolbars. There are some actions that I used regularly in Microsoft Works which are not listed on the commonly used toolbars in Word, such as:

  • Insert date
  • 1.5 space and double space

If you browse in the Customize window you may find other examples. In the example below I add the Date button from the Insert menu. The following steps will allow you to add any buttons to any menu:

  • From the View menu select Toolbar
  • From the Toolbar submenu select Customize
  • Choose the Commands tab
  • Select the name of the menu (I used Insert )
  • Scroll in the right window to find the button
  • Click and drag the button to the space on the toolbar where you want the button
  • Release the mouse and the button is placed.


Changing the size of the window displaying the selected font

If I am using the font Arial there is more than enough room to display the font name on the Formatting toolbar. If more room is needed, the size of that window can be decreased. On the other hand, if I am using the font Times New Roman MT Extra Bold the size of the window will be too small to display the entire font name. Using the Customize menu, the window can be re-sized using the following steps:

  • From the View menu select Toolbar
  • From the Toolbar submenu select Customize
  • When the Customize window appears click on the font name window
  • When the black box outlines the window put your cursor on the right edge of the window
  • When your cursor changes to a double-headed arrow click and drag


Using the Symbol toolbar button

I often use symbol characters in documents I produce. On my Macintosh I use Keycaps to find the symbols, and on my IBM I use the Character Map. However, Word has a toolbar button which is easier to use than either of those two applications.

Using the steps outlined above I added the symbol button (Greek letter Omega) from the Insert menu. One click on this button brings up a window with all available characters in a given font. Click once on a character to see an enlarged view. Double-click a character to insert it into the document

If you perform any task repetitively in Word, there is probably a button to use for the task. Search the Customize/Commands window to find what you are looking for.


Tasks to be performed before moving to the next window

Caution: Do not close Netscape . Leave this window open so you can move from Word to this page and back to Word. On a Windows 95 or higher computer this can be accomplished with the task bar buttons. On a Macintosh computer you can go to the Application Menu (some people call it the Finder) at the top right corner of the screen to move from one application to another.

Open Microsoft Word. If the Standard toolbar is not displayed go to the View menu and select it.

Task 1: Remove the hyperlink button from the Standard toolbar, If you do not remember how to do that, go back to that part of this lesson .

Customize Excel Toolbar Mac

Task 2: Restore the hyperlink button to the Standard toolbar, If you do not remember how to do that, go back to that part of this lesson .

Task 3: Add the Date button to the Formatting toolbar, If you do not remember how to do that, go back to that part of this lesson .

Task 4: Change the size of the window which displays the font name in the Formatting toolbar. If you do not remember how to do that, go back to that part of this lesson .


After you have completed all four tasks, move on to the next subject, 'Using Menu items in Word'

Other toolbars

Customize Toolbar Excel Mac 2016


Standard | Formatting | Drawing | Customize Go to Using Word menu items, part 1 ( Macintosh ) Go to Using Word menu items, part 1 ( IBM )

Customize Toolbar Excel 2010

Go back to Excel Index or Word Index