How to Hide Excel Columns by Setting the Column Width as Zero
Now In the same Dataset, you want to hide columns C.
Follow the steps to hide column C by Setting the width as Zero.
Step 1: Select the Column you want to hide.
Step 2: Right-click on the Selected column, Choose “Column width”, set it to 0, and click “ok”.
Now, You can see in the below image column C is hidden.
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.
Contact Us