Some quick access features are not enabled by default in Excel, and needed to be added manually. In this article, we are going to show you some of hidden commands in Excel.
How to add hidden commands
We will focus on using the Quick Access Toolbar (QAT) because you can add almost any hidden command on QAT, which is not the case for all features on the Ribbon.
The hidden commands can be found under Excel Options. You can either follow File > Options > Quick Access Toolbar path,
Or right click on any command on QAT and select the Customize Quick Access Toolbar item.
Once the options window is open, follow the steps below to add any hidden commands into Excel.
- Choose All Commands to see all available commands.
- Select all commands you'd like.
- Click the Add button to move features from one list to the other.
- The commands list is on the right.
- Click OK to save your changes.
You can also move the QAT below to the Ribbon. All you need to do is to click on Show Quick Access Toolbar Below the Ribbon item on the right click menu.
This layout can be especially useful for frequently-used features.
Double Underline, Strikethrough, Subscript and Superscript
These text formatting commands can be found under the Format Cells dialog as well. You can find these commands by the following names:
- Double Underline
- Strikethrough
- Subscript
- Superscript
Document Location
You can see the file location, or copy the location as a text from the Quick Access Toolbar. To use this feature, add Document Location hidden command into QAT.
You can copy or enter a file's location and press Enter key to open that file.
Excel Options
Options under All commands gives you a shortcut to Excel Options.
You can also find commands for specific tabs under Options.
Calculation Options
Manual calculations can be useful in large files where you may not want to trigger the calculations with every change. For this, you can add commands for calculation options into your QAT. Either choose Calculation Options to see all of the options under a collapsible list or place these options separately as Automatic and Manual.
Camera Tool Hidden Command
You can create a dynamic image of a range or cell, and move between those quickly. This can be especially useful when working across different worksheets or ranges far apart. Here is the steps:
- Add the Camera command into your QAT.
- Select a range or cell you want to mirror.
- Click on the Camera
- Click on the rectangle, drag it where you want, and release.
Email Attachment as a hidden command
Email command opens your default email client, create a new email with the latest version of your file is attached (with the file's active version saved).
Commands are available for sending your file as a PDF or XPS.