New flash: Hiding things in Excel isn’t sneaky – they can easily be unhidden!
Ok, so here are a couple of scenarios when you might want to hide a row or column:
- Hiding is useful for printing because anything you hide will not be printed.
- Hiding is useful when doing analysis on a large spreadsheet. You can hide the columns or rows that are not relevant to you and just focus on the ones that are.
How to hide/unhide:
Right click on the letter of a column or number of a row and choose Hide. Initially, a dark line appears where the row or column was, showing you what was hidden, but as soon as you start doing something else in Excel, the line goes away. When a particular column is hidden, the sequence of column letters skip that letter. When a particular row is hidden, the seqence or row numbers skip that number. To unhide a column, such as column B, highlight the columns before and after it (A and C), right click and choose Unhide. This will unhide everything in between the selected columns. The same technique works for rows. Anything you can do vertically in Excel, you can also do horizontally!