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.

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

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:

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s