Click File Options Quick Access Toolbar. Right-click anywhere on the ribbon and select Customize Quick Access Toolbar from the context menu. Click the Customize the Quick Access Toolbar button (the down arrow at the far-right of the QAT) and choose More Commands in the pop-up menu. On your Mac, click the Finder icon in the Dock to open a Finder window. Do any of the following: Hide or show the sidebar: Choose View Hide Sidebar or View Show Sidebar. (If Show Sidebar is dimmed, choose View Show Toolbar.) Resize the sidebar: Drag the right side of the divider bar to the right or left.

Full Quick Access Toolbar Support For Office For Mac Pro
Full Quick Access Toolbar Support For Office For Mac Windows 10
Full Quick Access Toolbar Support For Office For Mac 2017
Full Quick Access Toolbar Support For Office For Mac 2016
Full Quick Access Toolbar Support For Office For Mac Windows 7

No matter where you go in Office 365, you see the Quick Access toolbar in the upper-left corner of the screen. This toolbar offers the AutoSave, Save, Undo, and Redo buttons, as well as the Touch/Mouse Mode button if your computer has a touchscreen.

However, which buttons appear on the Quick Access toolbar is entirely up to you. You can put your favorite buttons on the toolbar to keep them within reach. And if the Quick Access toolbar gets too big, you can move it below the Ribbon, as shown. Adding buttons to and removing buttons from the Quick Access toolbar is, I’m happy to report, a piece of cake. And moving the toolbar below the Ribbon is as easy as pie.

How to add buttons to the Quick Access toolbar

Use one of these techniques to add buttons to the Quick Access toolbar:

Right-click a button you want to see on the toolbar and choose Add to Quick Access toolbar on the shortcut menu. You can add all the commands in a group to the Quick Access toolbar by right-clicking the group name and choosing Add to Quick Access toolbar.
Click the Customize Quick Access toolbar button (located to the right of the Quick Access toolbar) and choose a button on the drop-down list. The list offers buttons deemed most likely to be placed on the Quick Access toolbar by the makers of Office.
On the File tab, choose Options, and go to the Quick Access toolbar category in the Options dialog box (or right-click any button or tab and choose Customize Quick Access toolbar on the shortcut menu). You see the Quick Access toolbar category of the Options dialog box, as shown. On the Choose Commands From drop-down list, select the name of the button you want to add to the Quick Access toolbar. Then click the Add button.

To restore the Quick Access toolbar to its original buttons, click the Reset button in the Options dialog box and choose Reset Only Quick Access toolbar on the drop-down list. Choosing Reset All Customizations resets Ribbon customizations as well as Quick Access toolbar customizations.

How to change the order of buttons on the Quick Access toolbar

Follow these steps to change the order of buttons on the Quick Access toolbar:

Click the Customize Quick Access toolbar button and choose More Commands on the drop-down list.
The Quick Access toolbar category of the Options dialog box appears. You can also open this dialog box by right-clicking any button or tab and choosing Customize Quick Access toolbar.
Select the name of a button on the right side of the dialog box and click the Move Up or Move Down button.
These arrow buttons are located on the right side of the dialog box.
Repeat Step 2 until the buttons are in the right order.
Click OK.

How to remove buttons from the Quick Access toolbar

Use one of these techniques to remove buttons from the Quick Access toolbar:

Right-click a button and choose Remove from Quick Access toolbar on the shortcut menu.
Right-click any button or tab and choose Customize Quick Access toolbar. You see the Quick Access toolbar category of the Options dialog box. Select the button you want to remove on the right side of the dialog box and click the Remove button.

You can click the Reset button in the Options dialog box to remove all the buttons you placed on the Quick Access toolbar.

Placing the Quick Access toolbar above or below the Ribbon

The Ribbon runs along the top of the screen where the tabs and buttons are found. If your Quick Access toolbar contains many buttons, consider placing it below the Ribbon, not above it. Follow these instructions to place the Quick Access toolbar above or below the Ribbon:

Quick Access toolbar below the Ribbon: Right-click the toolbar, and on the shortcut menu, choose Show Quick Access toolbar Below the Ribbon.
Quick Access toolbar above the Ribbon: Right-click the toolbar, and on the shortcut menu, choose Show Quick Access toolbar Above the Ribbon.

The Options dialog box offers a check box called Show Quick Access toolbar Below the Ribbon. You can select this check box as well to move the toolbar below the Ribbon.

Most of the blog posts that deal with customizing the toolbars on Microsoft Office products are written for PC users. Now that MS Office has become the standard for office applications on the Apple Macintosh OS, too, let’s discuss how to customize the Excel toolbar on a Mac. Please note that these instructions are for the Office 2016 version of the software.

Add/Remove Commands to the Ribbon Toolbar

To access the configuration screen for the Ribbon toolbar, open a new workbook in Excel and then go to the Preferences menu and select Ribbon and Toolbar. The screen that comes up is of the double list box variety. If you’re unfamiliar with this type of screen, basically you have two boxes with buttons in between them that have arrows facing in opposite directions. You can move items in either of the lists back and forth to the other by selecting an item from the list you want to move the command from and then hitting the arrow button of the direction you wish to move it to.

You can also change the order in which the commands appear by dragging them up or down the list as you wish. There are also drop down list controls at the top of each box so that you can select which category in the toolbar that you want the command to come from or go to. This gives you the most flexible interface for customizing the ribbon toolbar any way you desire. Below is an example image of the Ribbon Toolbar configuration screen.

Adding/Removing Toolbar Tabs or Groups

By default, when you open the toolbar configuration screen, it opens with a list of the main tabs in the right-hand box and a list of available commands in the left-hand box. To access the other tabs, you can select another category from the Customize the Ribbon drop down list. If you want to create your own tabs or groups that contain a custom list of commands, you can create a new tab by clicking the + button at the bottom of the Ribbon Customization list box and selecting New Tab or New Group from the context menu that appears.

Full Quick Access Toolbar Support For Office For Mac

If you decide that there are too many tabs and they are cluttering up your user experience, then you can select the tab you want to go away and then select the – button at the bottom of the Ribbon Customization list box. If you want to rename the tab or group, select it in the list and then can click the gear button to the right of the – button. This will give you the settings context menu that will allow you to make changes.

Full Quick Access Toolbar Support For Office For Mac