How to Hide or Unhide Columns and Rows in Excel

Sandy Writtenhouse Updated 19-03-2020

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, Microsoft Excel makes it easy to do this.


How to Hide Columns and Rows in Excel

Start by selecting the column(s) or row(s) you want to hide. You can do this a few different ways.

Once you make your selection(s), follow one of these two methods to hide the columns or rows.

  • Right-click the selected column or row you want to hide and choose Hide. (This method will not work if you’ve typed in the column or row identifier.)
  • Click the Home tab and in the Cells group, click Format > Hide and Unhide and pick either Hide Rows or Hide Columns.

Excel Hide Columns or Rows

The column or row will be hidden and you’ll see a thin double line indicating where the hidden column or row resides.

Excel Hidden Columns


How to Unhide Columns or Rows in Excel

There are a few ways to select and unhide columns or rows:

  • Right-click the thin double line indicating a hidden row or column and select Unhide.
  • Select the two surrounding columns or rows. On the Home tab in the Cells group, click Format > Hide and Unhide and choose either Unhide Rows or Unhide Columns.
  • To unhide all columns or all rows in your spreadsheet, select all using the keyboard shortcut Control + A (Command + A on Mac), right-click, and pick Unhide.

Excel Unhide Columns Rows

Keep in mind that while you can hide or unhide either multiple columns or multiple rows at the same time, you can’t hide or unhide both columns and rows 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 . And for more ways to work with your data, take a look 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 .

Related topics: Microsoft Excel, Microsoft Office 2016, Microsoft Office 2019, Microsoft Office 365, Microsoft Office Tips, Spreadsheet.

Affiliate Disclosure: By buying the products we recommend, you help keep the site alive. Read more.

Whatsapp Pinterest

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 :)