Spreadsheet Tutorial: How to Hide and Unhide rows and columns in Excel

 

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:

  1. Hiding is useful for printing because anything you hide will not be printed.
  2. 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 a column or row in Excel to hide or unhide.

Right click a column or row in Excel to hide or 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!

Cheers!

This entry was posted in Excel for Beginners, Excel Tricks, Spreadsheet Tutorial. Bookmark the permalink.

2 Responses to Spreadsheet Tutorial: How to Hide and Unhide rows and columns in Excel

  1. i need ‘cascading’ hide/un-hide.
    clicking in (something in) col1 is supposed to un-hide cols 2, 5 and 6.
    clicking col2 is supposed to un-hide cols 2 and 3.
    this explaibs the principle.
    also the ‘way back’ must be possible

    • Michelle says:

      Here’s one option: Select a range of columns (or a single column) & go to Data>Group. Now a +/- control will appear in the margin. Click the +/- to show/hide your selection.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>