Customize the Ribbon and Quick Access Toolbar in Excel for Mac
Question details
The user wants to customize the Excel for Mac ribbon and Quick Access Toolbar with frequently used commands.

- 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.
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.
Add commands to the Excel for Mac ribbon
Use ribbon preferences to organize frequently used commands into tabs and groups.
In Excel, select Excel > Preferences > Ribbon and Toolbar from the menu bar.
Select the Ribbon tab. Under Customize the Ribbon, select the tab or group where you want to place 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.
Select Save to apply the ribbon customization, then check the selected tab for your commands.

Customize the Quick Access Toolbar in Excel for Mac
Use the Quick Access Toolbar for commands you want to reach without switching ribbon tabs.
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.

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.




