Excel Hack

Hide columns in Excel shortcut (Ctrl + 0)

The easiest way to hide columns in Excel is to use shortcut and access keys: hide multiple columns instead of just one, hide from the context menu, hide from the selected column to the last column of data, etc. Learn about shortcut keys and access keys to use Excel more efficiently.

Hide columns shortcut

Windows
Ctrl + 0 (zero)
Access Key: Alt + H + O + U + C

Mac
command + 0 (zero) or control + 0 (zero)

Use shortcut keys to hide columns

This section describes how to hide a column using the shortcut keys.

Total Time: 1 minute

Select a cell

Select a cell

Select one cell in the column you want to hide.

Column is hidden

Column is hidden

To hide a column, Press Ctrl + 0 (zero). Or Press Alt + H + O + U + C.

Hide a column in the context menu

Select a cell

Select any cell in the column you want to hide.

Select Hide in the context menu

Press Ctrl + Space to select the column containing the selected a cell. Press Shift + F10 and select Hide.

Column is now hidden

The selected column is hidden.

Hide multiple columns

Select a cell

Select any cell in the column you want to hide.

Select only one column

Press Ctrl + Space to select the column containing the selected a cell.

Select multiple columns

Press Shift + (Right Arrow key) to select multiple columns.

Column is now hidden

Press Ctrl + 0 (zero) to hide multiple selected columns.

Hide all columns to the right of the last column of data

Select a cell

Select any cell in the column you want to hide.

Select only one column

Press Ctrl + Space to select the column containing the selected a cell.

Select all columns to the right of the last row of data

Press Ctrl + Shift + (Right Arrow key) to select up to the last column of data in the table.

Column is now hidden

Press Ctrl + 0 (zero) to hide the selected column.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments