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,
Hidden Commands in Excel 01

Or right click on any command on QAT and select the Customize Quick Access Toolbar item.

Hidden Commands in Excel 02

Once the options window is open, follow the steps below to add any hidden commands into Excel.

  1. Choose All Commands to see all available commands.
  2. Select all commands you’d like.
  3. Click the Add button to move features from one list to the other.
  4. The commands list is on the right.
  5. Click OK to save your changes.

Hidden Commands in Excel 04

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.
Hidden Commands in Excel 03

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

Hidden Commands in Excel 05

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.

Document Location in Quick Access Toolbar

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.

Excel Options

You can also find commands for specific tabs under Options.

Hidden Commands in Excel 08

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.

Hidden Commands in Excel 09

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:

  1. Add the Camera command into your QAT.
  2. Select a range or cell you want to mirror.
  3. Click on the Camera
  4. Click on the rectangle, drag it where you want, and release.

Camera Tool

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).

Hidden Commands in Excel

Commands are available for sending your file as a PDF or XPS.

Email as PDF or XPS