Excel can be quite powerful if you can apply it expertly. Excel carries various hidden features that enable you to improve your work efficiency. And today we will introduce the Excel tips on customizing Quick Access Toolbar.
The Quick Access Toolbar lies in the top of the Excel interface. In this part, you can add your commonly used function into the toolbar. You may hold the idea that this part is useless, because you can still use the functions through other ways. But actually, the Quick Access Toolbar can shorten your work hours and improve your work efficiency. Now let’s see some tips about the Quick Access Toolbar.
The Tip of Adding Functions
- Click the drop-down menu on the right of the toolbar.
- In the drop-down menu, click the options that you need in your work. Once selected, this option will immediately appear on the toolbar.
- Choose the “More Commands…” option and you will see a new pop-up box. This is the box of “Excel Options”. You can also open this box through the following steps: Files>Option>Quick Access Toolbar.
- Here you can choose more functions as is shown in the pictures below.
- Click “OK” to save your settings. And the next time you need to use any of the functions, you can click at the toolbar directly instead of find it in the Ribbon.
The Tip of Backup Settings
Here is another tip about the quick access toolbar. Sometimes the Excel may get corrupted and all the settings might disappear. You have to customize the toolbar again, and this is really a tiring work. Here is a method of backing up all the settings in case some unexpected accidents happen. You can use the “Import and Export” function to prepare for such accidents.
- Open the box of “Excel Options”. You may refer to the step 3 in the previous part to open it.
- In the lower right corner of the window, you can see a button of “Import/Export”.
- Then choose to export your customization.
And then you can save the settings in the specified directory.
The Tip of Recover Settings
Even if the Excel is damaged, you can still recover your settings. Just follow those steps:
- Open the box of “Excel Options”.
- Click the button of “Import/Export”.
- Choose “Import customization file” and choose the file that you have exported before.
In this way, all the settings are retained. And you don’t need to do worry about the tiring work of resetting.
Sometimes, the Excel is damaged severely and you couldn’t recover your settings. Or you may lose the exported files by various reasons. You can use a third-party recovery tool to repair Excel. Recovery tool can make the best effort to recover the lost data.
Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit www.datanumen.com