Hide or Show Excel Column

Hide or Show Column

Sometime it becomes necessary to hide unnecessary or confidential information in your spreadsheet.

To hide such information in a column, follow the steps below:

1. Select the desired column(s) range using Column Headers

Column Headers

2. Right click on the selection and select Hide from the Context Menu

hide

3. This will hide the select column(s)

select column

To Unhide the hidden column(s), follow the steps below:

1. Select the column on left and right side of the hidden range

column on left and right side

2. Right click on the selection and select Unhide from the Context Menu

unhide

3. This will unhide the hidden column(s) within the selected range

unhide the hidden column