Excel shortcuts

How to hide columns in Excel: The ultimate shortcut guide

Hiding columns in Excel is a great way to declutter a worksheet, or to make sensitive data more secure. But it can be a little tricky to know how to hide columns in Excel using the various shortcut methods.

In this ultimate shortcut guide, we'll show you how to hide columns in Excel using the following methods:

  • The Ribbon
  • The right-click context menu
  • The keyboard shortcut

Let's get started!

Method 1: How to hide columns in Excel using the Ribbon

If you want to hide columns in Excel using the Ribbon, first select the columns that you want to hide. Then, click the Home tab on the Excel Ribbon, and click the Hide Columns button, as shown in the image below.

How to hide columns in Excel using the Ribbon

That's all there is to it! The selected columns will be hidden from view.

Method 2: How to hide columns in Excel using the right-click context menu

If you prefer using the right-click context menu to hide columns in Excel, first select the columns that you want to hide. Then, right-click on any of the selected column headers, and click the Hide option, as shown in the image below.

How to hide columns in Excel using the right-click context menu

The selected columns will be hidden from view.

Method 3: How to hide columns in Excel using the keyboard shortcut

If you want to quickly hide columns in Excel using a keyboard shortcut, first select the columns that you want to hide. Then, press the Ctrl+- keys on your keyboard (that's the Ctrl key and the minus sign key).

You'll see a dialog box appear, asking you which columns you want to hide. Select the Entire column option, and click the OK button, as shown in the image below.

How to hide columns in Excel using the keyboard shortcut

The selected columns will be hidden from view.

Bonus tip: How to quickly unhide columns in Excel

If you want to quickly unhide columns in Excel, there are a couple of different methods you can use.

If you know which column you want to unhide, you can simply select the column to the right of the hidden column, and then press the Ctrl+Shift++ keys on your keyboard (that's the Ctrl key, the Shift key, and the plus sign key).

Or, you can click the Home tab on the Excel Ribbon, and click the Unhide Columns button.

You'll see a dialog box appear, asking you which columns you want to unhide. Select the columns you want to unhide, and click the OK button.

That's all there is to it! These are the three methods you can use to hide columns in Excel.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.