To hide column C in Excel for Microsoft 365 on Windows, right-click the C column heading and choose Hide. To show it again, select columns B through D, right-click one of the selected headings, and choose Unhide.
What Hiding a Column Does
Hiding a column removes it from the worksheet view without deleting its contents. The column still exists in the workbook: formulas can continue to refer to its cells, and unhiding it restores the data. This is useful when a worksheet contains supporting calculations, notes, or details that are not needed while someone reviews the main results.
For example, if column C contains unit costs and columns D and E show quantities and totals, hiding C can make the sheet easier to read during a presentation. A formula in E can still use the values in C while the column is hidden. The same principle applies if the hidden column contains dates, identifiers, or intermediate calculations.
Hidden columns are not the same as deleted columns or filtered-out records. Hiding changes the layout of the worksheet; it does not remove information or protect it from access. Anyone who can work with the sheet may be able to unhide the column.
Hide Column C with the Column Heading
The column letters at the top of the worksheet are headings. Selecting the C heading selects the entire column, including cells that are currently empty. Use this method when you want to hide all of column C rather than just a few cells.
- Open the worksheet and locate the column letters along the top of the grid.
- Click the C heading. The whole column should be highlighted.
- Right-click the highlighted heading.
- Choose Hide from the context menu.
Column C disappears, and the visible headings jump from B to D. That gap is a useful visual clue that a column is hidden. If you right-click a cell inside column C instead of its heading, the menu may not offer the same whole-column action, so start from the letter at the top.
Use the Ribbon or a Keyboard Shortcut
You can also hide the selected column from the ribbon. First click the C heading, then use Home > Cells > Format > Hide & Unhide > Hide Columns. The menu path is helpful when you prefer not to use the right-click menu or when you are following written instructions.
On Excel for Windows, Ctrl+0 hides the selected column or columns. Select C first, then press the shortcut. If it does not work on your computer, use the ribbon path instead; keyboard shortcuts can be affected by system or keyboard settings. Avoid confusing this with Ctrl+9, which hides selected rows.
Hiding is applied to the selected columns as a whole. Clicking a cell in C and using the Hide Columns command hides column C, not just the active cell. To hide more than one column, select all the column headings you need before choosing the command.
Unhide Column C
When C is hidden, its heading is not available to click. Select the visible columns on both sides of it, then use the unhide command. In the usual case where only C is hidden, select the B heading and drag across to D, or click B and Shift-click D. Right-click one of the selected headings and choose Unhide.
The ribbon route is Home > Cells > Format > Hide & Unhide > Unhide Columns. Excel restores the hidden column in its previous position, between B and D. Unhiding does not change the values or formulas in the column.
If several neighboring columns are hidden, select the visible headings on either side of the entire hidden range. For instance, if C and D are hidden, select B through E and choose Unhide. If you are unsure how many columns are hidden, select the whole worksheet by clicking the small triangle at the intersection of the row numbers and column letters, then use Home > Cells > Format > Hide & Unhide > Unhide Columns. This can reveal other hidden columns in the sheet as well, so use it only if showing them all is acceptable.
Hide Several Columns or Select Column C Directly
To hide a continuous range, select its column headings by dragging across them, then choose Hide. For nonadjacent columns, select the first heading, hold Ctrl on Windows, and click each additional heading before applying the command. The chosen columns will all be hidden; columns between nonadjacent selections remain visible.
If C is difficult to locate in a wide worksheet, use the Name Box to select it. The Name Box is to the left of the formula bar and usually displays the active cell address. Enter C:C there and press Enter to select the full column, then use the ribbon command or right-click a selected heading and choose Hide. This approach is also useful when you want to select a column by its letter without scrolling horizontally.
Be careful when selecting ranges: dragging across cells in the grid selects cells, not necessarily whole columns. Selecting the letter headings avoids accidentally hiding only a partial selection or applying a different command than intended.
Excel for Mac and Excel for the Web
In Excel for Mac, you can select the C heading, Control-click or right-click it, and choose Hide. The ribbon also offers the hide and unhide controls under Home > Format; the exact arrangement can vary with the ribbon layout. To reveal C, select the headings on either side and choose Unhide. If a keyboard shortcut differs or is intercepted by macOS, use the menus.
In Excel for the web, select the column heading, open its context menu, and choose Hide columns or the equivalent hide command shown in the menu. To restore a hidden column, select the neighboring headings and use the unhide option. The web interface can change, so the column-heading context menu is generally the most direct place to look. These actions change the worksheet view in the workbook; they do not delete the column data.
Common Problems When Hiding or Unhiding
- The C heading is missing. If the visible headings go from B to D, C is likely hidden. Select B through D and use Unhide.
- Unhide is unavailable or has no effect. Confirm that your selection includes the visible columns on both sides of the hidden range. Selecting only B may not identify the hidden column between B and D.
- The worksheet is protected. Sheet protection can prevent column formatting, depending on the protection settings. If you have permission, use Review > Unprotect Sheet and provide the password if requested, or ask the workbook owner to allow column formatting.
- The column appears extremely narrow rather than hidden. A narrow column may still have a visible boundary. Select it and use Home > Cells > Format > Column Width to set a readable width, or use AutoFit. A genuinely hidden column has no usable width in the normal grid view.
- You cannot tell whether values are missing. Check the column letters and formulas that refer to the range. A jump from B to D indicates a hidden C; a filter, collapsed outline, or horizontal scrolling can also make data appear absent, so verify the headings before changing the sheet.
Also consider whether the worksheet has grouped columns. Grouping can display outline controls, such as plus and minus buttons, that collapse or expand a range. Expanding the outline may restore the columns without using the ordinary Unhide command. If the sheet is shared or part of a report, ask whether another person intentionally set up the hidden or grouped layout before changing it.
What Hiding Does Not Change
Hiding column C does not stop formulas from calculating with its cells. For example, a total formula can continue to include values from C even while those values are not visible. It also does not make the data confidential: someone with access to the worksheet can often unhide the column, inspect formulas, or copy the workbook.
Hidden columns are generally omitted from the normal worksheet display and printout, but that is not a substitute for removing sensitive information. If a file must not contain particular data, remove that data from a separate copy or create a version that contains only the information intended for its recipients. Do not rely on hiding, formatting text to blend into the background, or placing data off-screen as security measures.
Hiding a column also does not rearrange the remaining data. D stays in its original position after C is hidden; it only appears immediately beside B. Formulas and references retain their underlying cell addresses unless you take another action that changes the worksheet structure.
When to Use Grouping or Another Approach
For a column you only need to tuck away occasionally, Hide is simple and quick. If people regularly need to expand and collapse a related set of columns, use Excel’s outline grouping feature instead. Select the columns and choose Data > Group; the outline controls can then collapse or expand the group. Grouping is a better fit for optional detail that users should be able to reveal deliberately.
If your goal is to display only certain records, use a filter rather than hiding a whole column. Filters show or exclude rows based on values while keeping the relevant fields available. If you want to make a sheet easier to read without removing a field from view, consider adjusting column width, moving supporting information to another worksheet, or using a separate summary sheet.
Frequently Asked Questions
What is the shortcut to hide column C in Excel?
On Excel for Windows, select the C heading and press Ctrl+0. If the shortcut is unavailable on your setup, use Home > Cells > Format > Hide & Unhide > Hide Columns.
How do I unhide column C when it is missing?
Select columns B through D, right-click one of their headings, and choose Unhide. You can also use Home > Cells > Format > Hide & Unhide > Unhide Columns.
Does hiding column C delete its data?
No. Hiding changes what is displayed, not the stored cell contents. The data and formulas remain in the workbook and can be viewed again by unhiding the column.
Can I hide column C without hiding other columns?
Yes. Select only the C heading before choosing Hide. If you select multiple headings, Excel hides each selected column, so check the highlighted headings before applying the command.
Why can I not unhide column C?
The selection may not include columns on both sides of the hidden range, or the sheet may be protected. Select B through D, try Unhide Columns, and check with the workbook owner if protection prevents formatting changes.
Related
- Excel Split Cell Data Into Multiple Columns
- Excel Split Cell Into First and Last Name: A Clear Guide
- Excel Split Cell by Space Delimiter: Methods and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Unmerge Excel Files in Microsoft ExcelTo unmerge cells in an Excel workbook, select the merged cell or range, then choose Home > Merge…
- Embed a SharePoint Video in PowerPoint: What WorksYes—you can play a SharePoint video from a PowerPoint slide if your version accepts its link under Insert…
- Excel Shortcut to Insert a Row on Windows and MacIn Excel for Microsoft 365 on Windows, select the row where you want the new one, then press…
- Combine Cells in Excel for Mailing AddressesTo combine address parts into one cell, put the street in A2, city in B2, state in C2,…
- Project Timeline Excel Template: Simple Planning GuideYes. A simple project timeline Excel template can be a single worksheet with tasks, owners, start and finish…
- PowerPoint: How to Animate Part of TextYes. PowerPoint can reveal text by paragraph, word, or letter, but if you want one specific phrase to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.