Open sesame with Alt+↓

Alt+ is absolutely one of my frequently used shortcuts when using Excel.

What it does?  “Open sesame” under four common circumstances. 🙂

When you are at the bottom of a column

Excel Tips - Alt Down 1  Alt+↓ displays the list of items on the column.  

So good for inputting value without retyping –> Minimize chance of typo

When you are on the top row of a table with auto filter on  

Excel Tips - Alt Down 2 Alt+↓ opens the filter box. (Same effect as clicking the drop down button)

When you are on a cell with Data Validation (validated by list)

Excel Tips - Alt Down 4.pngAlt+↓ opens the available options for the cell.  (Same effect as clicking  the drop down button)

When you are on a row/column label / report filter on Pivot Table

Excel Tips - Alt Down 3.png Alt+↓ opens the filter box for the field. (Same effect as clicking  the drop down button)

To make it short, Alt+ opens available option, if any, of the active cell.

Here’s a short video to show it in action:


Did I miss anything about Alt+?  Or do you have other usage of Alt+↓?  Please share with us by leaving comment.


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Shortcut and tagged . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.