How to Hide and Show Columns using the Group Feature
Step 1: Select the columns you want to group (or hide)
Step 2: Click on the Data Tab and Select Group
Step 3: Choose Columns from the dialog box
Step 4: Select the – icon to hide the Columns
Step 5: Preview the Result
How to Hide Columns in Excel
Microsoft Excel provides two useful features which are to hide and unhide columns and rows. Hiding a column will make that column disappear, it is still present in the sheet but will not appear on the screen.
You can unhide the hidden column anytime whenever you want. Hiding a column is useful if there is private data in that column that you don’t want anyone to have a look at. Using the hide and unhide option we can also hide and unhide rows, columns, and sheets. You can unhide that data when you want your private data visible.