Ctrl + 0 in Excel: Hide a Column

Have you ever wanted to hide a column in Excel without right-clicking the column letter?

You can do this quickly using a simple keyboard shortcut: Ctrl + 0.

Let’s see how it works.

Keyboard Shortcut to Hide a Column in Excel:

The keyboard shortcut to hide a column in Excel is:

Ctrl + 0

How to Hide a Column Using Ctrl + 0?

Follow these steps:

1. Open your Excel worksheet.

2. Click any cell in the column you want to hide.

3. Press Ctrl + 0 on your keyboard.

Excel hides the selected column.

For example, if you click cell C4 and press Ctrl + 0, Excel hides Column C.

The data in the column is not deleted. It is simply hidden from view.

Important: Press the 0 (zero) key in the main number row above the alphabet keys. Do not use the 0 key on the numeric keypad on the right side of your keyboard.

Practical Example:

Suppose you have the following sales data:

Employee	Department	Region	Sales
Ravi	Sales	East	25000
Priya	Marketing	West	30000
Kiran	Finance	South	20000

If you want to hide the Region column:

1. Click any cell in the Region column, such as C2.

2. Press Ctrl + 0.

Excel hides Column C. The Employee, Department, and Sales columns remain visible.

You can use this shortcut when you want to hide information temporarily without deleting it.

Can You Hide Multiple Columns Using Ctrl + 0?

Yes. You can hide multiple columns using the same shortcut.

1. Select the columns you want to hide.

2. Press Ctrl + 0.

Excel hides the selected columns.

For example, if you select Columns B and C and press Ctrl + 0, Excel hides both columns.

Important Things to Remember:

• Ctrl + 0 hides columns; it does not delete them.
• You can hide one column or multiple selected columns.
• Hidden column data remains in the worksheet and can still be used in formulas.
• If the shortcut does not work, check whether your keyboard settings or system shortcuts are interfering.

Excel Shortcuts to Hide and Unhide Rows and Columns:

Excel has four useful keyboard shortcuts to hide and unhide rows and columns.

Action	Keyboard Shortcut	Learn More
Hide columns	Ctrl + 0	How to Hide Columns in Excel
Unhide columns	Ctrl + Shift + 0	How to Unhide Columns in Excel
Hide rows	Ctrl + 9	How to Hide Rows in Excel
Unhide rows	Ctrl + Shift + 9	How to Unhide Rows in Excel

Tip: Select the relevant row or column before using a hide shortcut. To unhide rows or columns, select the surrounding rows or columns that include the hidden ones, then use the appropriate shortcut.

Frequently Asked Questions:

1. What is the shortcut to hide a column in Excel?

Press Ctrl + 0 to hide the selected column or columns.

2. Does hiding a column delete its data?

No. Hiding a column only removes it from view. The data remains in the worksheet.

3. How do I unhide a column in Excel?

Select the columns on both sides of the hidden column, then right-click the selection and choose Unhide or Or you can use a keyboard shortcut Ctrl + Shift + 0 in Excel to Unhide Columns.

You can also read our guide on Hide and Unhide in Excel.

Final Thoughts:

The Ctrl + 0 shortcut is a quick way to hide columns in Excel without using the mouse to open a menu.

It is useful when you want to temporarily hide columns that are not needed in your current view.

For more useful shortcuts, visit our Excel Keyboard Shortcuts page.