Replicating Excel 2010 Quick Access Toolbar Commands in Excel 365 for Mac

Replicating Excel 2010 Quick Access Toolbar Commands in Excel 365 for Mac

If you're moving from Excel 2010 for Windows to Excel 365 for Mac, you might want to replicate your Quick Access Toolbar (QAT) commands to make the transition smoother. While most commands can be easily added to the QAT in Excel 365 for Mac, some commands, like the Font Name command, are not immediately apparent.

Adding Commands to the QAT in Excel 365 for Mac

To add commands to the QAT in Excel 365 for Mac, follow these steps:

1. Click the Customize Quick Access Toolbar button (the gear icon) located at the end of the QAT.
2. Select More Commands from the drop-down menu.
3. In the Excel Options dialog box, select the category of commands you want to add to the QAT from the Choose commands from drop-down list.
4. Select the command you want to add from the list on the left, and click the Add button to move it to the QAT.
5. Click OK to close the Excel Options dialog box.

Adding the Font Name Command to the QAT

While the Font Name command is not immediately visible in the list of commands in the Excel Options dialog box, you can still add it to the QAT using the following steps:

1. Click the Customize Quick Access Toolbar button (the gear icon) located at the end of the QAT.
2. Select More Commands from the drop-down menu.
3. In the Excel Options dialog box, click the Choose commands from drop-down list and select All Commands.
4. Scroll down the list of commands on the left until you find the Font command.
5. Select the Font command and click the Add button to move it to the QAT.
6. Click OK to close the Excel Options dialog box.

Customizing the Font Command

Once you have added the Font command to the QAT, you can customize it to display the Font Name command. To do this, follow these steps:

1. Click the Font button on the QAT to open the Font dialog box.
2. Click the Font Name drop-down list to display the available font names.
3. Right-click the Font Name drop-down list and select Add to Quick Access Toolbar from the context menu.
4. A new button labeled Font Name will be added to the QAT.

• Most Excel 2010 QAT commands can be easily added to the QAT in Excel 365 for Mac.
• The Font Name command can be added to the QAT by adding the Font command and customizing it to display the Font Name drop-down list.
• Customizing the QAT can help make the transition from Excel 2010 for Windows to Excel 365 for Mac smoother.

References

• Customize the Quick Access Toolbar
• Customize the Ribbon in Excel 365 for Mac