How to Hide Columns in Excel using Shortcut
Below is the Datset in which you want to Hide columns B and C.
Step 1: Select the column B and drag it to the column C to select both of the columns.
Step 2: After Selecting the Columns you want to hide, Press “Ctrl+zero(0) “ together.
You can see the result below, after hiding the columns.
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