Office Settings & Configuration

Customize the Ribbon and Quick Access Toolbar in Excel for Mac

Adam DavisAdam Davis Nov 22, 2026 868 views

Question details

The user wants to customize the Excel for Mac ribbon and Quick Access Toolbar with frequently used commands.

Customize the Ribbon and Quick Access Toolbar in Excel for Mac
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
After moving from Office 2008 to a newer version of Excel for Mac, the user wants convenient access to commonly used commands.
Observed behavior
Newer versions use the ribbon and Quick Access Toolbar instead of the same customizable floating toolbars available in Office 2008.
Before you start

Open Excel for Mac and identify the commands you want to keep within easy reach. Menu names and available customization options can vary by Excel version.

Solution 1Recommended

Add commands to the Excel for Mac ribbon

Use ribbon preferences to organize frequently used commands into tabs and groups.

1
Open ribbon preferences

In Excel, select Excel > Preferences > Ribbon and Toolbar from the menu bar.

2
Choose the ribbon tab

Select the Ribbon tab. Under Customize the Ribbon, select the tab or group where you want to place commands.

3
Add commands

If needed, create a custom group using the available new-group control. Select a command from the list and use the add control to place it in the group.

4
Save your changes

Select Save to apply the ribbon customization, then check the selected tab for your commands.

Add commands to the Excel for Mac ribbon
Free Microsoft Office alternative

Work with Excel files in WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Its support for common Excel formats helps you move existing files into WPS, though it does not change Microsoft Excel's toolbar settings.

Use a familiar ribbon-style interface for spreadsheet commands.Open and edit Microsoft Excel XLSX and XLS files.Move existing spreadsheets into a lightweight Office alternative.Use WPS Office for free for everyday spreadsheet work.
microsoft office alternative - wps office

Frequently Asked Questions

Where are the ribbon settings in Excel for Mac?

Open Excel and select Excel > Preferences > Ribbon and Toolbar, then choose the Ribbon tab.

How do I add a command to the Quick Access Toolbar?

Go to Excel > Preferences > Ribbon and Toolbar, select Quick Access Toolbar, and use the add control to move a command into the toolbar list. Select Save to apply it.

Can I import my Office 2008 floating toolbar preferences?

Generally, no. Newer Office for Mac versions use a different toolbar system, so you will usually need to re-create your preferred layout with the ribbon and Quick Access Toolbar.

Can I add commands directly to any ribbon group?

Some built-in groups may not be editable. In Excel > Preferences > Ribbon and Toolbar, create a custom group on a tab if needed, then add available commands to that group.