Hide or unhide a column or row

Hide a column or row

To hide a column or row, follow these steps:

1.Select the desired element or elements.

2.Run the command to hide an element in one of the following ways:

•On the Page layout tab, click  Hide and select the Hide column or Hide row command.

•When working in macOS, select the Table > Hide column / Hide row command from the command menu.

•Right-click the item heading and run the Hide column / Hide row command from the context menu.

•To hide a row, press Ctrl+9 (Windows, Linux) or ⌘Cmd+( (macOS). To hide a column, press Ctrl+0 (Windows, Linux) or ⌘Cmd+) (macOS).

Hidden rows or columns are marked in the heading as shown.

Unhide column or row

The quickest way to display a hidden column or row is as follows:

1.Hover your cursor over the hidden elements marker. The cursor will turn into a double-headed arrow, and the  / button will appear next to it.

2.Click the  / button.

You can also display a hidden column or row as follows:

1.Select the two rows or columns between which the hidden element is located.

2.Run the command to display the element in one of the following ways:

•On the Page layout tab, click  Unhide and select the Unhide column or Unhide row command.

•When working in macOS, select the Table > Show column / Show row command from the command menu.

•Right-click on the headers of the selected columns/rows and run the Show column or Show row context menu command.

•To unhide a row, press Ctrl+Shift+9 (Windows, Linux) or ⌘Cmd+⇧Shift+( (macOS). To unhide a column, press Ctrl+Shift+0 (Windows, Linux) or ⌘Cmd+⇧Shift+) (macOS).

After that, all columns or rows hidden under the marker will be displayed.