How-To Guide: Hiding and Unhiding Columns and Rows in a Excel Spreadsheet

When printing an Excel spreadsheet, you may have confidential information that you do not wish to print. To avoid printing specific rows or columns with the information, just hide them.

1) To hide adjacent columns

• Click on the column letter and drag to highlight the columns that you want to hide.
• Click on Format.
• From the drop-down menu, select Column.
• Select Hide.
• The columns are now hidden and will not print.

2) To hide non-adjacent columns

• Hold down the Ctrl key and click on the column letters to select the columns that you want to hide.
• Click on Format.
• From the drop-down menu, select Column.
• Select Hide.
• The columns are now hidden and will not print.

3) To hide adjacent rows

• Click on a row number and drag to highlight the rows that you want to hide.
• Click on Format.
• From the drop-down menu, select Row.
• Select Hide.
• The rows are now hidden and will not print.

4) To hide non-adjacent rows

• Hold down the Ctrl key and click on the row numbers to select the rows that you want to hide.
• Click on Format.
• From the drop-down menu, select Row.
• Select Hide.
• The rows are now hidden and will not print.

5) To unhide columns after printing

• Select the entire worksheet (Press Ctrl A or click on the small gray box between Column A and Row 1 (left top corner of the spreadsheet)
• Click on Format.
• From the drop-down menu, select Column.
• Click on Unhide.
• The hidden columns should now be visible.

6) To unhide rows after printing

• Select entire worksheet (Press Ctrl A or click on the small gray box between Column A and Row 1 (left top corner of the spreadsheet)
• Click on Format.
• From the drop-down menu, select Row.
• Click on Unhide.
• The hidden columns should now be visible.
  

 

[Posted on June 29, 2007]