In Excel for Microsoft 365 on Windows, select a cell in the column—or select its column header—and press Ctrl+0 to hide it. On a Mac, the equivalent is Command+0. Hiding a column conceals it from view without deleting its contents.
The Windows Shortcut and What It Hides
The Windows shortcut is Ctrl+0, using the zero key on the main keyboard row. It hides the selected column or columns, so their letters disappear from the column headings and the visible columns appear to jump across the gap. For example, if column C is hidden, the headings will go from B to D.
Excel hides columns, not just the cells currently visible in the worksheet. If you select a cell in column C and use the shortcut, the entire worksheet column C is hidden, including cells above or below the current data. This is useful when you want to temporarily tuck away supporting calculations, internal notes, or details that make a report harder to read.
The shortcut does not erase data, change a formula, or protect the information. Anyone with access to the workbook can reveal the column again. Treat hiding as a display choice, not as a way to secure confidential information.
Select the Right Column First
You can press Ctrl+0 while a cell in the target column is active. To make the selection unambiguous, click the column letter at the top of the worksheet first. The whole column becomes selected, and the shortcut hides it. This approach is especially clear when working near a table, a group of merged cells, or a complicated layout.
To select a range of adjacent columns, click the first column letter and drag across the other letters, or select the first header and Shift-click the last. Then press Ctrl+0. For example, select the D, E, and F headers to hide all three columns at once. The worksheet keeps those columns in their original positions; Excel does not shift the data into different columns.
For nonadjacent columns, hold Ctrl while clicking each column letter, then use Ctrl+0. Check the highlighted headers before hiding them, particularly if the columns contain formulas or identifiers you still need to reference. In an Excel table, clicking a table heading can select a table field rather than the worksheet column, so click the letter above the table if your intention is to hide the entire worksheet column.
Hide Several Columns Efficiently
When preparing a worksheet for someone else, it is often quicker to select all the columns to hide in one operation than to repeat the shortcut. A practical example is a monthly report with visible columns for Month and Total, while columns containing unit price, quantity, and intermediate calculations are kept out of the main view. Select the relevant column letters together and press Ctrl+0 once.
You can also hide a wide range that includes columns you may want to leave visible only if you then unhide those columns individually. Usually, selecting just the intended headers is safer: it reduces the chance of hiding a label or input field by mistake. If you are unsure what is selected, look at the highlighted column letters before using the shortcut.
Hidden columns remain part of the worksheet’s grid. A formula in another column can still refer to them, and a formula such as a SUM over a range does not stop including values merely because some columns are hidden. Hiding changes what is displayed, not the underlying calculation.
Unhide Columns and Find Hidden Data
On Windows, Excel’s keyboard shortcut for unhiding columns is Ctrl+Shift+0. First select the columns on both sides of the hidden column. For example, if C is hidden between B and D, select the B and D headers together—or select the range from B through D—and use the unhide shortcut. Excel then shows the hidden column.
If several adjacent columns are hidden, select the visible headers on either side of the hidden block and unhide. If the hidden columns are at the far left or right edge, where there is no visible column on one side, select the whole sheet using the triangle at the intersection of the row numbers and column letters, then use the ribbon command described below. You can also drag across the column-heading area where the hidden columns would be, but selecting the whole sheet is often easier for a beginner.
Another way to spot a hidden column is to look for a break in the sequence of letters, such as A, B, D, E. A very narrow column may also be present if its width was reduced rather than set to hidden. In either case, selecting the neighboring column headers and choosing Unhide can restore a hidden column. If the column was merely made narrow, use the column-width controls instead.
On some Windows setups, Ctrl+Shift+0 may not work because of keyboard-layout or system shortcut behavior. Use the ribbon’s Unhide Columns command instead; it performs the same action and avoids relying on that key combination.
Ribbon and Context-Menu Alternatives
If you prefer not to use a keyboard shortcut, select the relevant column or columns and choose Home > Cells > Format > Hide & Unhide > Hide Columns. To restore columns, select the surrounding columns and choose Home > Cells > Format > Hide & Unhide > Unhide Columns. These commands are available on the Excel ribbon and are useful when the shortcut is unfamiliar or unavailable.
You can also right-click a selected column heading and choose Hide. To reveal a hidden column, select the column headings on either side of it, right-click the selection, and choose Unhide. The context menu is a handy option when you are already using the mouse, while the ribbon is easier to follow when you want a named command.
Excel’s menus can vary slightly in appearance depending on window size and ribbon layout, but the command is under the Home tab’s Format menu. If the ribbon is collapsed, expand it or use the search box for the command name. Choosing a menu command rather than a shortcut does not change what hiding does to the workbook.
What Hiding a Column Changes—and What It Does Not
Hiding a column reduces what appears on screen, which can make a wide worksheet easier to scan. It can be helpful for a presentation copy, a print layout, or a working sheet where secondary information is temporarily distracting. The column remains in the workbook, and its values remain available to formulas and other workbook features.
Hiding is not the same as deleting. Deleting a column removes its cells and can alter references, formulas, or layout; hiding leaves the column in place. It is also not the same as filtering a table. A filter hides rows that do not match a condition, whereas the Hide Columns command conceals entire vertical columns regardless of their values.
Hiding is not a privacy control. It does not encrypt the contents or prevent a recipient from unhiding the column. If a workbook will be shared and the information should not be available to its recipients, remove it from the shared copy or use appropriate file and access controls rather than relying on a hidden column. For printed output, check Print Preview because worksheet layout and print settings determine what the final pages show.
Mac and Excel for the Web
In Excel for Microsoft 365 on a Mac, select the column or columns and press Command+0 to hide them. The ribbon option is also available through Home > Format > Hide & Unhide > Hide Columns. The Mac interface can place or display ribbon controls differently depending on the window, but the command name is the same.
To unhide on a Mac, select the columns around the hidden area and try Command+Shift+0. Keyboard behavior can depend on the Mac’s settings and keyboard layout, so use the ribbon’s Unhide Columns command if the shortcut does not respond. The Windows Ctrl shortcuts should not be substituted for the Mac Command shortcuts.
Excel for the web runs in a browser, where some keyboard combinations may be handled by the browser or may differ from the desktop app. For a reliable route, select the column headers and use the Home tab’s Format menu to choose Hide & Unhide, then Hide Columns. The same menu offers Unhide Columns when you have selected the surrounding columns. If a shortcut appears to affect the browser instead of the sheet, use the ribbon.
Common Shortcut Problems
- Nothing happens: Confirm that the worksheet is active and that you are pressing Ctrl+0 on Windows, not Command+0. Try selecting the column letter first, then press the shortcut again.
- The wrong area disappears: Review the highlighted column letters before trying again. If you selected a cell range, Excel may hide the worksheet columns intersecting that selection; selecting the headers makes the target clear.
- Unhide does not work: Make sure the selection includes the visible columns immediately beside the hidden one. If the hidden column is at the sheet edge, select the whole worksheet and use Home > Cells > Format > Hide & Unhide > Unhide Columns.
- The shortcut seems unavailable: A system or keyboard-layout setting may intercept it, particularly for unhide. Use the ribbon or right-click the column headings rather than repeatedly pressing keys.
- The column is still hard to find: Check whether it was resized to a very small width rather than hidden, or whether worksheet protection restricts formatting changes. If the sheet is protected, you may need permission or the appropriate password to change its layout.
When troubleshooting, avoid deleting columns just to make the worksheet look narrower. Deletion can affect formulas and references. If your goal is only to simplify the display, hide the column; if you want to make it visible again, unhide or adjust its width.
Frequently Asked Questions
What is the Excel shortcut to hide a column?
On Windows, select a cell in the column or its header and press Ctrl+0. On a Mac, use Command+0.
How do I hide multiple columns in Excel?
Select the column letters for all the columns you want to hide, including a range of adjacent letters or Ctrl-clicked nonadjacent letters on Windows, then press Ctrl+0. On Mac, use Command+0.
What is the shortcut to unhide a column in Excel?
On Windows, select the columns around the hidden one and press Ctrl+Shift+0. On Mac, try Command+Shift+0. If the shortcut is intercepted or does not work, use Home > Format > Hide & Unhide > Unhide Columns.
Does hiding a column delete its data or change formulas?
No. The values remain in the worksheet, and formulas can continue to use them. Hiding changes the view; deleting removes the column and may affect formulas or references.
Can I hide a column in Excel for the web?
Yes. Select the column heading, then use the Home tab’s Format menu and choose Hide & Unhide > Hide Columns. The ribbon method is dependable if a browser intercepts a keyboard shortcut.
Related
- Can Excel Generate a PivotTable? How to Create One
- Excel Flash Fill for Rows: How It Works and When to Use It
- Excel Flash Fill: Does It Only Copy Data?
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Create Your Own PowerPoint Template for Free: A GuideYes—you can design a PowerPoint template without paying for a template file: use PowerPoint for the web with…
- Monthly Excel Budget Format: Build a Simple TemplateA useful monthly Excel budget format puts each income source and expense category on its own row, with…
- Switch Excel Sheet Shortcut: Windows, Mac, and TipsIn Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next worksheet and Ctrl+Page…
- Google Sheets Calendar: Create and Customize a Month ViewCreate a calendar view in Google Sheets by entering the first day of a month in cell B1,…
- How to Create Individual Labels in WordTo create individual labels in Word, open Mailings > Labels, choose the label product that matches your sheets,…
- Python Goal Seek Like Excel? Methods and ExamplesYes. Python can do the same basic job as Excel Goal Seek: adjust one input until a formula…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.