Hide or show rows or columns

Hide or unhide rows and columns in your spreadsheet to show only the data you need to see or print.

Hide columns

1. Select one or more columns.
2. To select additional nonadjacent columns, press and hold Ctrl as you select each column.
3. Select and hold (or right-click) the selected columns, and then select Hide.

Unhide columns

1. Select the adjacent columns for the hidden columns.
2. Select and hold (or right-click) the selected columns, and then select Unhide.
3. Or, double-click the double line between the two columns where hidden columns exist.

Hide rows

1. Select one or more rows.
2. To select additional nonadjacent rows, press and hold Ctrl as you select each row.
3. Select and hold (or right-click) the selected rows, and then select Hide.

Unhide rows

1. Select the adjacent rows for the hidden rows.
2. Select and hold (or right-click) the selected rows, and then select Unhide.
3. Or, double-click the double line between the two rows where hidden rows exist.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

See also

Unhide the first column or row in a worksheet