Excel 2013, 2010 or 2007: Unhide Rows or Columns

If you can’t see certain rows or columns in Microsoft Excel 2013, 2010, or 2007, it may be because they are hidden. Here’s how to unhide rows or columns.

1. Select the columns or rows that are before and after the one you would like to unhide.

Select Columns

2. Select the Home tab.

3. In the Cells area, select Format > Hide & Unhide > Unhide Columns or Unhide Rows.

Select unhide columns

4. The column or row should now be unhidden.

Hidden columns are displayed


  1. S Monroe says

    Just what I was looking for … a quick and easy way to unhide columns. Thanks so much!

  2. mac says

    what if the hidden rows or columns are at the top or left of the sheet? How can I select those?

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>