Hiding Columns, Rows, and Cells in Excel (Hiding Rows)

You can hide rows containing information that you do not need to view or do not want to print.

1.      Select a cell within the row(s) to be hidden

2.      On the Home command tab, in the Cells group, click FORMAT

3.      From the Format menu, in the Visibility section, select Hide & Unhide » Hide Rows
The row is hidden.

Hiding Rows: Quick Menu Option

1.      Right click the row ID » select Hide
The row is hidden.

Related Posts by Categories