Home Computer Repair How to Hide Columns in Microsoft Excel

How to Hide Columns in Microsoft Excel

83

Select a column that you want to hide. If you want to select multiple columns, you should either drag your mouse cursor over them or hold ‘Left Shift’ and click on each column that you want to hide.
Right-click on the selected column or columns. Make sure to move the cursor over the appropriate column letter.
Select ‘Hide.’

This will hide all the selected columns.

Hide Columns By Reducing Width

You can use an out of the box method to hide the columns in Microsoft Excel by reducing them to the minimum width. To do so, you need to follow these instructions:

Select the columns that you want to hide.
Right-click the selected columns.
Choose ‘Column Width.’ A new dialog box will appear.
Set the width of the column to 0.
Click ‘OK.’