-
To hide: Control-click the column letter or row number and select Hide. From the keyboard, select a row or column, and press ⌘+9 for a row, or ⌘+0 for a column.
-
To unhide: Select the column or row before and after the hidden one, control-click, and choose Unhide. From the keyboard, select a row or column, and press Shift+⌘+9 for a row, or Shift+⌘+0 for a column.
-
To unhide all rows or columns, select the arrow in the upper left to select the whole sheet, control-click a column letter and choose Unhide, and then control-click a row number and choose Unhide.
Tip: You can also select Format > Hide & Unhide on the Home tab, and choose Hide Rows or Hide Columns.
-
To hide: Right-click the column letter or row number and select Hide Rows or Hide Columns.
-
To unhide: Select the column or row before and after the hidden one, right-click, and choose Unhide Rows or Unhide Columns.
-
To unhide all rows or columns, select the arrow in the upper left to select the whole sheet, right-click the sheet and choose Unhide Row, right-click again and choose Unhide Column.
Tip: You can also select Format > Hide & Unhide on the Home tab, and choose Hide Rows or Hide Columns.