Home Computer Repair How to Hide Columns in Microsoft Excel

How to Hide Columns in Microsoft Excel

83

The selected columns will disappear the same way as the in the method described above.

Hide Columns Using a Hotkey

If your mouse isn’t working properly, you can rely on your keyboard to hide your columns just as efficiently. Follow these steps:

Select the columns with your mouse or keyboard. On the keyboard, press ‘Ctrl + Space’ to select the whole column. You can only select adjacent columns using this method.
Press ‘Ctrl + 9.’

This will hide the selected column.

Hide Columns via Visual Basic

Newer versions of Microsoft Excel have the ‘Visual Basic’ option where you can enter a manual code to hide a column. This is the most complicated process you can use to hide columns.