Show or hide rows and columns

• 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.