Home Computer Repair How to Hide Columns in Microsoft Excel

How to Hide Columns in Microsoft Excel

83

Click the ‘Developer’ tab on the top of the window.
Select ‘Visual Basic.’
Double click on ‘Sheet 1’ (or any other working sheet with the columns that you want to hide).
Select ‘Insert.’
Click on ‘Procedure.’
Type in the procedure name.
Insert the following code: Worksheets(“Sheet1”).Columns(“C”).Hidden = True
Save the sheet as an .xlsm file.
Select ‘Run’ tab in the VBA window.
Click on ‘Run Sub/User Form.’

This will hide the ‘C’ column on the ‘Sheet 1’, as stated in the code above. For every column that you want to hide, you should repeat the process and replace the column letter in the code.

How to Unhide Columns in Excel

It is relatively easy and straightforward to unhide columns in Excel. There are two easy methods to make them appear again.