How to display/hide a drop-down list on table headers in Excel

Excel automatically displays a drop-down list at the top of table columns (Headers) when a new table is created. For one reason or the other, one may wish to hide them. Others may not also see any drop-down list at the top of their table columns, a wrong click on the ribbon can inadvertently hide them.

 

Display or hide excel table header

How to Display a header drop-down list

If you just see ordinary column headings (and you know you have a bona fide table), follow the following guide to display them:

Using Short Keys: Click in any of the cells in the table and press Ctrl + Shift + L to show the header drop-down list of the table.

Alternatively:

Using the Mouse: Select Data➝Sort & Filter➝Filter (to get the drop-down lists back)

How to Hide a header drop-down list

This feature is used to toggle on and off, meaning you can use the same short keys to toggle between show and hide the drop-down list as shown below:

Short Keys: Click in any of the cells in the table and press Ctrl + Shift + L to hide the header drop-down list of the table.

Alternatively:

Using the Mouse: Data➝Sort & Filter➝Filter (to get the drop-down lists disappear)

 

Leave a Reply

Your email address will not be published. Required fields are marked *