Whether you're preparing a report for a client, cleaning up a dashboard for a presentation, or simply trying to focus on the columns you're actively working with, knowing how to hide columns in Excel is a practical skill that saves time and prevents errors.
A spreadsheet that works for detailed analysis often has far more columns than a recipient needs to see — raw data, intermediate calculations, lookup tables, and helper columns that drive formulas but add no value to the final view. Hiding those columns instantly transforms a complex working spreadsheet into a clean, readable deliverable without any restructuring or data duplication.
Hiding columns in Excel is one of the most commonly used worksheet organisation techniques — it lets you remove columns from view temporarily without deleting any data. Hidden columns remain in the workbook and in any formulas that reference them; they simply don't display on screen or print. This is useful when you want to show a clean summary view of a spreadsheet while keeping supporting data available, share a worksheet without exposing internal calculations, or focus on specific columns during data entry without the distraction of adjacent columns.
Excel gives you several ways to hide columns. The most intuitive is right-clicking the column header and selecting Hide. You can also use the ribbon (Format menu under the Home tab), a keyboard shortcut (Ctrl+0), or grouping — which adds expand and collapse buttons to the spreadsheet, making it easy to show and hide related columns interactively. Each method suits different situations: right-click works for quick ad hoc hiding, keyboard shortcuts speed up repetitive tasks, and grouping is better when you'll be toggling visibility regularly and want a visual control for users who aren't Excel experts.
One important distinction: hiding columns is different from setting the column width to zero (which also removes columns from view but leaves no visible indicator that anything is hidden) and different from filtering (which hides rows, not columns, based on criteria). Hidden columns are indicated by a missing letter in the column header row — if you see A, B, D, E with C missing, column C is hidden. Users who know to look for this gap can identify and unhide hidden columns unless you take additional steps to protect the sheet.
This guide covers all four methods for hiding columns, how to hide multiple columns at once, how to unhide them, and several less-obvious but useful techniques including grouping, protecting hidden columns, and what to do when unhiding doesn't work as expected.
Click the column letter at the top of the spreadsheet — the column header — to select the entire column. The selected column highlights in blue. To select multiple adjacent columns, click the first column header, hold Shift, and click the last column header. To select non-adjacent columns (for example, columns B and D but not C), click B, hold Ctrl, and click D. All selected columns will be hidden together in the next step.
With the column(s) selected, right-click anywhere on the highlighted column header area (the letter at the top). A context menu appears. If you right-click on a cell inside the column rather than the header, the context menu shows row and cell options rather than column options — make sure you right-click on the column letter itself. If you selected multiple columns and right-click on any of the selected headers, the action applies to all selected columns.
In the right-click context menu, click 'Hide'. The column disappears from view immediately. The column letter is no longer visible in the header row — instead, you'll see the column letters of the surrounding columns directly adjacent (for example, if you hide column C, the header shows ...B, D...). The data in the column is still there and any formulas referencing it continue to work; the column is simply not displayed.
Look at the column header letters to confirm the hidden column's letter is absent. You can also verify by clicking a cell that contains a formula referencing the hidden column — the formula still shows the hidden column reference and still calculates correctly, which confirms the data is intact. To unhide, select the columns on both sides of the hidden column (click the header of the column before the gap, Shift-click the header after the gap), right-click, and select Unhide.
The right-click method is the most intuitive, but Excel gives you three other ways to hide columns that are worth knowing depending on your working style and situation.
The ribbon method uses the Format menu in the Home tab. Select the column(s) you want to hide, then go to Home → Format (in the Cells group) → Hide & Unhide → Hide Columns. This route is useful if you prefer working through menus rather than right-clicking, or if you're following a documented procedure and want a clearly labelled path. The same Format → Hide & Unhide menu also offers Unhide Columns and Hide/Unhide Rows, keeping all visibility options in one consistent location.
The keyboard shortcut for hiding columns is Ctrl+0 (zero, not the letter O). Select the column(s) you want to hide and press Ctrl+0. The columns disappear immediately. This is the fastest method once you know the shortcut and works well when you're hiding columns frequently. Note that on some Windows computers, Ctrl+0 may be assigned to a system shortcut and won't work for Excel — if this happens, use the right-click or ribbon method instead. The unhide shortcut is Ctrl+Shift+0, but this has the same potential conflict issue on Windows; if it doesn't work, use right-click Unhide.
The fourth method is using Column Width. If you set a column's width to zero (Home → Format → Column Width → enter 0 → OK), the column disappears from view similarly to hiding. However, this method doesn't mark the column as 'hidden' in Excel's internal state — it just makes it invisible by making it have zero width.
The practical difference: a column set to width 0 has no visual gap in the column header letters (unlike a properly hidden column), making it harder for other users to detect that a column is missing. This can be useful in specific circumstances but isn't recommended as the standard approach since it makes the spreadsheet harder to audit.
To hide several consecutive columns (for example, columns C through F), click the header of the first column (C), hold Shift, and click the header of the last column (F). All four columns highlight. Right-click any of the selected headers and choose Hide — all four columns disappear together. The same Shift+click selection works for the ribbon method and the keyboard shortcut. This is the most common scenario when hiding a range of related columns.
To hide columns that aren't next to each other — for example, columns B, D, and G — click column B's header, hold Ctrl, click column D's header, then hold Ctrl and click column G's header. All three columns highlight (the columns between them are not selected). Right-click any selected header and choose Hide. All three columns hide simultaneously while the unselected columns between them remain visible. Non-adjacent selection works for all four hiding methods.
If you need to hide a large contiguous block of columns (for example, columns E through Z to hide everything after column D), click column E's header, scroll right while holding Shift, and click column Z's header. Or use the Name Box (the field to the left of the formula bar): type E:Z in the Name Box and press Enter to select columns E through Z instantly, then right-click and hide. This is faster than Shift-clicking across many columns.
When you need users to be able to toggle column visibility interactively, use grouping instead of standard hiding. Select the columns you want to group, go to Data → Outline → Group → Columns. Excel adds a minus (-) button above the grouped columns and a 1/2 level indicator to the left. Clicking the minus button collapses the columns (hides them); clicking the plus (+) button expands them again. This is ideal for structured reports where users need to drill in and out of detail.
To unhide a column, you need to select the columns on both sides of the hidden column and then unhide.
Unhiding column A requires a different approach because there's no column to the left of it to include in a standard selection.
Standard column hiding is a simple on/off state — columns are either visible or they're not. Grouping adds a layer of interactivity that makes it much more practical for shared spreadsheets where users need to drill into and out of detailed data. When you group columns, Excel displays collapse and expand buttons (minus and plus signs) above the grouped columns, and level buttons (numbered 1, 2, etc.) at the top-left of the sheet. Users click these buttons to toggle visibility without needing to know how to select columns and use the Hide/Unhide menu.
To create a column group, select the columns you want to include in the group, then go to the Data tab and click Group in the Outline section. A dialog appears asking whether to group rows or columns — select Columns and click OK. The group indicator appears above the column headers. You can create multiple groups in the same spreadsheet for different sections of data. Nested groups are also possible — grouping columns within an already-grouped range creates a two-level hierarchy (clicking level 1 collapses everything; level 2 collapses only the nested groups).
Grouping is particularly well-suited to financial reports and dashboards where the same underlying spreadsheet is used by both analysts (who need the detail) and executives (who want a summary view). Rather than creating separate summary and detail versions, a single grouped spreadsheet serves both needs. The outline buttons can be hidden from view via the Excel Options if you want a cleaner look while still keeping the grouping functionality intact for programmatic use.
The grouping feature also integrates with Excel's print and view settings. When you print a sheet with collapsed groups, the collapsed (hidden) columns don't print — the same as standard hidden columns. This gives grouped sheets a dual function: they provide an interactive view for users working in the file while also producing clean printed output when columns are collapsed before printing. Teams that regularly produce both detailed working documents and management summary reports from the same data often find that a grouped Excel sheet with two or three outline levels handles both needs without any manual reformatting.
To remove grouping without permanently deleting the columns, select the grouped columns, go to Data → Ungroup → Columns. The outline buttons disappear and the columns remain visible. Alternatively, go to Data → Outline → Clear Outline to remove all grouping from the sheet at once. This doesn't affect column visibility — previously collapsed groups should be expanded before clearing the outline to ensure all columns are visible after the outline is removed.
The most common reason unhiding columns doesn't work is selecting incorrectly before attempting the operation. To unhide a column, you need both surrounding columns selected — not just one. If you select only the column to the right and try to unhide, nothing happens or you get an error. Make sure you Shift-click to include both the column before and the column after the hidden column in your selection before right-clicking.
The second common issue is sheet protection. If the workbook's sheet is protected, hidden columns can't be unhidden unless you first remove the protection (Review → Unprotect Sheet, then enter the password if one was set). If you don't know the password and the workbook was shared with you, contact the person who protected the sheet. This is intentional behaviour — sheet protection is specifically used to prevent users from unhiding protected columns.
A third issue arises with the keyboard shortcut Ctrl+Shift+0 for unhiding. On many Windows systems, this shortcut conflicts with an Input Method Editor (IME) keyboard shortcut and does nothing in Excel. If Ctrl+Shift+0 doesn't work, use the right-click menu or the ribbon (Home → Format → Hide & Unhide → Unhide Columns) instead. This is a known Windows-Excel compatibility issue with no universal fix — the workaround is simply to use a different method.
Filtering can cause confusion that looks like hidden columns but isn't. If you've applied a filter to your data (Data → Filter is on), rows may be hidden by the filter. But columns shouldn't be affected by row filters. If you're missing rows rather than columns, check whether filtering is active — look for dropdown arrows in the header row and filter indicators. Clearing the filter (Data → Clear) will reveal all filtered rows. If entire columns appear to be missing after applying a filter, the issue is likely hidden columns as described above, not the filter.
Standard column hiding is transparent to any Excel user — they can see the gap in column letters and unhide the columns in seconds. If you need to actually prevent users from accessing hidden column data, you must use sheet protection in addition to hiding the columns.
The process is straightforward: first, hide the columns using any method. Then go to the Review tab and click Protect Sheet. In the dialog, you can set a password (optional but recommended if security matters) and specify what actions users are allowed to take. By default, protected sheets don't allow users to format columns — which means they can't change column width or unhide columns. Make sure the 'Format columns' option is NOT checked in the protection settings to prevent users from unhiding.
Sheet protection has important limitations. It protects against casual users but is not cryptographically strong security. Excel's sheet protection uses relatively weak encryption and can be bypassed by determined users with intermediate Excel or programming knowledge. If you're protecting genuinely sensitive data, sheet protection is a deterrent rather than a security guarantee. For truly sensitive information, consider whether it should be in an Excel file at all, or whether a proper access-controlled database or application is more appropriate.
When sharing a workbook where some columns are hidden for appearance reasons (not security), it's good practice to note this explicitly — either in a cell near the top of the sheet or in a separate documentation sheet. This prevents confusion when colleagues encounter the spreadsheet and wonder why certain data appears to be missing.
A simple note like 'Columns E–J contain raw data and are hidden for presentation — contact [name] to unhide' saves significant confusion in shared workbook environments. In larger teams, consider adding a dedicated 'Notes' sheet as the first sheet in the workbook that documents what's in the file, what's hidden and why, and who to contact for access — this kind of documentation makes workbooks far more maintainable as they pass between team members over time.
Hidden columns in Excel don't print — if you hide columns B and C and then print the spreadsheet, the printed output shows columns A, D, E, and so on without any columns B or C. This is one of the most practical uses of column hiding: preparing a print-ready version of a working spreadsheet without creating a separate file. You hide the internal calculation columns, helper columns, or raw data columns before printing, print the clean view, and then unhide everything when you return to working on the file.
An alternative that doesn't require hiding and unhiding is Print Area. You can set a Print Area (Page Layout → Print Area → Set Print Area) to specify exactly which cells print, without affecting column visibility. This is better when you want to print only certain columns regularly without changing the column visibility state. Print Area persists in the workbook, so you set it once and every subsequent print uses the same area unless you clear or change it.
For more complex print scenarios — for example, printing different combinations of columns for different audiences — consider creating named views using Custom Views (View → Custom Views). You save each view with a name (for example, 'Summary View' and 'Detail View'), and each view can have its own column visibility state. Switching between custom views instantly applies the saved column visibility settings, which is more efficient than manually hiding and unhiding column groups before each print job.
It's worth noting that Excel's Print Preview (File → Print or Ctrl+P) is the most reliable way to confirm what will print before committing to paper. Hidden columns and hidden rows don't appear in Print Preview, so what you see there reflects the actual output. Check Print Preview after hiding columns to confirm the printed layout looks correct — column widths, page breaks, and header rows all appear there exactly as they'll print, giving you a chance to catch any layout issues before wasting paper or sending an incorrect document.