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
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 columns
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.
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.
Unhide shortcut
Unhide rows
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 columns
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.
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.