Hide rows in Excel 2007

You can hide rows that do not want to be visible. For example, the row(s) have sensitive data or formulas. One more use of hiding the row(s) is that the information in the hidden row(s) does not get printed. You can hide a single row or multiple rows.
Regarding hiding multiple rows, the rows can be adjacent to each other (for example, hiding rows 2, 3, 4, and 5) or you can hide nonadjacent rows (for example, hiding rows 3, 5, and 7 or 3, 4, 7, and 10). There are several ways to hide row(s) in Excel 2007.

Perform the following to hide row(s):
A. To hide a single row, right click on a row header and from the menu that appears, click Hide.

B. For hiding multiple rows that are adjacent to each other, click the first row header and then press the Shift key. Keeping the Shift key in pressed state, click to select the last row header and then right click on any selected row header and from the menu that appears, click Hide.
C. For hiding nonadjacent rows, click on the first row header and then press the Ctrl key. Keeping the Ctrl key in pressed state, click to select other rows. Once the selection is over, right click on any selected row header and click Hide.

You can also hide row(s) by clicking on any cell in that particular row and then clicking the Home tab, in the Cells group, click Format, point to Hide and Unhide and click Hide Rows. The keyboard equivalent for this is Alt + H + O + U + R (Alt H O U R).

You can also hide row(s) by setting the width of the row to zero. Right click on a row header and click Row Height... From the Row Height dialog box that appears, enter 0 and then click OK.

The quickest way to hide a row is using the keyboard shortcut Ctrl + 9.