Commands Not in the Ribbon

One of my favorite areas to explore in Excel is the Commands Not in the Ribbon listing in the Quick Access Toolbar section of Excel’s Options dialog box. Sometimes, you can find enhanced versions of built-in commands that streamline tasks or enable hidden functionality. In addition, you might be able to unearth and restore commands that Excel has removed from the Ribbon.

Enhanced commands

First, let’s look at versions of commands that offer functionality that you can’t accomplish through Excel’s Ribbon. I’ll show you how to add and then use the AutoFilter command in Excel for Windows, which enables you to filter a list based upon a single cell’s contents with one click:

1. Access the Quick Access Toolbar section of the Excel Options dialog box.
2. Click on Choose Commands From | Commands Not in the Ribbon.
3. Click once on AutoFilter in the left-hand column. Then, click on Add (or double-click on AutoFilter...