Lesson 10


The Quick Access Toolbar

The quick access toolbar shown in FIGURE 1 illustrates its toolbar icons from left-to-right: Save, Undo, Redo, New, Save As, and Open. To the right of the Open icon is a downward pointing arrow, when selected, will show a drop-down menu of choices.

Note: the default icons that appear are Undo, Redo, and Save.

Figure 1

To add additional icons to the quick access toolbar, on the right-end of the toolbar there is a downward-pointing arrowhead. Click on it and you will see a drop-down menu as shown in FIGURE 2, “Customize Quick Access Toolbar”. The items with checkmarks show that those items are already on the Quick Access toolbar. To add an item to the toolbar, simply select it with a mouse.

To see additional commands not shown on the drop-down menu, select “More Commands” near the bottom. See the section below, “Customize the Quick Access Toolbar”.

Figure 2

Customize the Quick Access Toolbar (FIGURE 3)

On the left side list select the feature(s) desired, press the “Add” button, and the feature will appear on the right-side list. You can use the up/down arrows to position where you want this added feature to be located on the toolbar. To remove an item, select it from the toolbar right-side list and then select the “Remove” button.

You can also add features from the Ribbon to the toolbar by right-button mouse clicking the icon on the Ribbon. From the mouse shortcut menu, select Add to the Quick Access Toolbar.

Figure 3

You can also add additional commands to the Quick Access Toolbar by right-button mouse clicking the Quick Access Toolbar and select “Customize Quick Access Toolbar” from the mouse shortcut menu. We can see this action in FIGURE 4 below.

Figure 4

Mini Toolbar

The mini toolbar was rolled out with Office 2007 and is still a feature in Office 2016. It is a smaller version of the Standard/Formatting toolbars used in previous Excel versions. Unfortunately, you cannot add or remove commands to the mini-toolbar.

You’ll see 2 versions of the Mini Toolbar based on 2 conditions:

Condition 1 – highlighting data in a cell (FIGURE 5)
Condition 2 – right-button mouse click a cell (FIGURE 6)

Highlighting data in a cell (FIGURE 5)
   Right-button mouse click a cell (FIGURE 6)

The mini toolbar appears when you highlight data in a cell (FIGURE 5) or right-button mouse click a cell (FIGURE 6), although it will contain the bigger toolbar with more features if you right click the data. If you move the mouse away from the smaller version mini toolbar it will gradually fade until it completely disappears.

The mini toolbar features some of the most commonly used text formatting functions. These same formatting functions are in the Font section of the Ribbon. The icon symbols are shown below:

  • Bold 
  • Italics
  • Font Color
  • Increase/Decrease Font Size
  • Change Font Family (I.E. Change Calibri to Times New Roman)


Back to: Intro to Excel 2016 > Module 3 Intro to Excel 2016

Leave a Reply