1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Hide Rows in Excel

By

Hide  Rows in Excel

Hide Rows in Excel

© Ted French

Note: This tutorial can be used with all versions of Excel up to and including Excel 2007.

As with all things Microsoft, there is more than one way to hide rows in an Excel worksheet. These instructions show you how to hide rows by right clicking on the row header.

The row header is the gray bar along the left edge of the worksheet containing the row numbers.

Hide Rows in an Excel Worksheet

When you hide a row in a worksheet, data in that row can still be used and referenced in the worksheet.

To hide a single row

  1. Right click on the row header of the row to be hidden.
  2. Choose Hide from the menu.
  3. The selected row and the row number will be be hidden from view.

To hide adjacent rows in the worksheet

For example, you want to hide rows 4, 5, and 6.

  1. In the row header drag select to highlight all of the rows you want to hide.
  2. Right click on the selected rows.
  3. Choose Hide from the menu.
  4. The selected rows and row numbers will be hidden from view.

To hide separated rows in the worksheet

For example, you want to hide rows 3, 5, and 7.

  1. In the row header left click on the first row to be hidden.
  2. Press and hold down the CTRL key on the keyboard.
  3. Continue to hold down the CTRL key and left click on the rest of rows to be hidden.
  4. Right click on one of the selected rows.
  5. Choose Hide from the menu.
  6. The selected rows and row numbers will be hidden from view.
Related Video
Hide Info in Microsoft Excel

©2014 About.com. All rights reserved.