Unhide a Single Row or Column
There’s also a way to unhide a single row or column in Excel. However, you first need to access the row or column that’s hidden.
To do this, type a cell’s location in the Name Box. For example, if you want to unhide both the first row and the first column, enter “A1.”
Finally, press Ctrl + Shift + 9 to unhide a row or Ctrl + Shift + 0 to unhide a column. Likewise, Ctrl + 9 hides a row, and Ctrl + 0 hides a column.
Filtering the Info
The great thing about Excel’s cell hiding capabilities is that you have many methods and routes at your disposal. Not only can you hide cells, but you can also hide rows, columns, and entire sheets. Different people have different approaches to hiding cells, so make sure to find out which suits you best.