How to Hide Excel Columns?

Select the column or columns you want to hide

Right-click the selected column header

Click Hide

To hide non-adjacent columns, hold Ctrl while selecting the column headers

To hide columns using the ribbon, go to Home

In the Cells group, click Format

Under Visibility, choose Hide & Unhide

Click Hide Columns

To hide columns with a keyboard shortcut, select the columns and press Ctrl+0

To unhide columns, select the columns on both sides of the hidden columns

Right-click and choose Unhide

To unhide using the ribbon, go to Home

Click Format

Choose Hide & Unhide

Click Unhide Columns

Suggested for You

Trending Today