How to Hide or Unhide Columns and Rows in Excel

If you’re dealing with a data-heavy spreadsheet, sometimes it’s helpful to hide or unhide rows and columns to better see the information you need to analyze. Fortunately, Excel makes it easy to do this.

Unlock the FREE "Essential Excel Formulas" cheat sheet now!

This will sign you up to our newsletter

Enter your Email

How to Hide Columns and Rows in Excel

  • Select the column(s) or row(s) you want to hide. You can select multiple columns or rows that are side-by-side by holding down the Shift key, otherwise you can select multiple cells by holding down the Control key (Command on Mac).
  • Once you’ve made your selection:
    • In the Home tab under the Cells group, click Format > Hide and Unhide > Hide Rows or Hide Columns.
    • Or you can right click on the Excel worksheet in the column or row you want to hide and click hide. (This method will not work if you’ve typed in the row or column identifier.)How to Hide or Unhide Columns and Rows in Excel Excel Hide Unhide Rows Columns e1512419985570
  • The column or row will be removed, and you’ll see a thin double line indicating where the hidden column or row was.

How to Hide or Unhide Columns and Rows in Excel Hidden Excel Column e1512420345841

How to Unhide Columns or Rows

There are a few ways to select which rows or columns you want to unhide:

  • Right click the thin double line indicating a hidden row or column and click Unhide.
  • Click on the thin double line indicating a hidden row or column to select it. If you want to unhide all rows or columns, select all using the keyboard shortcut Ctrl or Command + A. In the Home tab under the Cells group, click Format > Hide and Unhide > Unhide Rows or Unhide Columns.

While you can hide or unhide either multiple rows or multiple columns at the same time, you can’t hide or unhide both rows and columns simultaneously.

Remember, columns and rows are not the only items you can hide and unhide in Excel How to Hide and Unhide Anything You Want in Microsoft Excel In addition to hiding text and values in Excel, you can hide other stuff too! Here's how hiding and unhiding data works in Excel. Read More . We’ve also looked at how to freeze and lock data in Excel How to Freeze, Unfreeze, and Lock Rows, Columns, and Cells in Microsoft Excel One small Excel feature that makes it easier to manage data is the ability to freeze rows and columns. Let's see how it works. Read More .

Whatsapp Pinterest

Enjoyed this article? Stay informed by joining our newsletter!

Enter your Email

Leave a Reply

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

  1. Random_User
    September 20, 2019 at 7:58 am

    Thanks :)