Hide or unhide columns

Hide Columns/Unhide Columns

Click Home > Column > Hide Columns to hide the selected columns. Click Home > Column > Unhide Columns to display the hidden columns on the screen.

Steps

To hide/show columns

  1. Select the column headings you want to hide.
  2. Click Home > Column > Hide Columns.
    The selected columns will be hidden.
  3. Select the headings of the columns before and after the hidden columns.
  4. Click Home > Column > Unhide Columns.
    The hidden columns will be displayed.

Note

Hiding Multiple Columns

To hide multiple columns, select multiple column headings as a block and click Home > Column > Hide Columns.

Using Context Menu

If you use the context menu, you can hide columns quickly. If you select column headings, press the right mouse button, and select Hide Columns in the context menu, you can hide the selected columns. If you select the headings of the columns before and after the hidden columns and click Unhide Columns, you can display the hidden columns again.

Was this article helpful?
0 out of 0 found this helpful