How to Hide Columns in Excel Using Keyboard Shortcuts

How-to basics · Updated November 20, 2026

To hide a column in Excel for Microsoft 365 on Windows, select a cell in it, press Ctrl+Space to select the whole column, then press Ctrl+0 (zero). To hide several adjacent columns, select them first and use the same hide shortcut. The cells and their contents remain in the workbook; hiding only removes the columns from view.

You can use the keyboard to select columns, hide them, and bring them back later. Save your workbook first if you are making a substantial change, especially if you are still learning the shortcuts. The steps below are for Excel on Windows; Mac and web differences are noted where they matter.

What You’ll Need

  • A workbook open in the Excel desktop app. The Windows shortcuts below apply to Microsoft 365 for Windows.
  • A keyboard with a Ctrl key. On some compact keyboards, you may need to use Fn or a function-layer key to enter the number zero.
  • For several columns, know their letters, such as C:E for columns C through E. You can select them using Excel’s Go To dialog without using the mouse.

Step-by-Step

  1. Choose the column or columns. Click a cell in the column you want to hide, or move to one with the arrow keys. Press Ctrl+Space to select the entire worksheet column. If you only select cells, the hide command may not behave as intended, so check that the column letter at the top is highlighted and the selection extends from the top to the bottom of the sheet.

    To select multiple adjacent columns with the keyboard, press Ctrl+G to open Go To, type a whole-column reference such as C:E in the Reference box, and press Enter. Excel selects columns C, D, and E together. Replace the letters with the range you need. You can also select a column by its header, then extend the selection across neighboring headers with the keyboard, but Go To is a direct option when you already know the column letters.

  2. Hide the selection. With the full column or columns selected, press Ctrl+0. The selected columns disappear, and the visible columns on either side move together. On a laptop, use the zero on the main keyboard row if the numeric keypad version does not work. Do not press Ctrl plus the letter O; the shortcut uses the number zero.
  3. Check that the right columns were hidden. Look at the column letters above the worksheet. If you hid column C, for example, the headers may go from B directly to D. A small gap or divider between headers can also indicate hidden columns. The missing letters are a clearer clue than the worksheet contents, because blank columns can be hidden too.
  4. Hide another separate column if needed. Move to a cell in the next column, press Ctrl+Space, and then press Ctrl+0 again. If the columns are not next to each other, hiding them one at a time is straightforward. For adjacent columns, select the full range together first to hide them in one action.
  5. Unhide columns when you need them again. Select the columns on both sides of a hidden range, including the hidden columns in the selection, then press Ctrl+Shift+0. For example, if D and E are hidden, select C:F using Ctrl+G and press Enter, then use the unhide shortcut. If the hidden columns are at the edge of the sheet, include the edge in your selection; for hidden column A, select A:B.
  6. Save the workbook. Hiding is a view and layout change, not a deletion, but save when you have finished arranging the sheet. If the workbook is shared, remember that column visibility is part of the workbook’s saved state, so other people may see the same columns hidden when they open it.

On a Mac: In Excel for Mac, select the column or columns, then press Command+0 to hide them. The unhide shortcut is Command+Shift+0. You can select a whole column with Control+Space in many Mac keyboard configurations, or use Go To and enter a range such as C:E. If macOS or a keyboard layout intercepts a shortcut, use the Excel menu or ribbon instead. In Excel for the web, shortcut behavior can vary by browser; use the column-header context menu or the ribbon’s hide and unhide commands if the desktop shortcut is not available.

Common Mistakes

  • Using the letter O instead of zero. Ctrl+0 contains the numeral zero. It is easy to confuse the two on a keyboard, but Ctrl+O opens a workbook dialog rather than hiding a column.
  • Selecting cells rather than whole columns. If you drag across a few cells and use a hide command, you may not get the intended result. Use Ctrl+Space or Go To with a whole-column reference such as C:E, and verify that the column headers are selected before hiding.
  • Thinking hide means delete. Hidden cells still contain their values and formulas. Other formulas can continue to refer to them, and unhiding restores the contents. If your goal is to remove data permanently, hiding is not the right action; deleting columns is a separate operation and can affect formulas.
  • Assuming hidden data is protected. Hiding is not a security feature. Anyone who can edit or inspect the workbook may be able to unhide the columns, and hidden values can still be included in calculations. Do not hide confidential information as a substitute for access controls or appropriate file protection.
  • Expecting Ctrl+Shift+0 to work on every Windows setup. This unhide shortcut may be intercepted or unavailable because of a Windows keyboard setting, regional keyboard layout, or device configuration. If nothing happens, use the ribbon route in Troubleshooting rather than repeatedly changing the worksheet selection.

Tips

  • Use Go To for a precise range. Press Ctrl+G, enter C:E, and press Enter to select columns C through E. This can be easier than scrolling across a wide sheet or trying to extend a selection across many headers. Use a single letter, such as F:F, if you want to select one entire column by reference.
  • Keep a note of hidden columns. In a complex workbook, write down why a range is hidden or add a nearby note in a visible cell. This helps colleagues understand that the columns contain supporting figures, helper calculations, or details they should reveal when reviewing the sheet.
  • Use grouping when people need to expand and collapse sections repeatedly. Excel’s outline grouping feature gives users a plus or minus control for showing and hiding a set of columns. It is more discoverable than a hidden range, although it is not the same as the Ctrl+0 shortcut. Look under Data > Group to create a group after selecting the columns.
  • Check print output and formulas separately. Hiding columns changes what is visible, but it does not automatically mean that their values are removed from calculations. If you are preparing a report, use Print Preview to confirm the layout. Also check any formulas or charts that depend on the hidden range.
  • Use the mouse only as a fallback, not as a requirement. If the keyboard shortcut is blocked, right-click the selected column headers and choose Hide. For unhide, select the headers around the gap, right-click, and choose Unhide. The ribbon route is another option and is useful when you cannot tell which keyboard shortcut is being intercepted.

Troubleshooting

Ctrl+0 does nothing: First click a worksheet cell, select its whole column with Ctrl+Space, and try again. Make sure you are in Excel rather than editing text inside a cell; press Esc to leave edit mode, then repeat. Confirm that you are pressing zero, not O. If your keyboard has a numeric keypad, try the zero on the main row or use the other zero key. If the shortcut remains unavailable, select the column headers and use Home > Format > Hide & Unhide > Hide Columns.

The wrong range disappears: Undo immediately with Ctrl+Z, then check the selection before hiding again. If you used Go To, confirm the reference: C:E means three columns, while C:C means only column C. The selection may also have been affected by being inside a table or by starting with the wrong active cell. Use the column letters as a final check before pressing Ctrl+0.

You cannot see where the hidden columns are: Look for a jump in the column letters, such as B followed by E, or select a known range with Ctrl+G. To reveal a range, include the columns immediately before and after it in the selection, then press Ctrl+Shift+0. If you do not know which columns are hidden, select the entire worksheet using the Select All button at the top-left corner of the grid, then use the ribbon command Home > Format > Hide & Unhide > Unhide Columns. This reveals all hidden columns on that sheet.

The unhide shortcut does not work: On Windows, use the ribbon path Home > Format > Hide & Unhide > Unhide Columns, or right-click a selection that spans the hidden columns and choose Unhide. On a Mac, use the equivalent Excel menu or ribbon command if Command+Shift+0 is intercepted. If you are working in a protected worksheet, the protection settings may prevent changing column visibility; ask the workbook owner to allow the change or unprotect the sheet if you have permission.

Frequently Asked Questions

What is the keyboard shortcut to hide a column in Excel?
On Windows, select the column and press Ctrl+0. On Mac, use Command+0. The shortcut hides the selected full column or columns.

Can I hide several columns at once?
Yes. Select adjacent columns together, for example by pressing Ctrl+G and entering C:E, then press Ctrl+0 on Windows. For separate columns, select and hide each one in turn.

How do I unhide a column with the keyboard?
Select a range that includes the hidden column and at least one visible column on each side, then press Ctrl+Shift+0 on Windows. On Mac, the equivalent is Command+Shift+0. If a shortcut is blocked, use Home > Format > Hide & Unhide > Unhide Columns.

Does hiding a column remove its data from formulas?
No. The values and formulas remain in the worksheet, and formulas can still refer to them. Hiding changes what is displayed, not the underlying data.

Can I use the same shortcut in Excel for the web?
Shortcut support can depend on the browser and keyboard setup. If Ctrl+0 does not hide the selected column in the web app, use the column-header context menu or the ribbon. The steps and shortcuts in this guide primarily describe Excel for Microsoft 365 on Windows.

Why can other people still access a hidden column?
Hiding does not secure information. A person with access to the workbook can usually unhide the range, so use suitable workbook permissions or remove sensitive data when it should not be available.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.