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
- Select the column headings you want to hide.
- Click Home > Column > Hide Columns.
The selected columns will be hidden. - Select the headings of the columns before and after the hidden columns.
- 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.