Transferring your Quick Access Toolbar between computers

You can export your toolbar settings to a special file that you can then import into Excel on another computer. You’re out of luck in this regard if you use Excel for macOS, but with Excel for Windows, users can conduct the following steps:

1. Access the Quick Access Toolbar section of the Excel Options dialog box.
2. Click on Import/Export | Export All Customizations, as shown in Figure 3.15:

Figure 3.15 – Exporting customizations

3. Optionally, specify a location and/or a new filename.
4. Click on Save.
5. Transfer the .exportUI file to your new computer, such as via email, or archive the file into a folder of your choice to create a backup of your current customizations.

Carry out these commands on any other Windows computer where you wish to apply the customizations (or restore the settings on your current computer):

6. Access the Quick Access Toolbar section...