You may or may not know that you can hide and unhide rows and columns in Excel. There are many reasons why you would want to use this feature, such as when you have huge worksheets, you sometimes have to scroll back and forth to access the data you need. It is certainly easier to have the data you need right in front of you!
Follow the steps below to learn how to Hide and Unhide rows and columns:
- To hide a single column, select any cell in that column and click CTRL + 0 (zero).
- To hide a single row, select any cell in the row and click CTRL + 9.
- Alternatively, to unhide a row that you have previously hidden, select the range and click CTRL + Shift + 9.
- To unhide a previously hidden column, select the range and click CTRL + Shift + 0 (zero).
When you have hidden columns, you will notice a light coloring between your columns which indicates that a column has been hidden between them.