Excel Hack

Excel hide and unhide shortcut

Hiding and unhiding rows and columns is one of the tasks that many users take for granted. In many cases, people probably do this using the mouse. If you do a lot of hiding and unhiding of rows and columns, we recommend using shortcuts. Learning shortcuts will help you work more efficiently and improve your work productivity.

Hide shortcut

Hide rows

hide a row

In the figure above, row 3 is hidden.

Here we explain how to hide the row using shortcut keys. For more information, please see the following article.

Hide rows in Excel shortcut (Ctrl + 9)

Hide columns

hide a column

In the figure above, column B is hidden.

Here we explain how to hide the column using shortcut keys. For more information, please see the following article.

Hide columns in Excel shortcut (Ctrl + 0)

Various methods of hide

In addition to the above shortcuts, there are other ways to hide ribbons, windows, and objects.

For more information, please refer to the following articles.

Hide shortcut in Excel

Unhide shortcut

Unhide rows

Unhide a row

In the figure above, row 3 has been redisplayed.

Here we show how to make the row reappear using shortcut keys. For more information, please see the following article.

Unhide rows in Excel shortcut

Unhide columns

Unhide a column

In the figure above, column B has been redisplayed.

Here is how to unhide the column using the shortcut keys. For more information, see the following article.

Unhide columns in Excel shortcut

Various methods of unhide

In addition to the above shortcuts, there are other ways to unhide the ribbon and window. There is also a way to redisplay data displayed in the same column.

For more information, please refer to the following articles.

Unhide shortcut in Excel