Templates Services SQL Reports Excel Shortcuts Blog About Contact
⌨ Excel Shortcut Guide

Hide column Shortcut in Excel

Use this quick reference to learn the Windows shortcut, Mac shortcut, Ribbon path, and best use case for hide column in Excel.

Shortcut keys

WindowsCtrl + 0
MacCmd + 0

Ribbon path

Home → Format → Hide & Unhide → Hide Columns

What it does

Hides the selected columns. Select surrounding columns and press Ctrl+Shift+0 to unhide.

How to use this shortcut

  1. Open the Excel workbook and select the relevant cell, row, column, range, or sheet.
  2. Press the shortcut keys shown above for your platform.
  3. Confirm any dialog options if Excel opens a menu or prompt.

FAQ

What is the Excel shortcut for hide column?

On Windows, use Ctrl + 0. On Mac, use Cmd + 0.

Where is hide column in the Excel Ribbon?

The Ribbon path is Home → Format → Hide & Unhide → Hide Columns.

What does hide column do in Excel?

Hides the selected columns. Select surrounding columns and press Ctrl+Shift+0 to unhide.