“Toolbar” and menu “Options”

In this lesson we will see our menu bars and “Toolbars” and the adjustable behavior of these.

We can add, delete buttons and arrange the “Toolbars”.

We can even create our own “Toolbars”.

To modify the operations of the “Toolbars”, we choose “Tools” in the menu bar, select “Customize” or right click anywhere on a “Toolbar” and choose “Customize”.

In the “Customize” tab, we select the “Options”.

Check the different “Options” and / or animations to fit your needs, and then click “Close”.

Custom “Toolbars”

We can create our own “Toolbars” from the “Customize” tab in the “Toolbars” option dialog.
We see a whole list of available “Toolbars”.
Those that are checked are visible, those that are not, are hidden.

We click the “New” button in order to create our own “Toolbar”.

We give our “Toolbar” a name, and click OK.

A new “Toolbar” is , of course, without buttons:

Below we will see the buttons.

Add buttons to “Toolbars”

To add buttons to a “Toolbar”, we must first make sure that this “Toolbar” is visible.

Then we choose “Tools” in the menu bar, select ” Customize” to open the “Customize” dialog box.

We choose the “Commands” tab in the dialog.

In the left half of the dialog box we see the different categories and in the right half, the buttons from the selected category in the left half.

To add a button to our “Toolbar”, we first select the category, choose a button and we click and drag it to the right half of the dialog box in the “tool bar” where we want to place it.

If the button is not placed properly, you can still select it and drag it where you want.

Add “Macro” buttons to toolbars

To assign a button to a “Macro” and add it a “Toolbar”, we first make the “Toolbar” visible.

Then we choose “Tools” from the menu bar and select “Customize”.

In the “Customize” dialog box, select the “Commands” tab

We select “Macros” from the list of categories.

We click and drag the “Custom Button” from the “Commands” section to the “Toolbar” where we want the button to be placed.

We right-click on the button we have just placed in our “Toolbar”, and select “Assign Macro …” from the pop-up menu.

In the “Assign Macro” dialog box, we select the “Macro”, and we click on OK.

Removing “Toolbar” Buttons

To remove a button from our “Toolbar”, we first make the “Toolbar” visible.

Choose “Tools” from the menu bar and select “Customize”.

Click and drag the button that we want to remove from our “Toolbar” to the “Worksheet”.

Removing “Toolbars “

We can remove “Toolbars” that we had previously created, but no longer wish to use.

We can also remove “Toolbars” from Excel to which we have added buttons, restore back to factory default settings of Excel.

To remove a “Toolbar” we choose “Tools” from the menu bar and select “Customize”.

In the “Customize” dialog, we select the “Toolbars” tab.

We select our “Toolbar” and click the “Delete” button .

We can not delete a “Toolbar” that comes as standard with Excel.

To restore a “Toolbar” to its original form, we select the “Toolbar”, click on “Reset” and click ‘OK’.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats