Yes. In Excel for Microsoft 365 on Windows, select one or more column headers, right-click, and choose Hide; you can also use Home > Format > Hide & Unhide > Hide Columns. The data stays in the workbook, and you can restore the columns later with Unhide Columns.
What Hiding a Column Does
Hiding changes how a worksheet is displayed: Excel reduces the selected column’s width to zero, so its cells are no longer visible in the grid. It does not delete the column or clear its contents. The column remains in its original position, and the columns to its right move visually next to the columns on its left.
For example, a sales sheet might contain customer names in column A, internal notes in B, and monthly sales in C through N. Hiding B gives a cleaner view of the sales figures without removing the notes from the workbook. You can reveal the notes again when you need to review or edit them.
Hiding columns can make a wide worksheet easier to read, prepare a presentation-friendly view, or temporarily get less relevant fields out of the way. It is a display choice, not a way to remove data or make it private. Anyone with access to the workbook may be able to unhide the column.
How to Hide Columns
To hide a column in the Windows desktop version of Excel, use either the column-header menu or the ribbon:
- Click the letter at the top of the column you want to hide. To select several neighboring columns, drag across their letters or click the first letter, hold Shift, and click the last.
- Right-click one of the selected column letters and choose Hide.
- Alternatively, go to Home > Format > Hide & Unhide > Hide Columns.
Excel hides the whole column, including cells that look empty. To hide nonadjacent columns, select the first column, hold Ctrl, and click the other column letters; then right-click one of the selected headers and choose Hide. On a Mac, use Command instead of Ctrl to select separate ranges. The right-click method is available in Excel for Mac as well; the ribbon’s Format menu provides the corresponding hide and unhide commands.
You can also hide a column using the Windows keyboard shortcut Ctrl+0 after selecting a cell in that column. In Excel for Mac, the corresponding shortcut is Command+0. Shortcuts can vary with keyboard settings, and Windows may reserve Ctrl+0 in some configurations, so the ribbon or right-click menu is a dependable alternative.
How to Unhide Columns
When a hidden column is between two visible columns, select the visible columns on both sides. For instance, if C is hidden between B and D, select the B and D headers together, right-click either selected header, and choose Unhide. You can also use Home > Format > Hide & Unhide > Unhide Columns.
If more than one column in the selected span is hidden, Excel reveals the hidden columns within that span. To unhide all columns on a worksheet, select the entire sheet first by clicking the small triangle at the top-left corner of the grid, where the row and column headings meet. Then use Home > Format > Hide & Unhide > Unhide Columns. This reveals columns across that worksheet, not just the ones you had in mind, so use it when a complete reset is appropriate.
The first column can be tricky because there is no visible column header to select on its left. One approach is to click the Name Box to the left of the formula bar, type A:A, and press Enter. Then choose Home > Format > Hide & Unhide > Unhide Columns. If several columns at the start are hidden, enter a range that includes them, such as A:C, and use the same command.
On Windows, Ctrl+Shift+0 is a shortcut for unhiding columns in some Excel and keyboard configurations. It may not work on every computer because Windows can use that key combination for a system or regional setting. The ribbon command avoids that uncertainty. On a Mac, Command+Shift+0 is the corresponding shortcut where supported.
Hiding Several Columns and Using Groups
For a one-time change, select several column headers and hide them together. If the columns are next to each other, select the first and last headers while holding Shift. If they are separated, use Ctrl on Windows or Command on Mac while selecting each header. A hidden column can still be included in a selection if you select a range that spans it.
If you expect to show and hide the same block repeatedly, grouping may be more convenient. Select the columns, then choose Data > Group. Excel adds an outline control near the column headings; use its minus or plus control to collapse or expand the group. Grouping is useful for reports with detail columns that readers may want to open and close without using the Unhide command each time. It is different from ordinary hiding: the outline remains as a visible control, and users can expand the group directly.
For example, a budget worksheet could keep quarterly detail columns grouped under a yearly summary. A reader can collapse the detail for a compact overview and expand it to inspect the underlying figures. Grouping does not protect the detail or make it private; it simply provides a convenient way to control its display.
What Happens to Formulas, Charts, and Printing
Formulas continue to use values in hidden columns. If a total formula refers to cells in a hidden column, hiding that column does not remove those inputs or stop the calculation. Likewise, a formula can still refer to a hidden cell, and Excel can display the formula’s result in a visible cell.
Charts require a little more care. A chart based on a range that includes hidden rows or columns may omit the hidden data by default. If you want a chart to include it, select the chart and look for Select Data on the Chart Design tab; the Hidden and Empty Cells settings include an option to show data in hidden rows and columns. The exact controls can depend on the chart and Excel version, so check the chart after changing the worksheet view.
Hidden columns are generally omitted when you print a worksheet, which can be useful for producing a simplified report. However, always preview the output: print area settings, page breaks, scaling, and the particular sheet layout affect what appears on the page. Hiding a column is not a substitute for checking the final print preview.
Hiding also does not change the underlying cell values, names, or formulas. It changes what is displayed in the worksheet, not the data model. If another workbook formula, chart, or process depends on those cells, hiding them does not remove that dependency.
Hide, Filter, or Group: Which Should You Use?
Choose the method based on what you are trying to remove from view. Hiding columns is for temporarily removing entire fields from the grid. It does not select records based on their values, and it affects every row in the chosen columns.
- Hide columns when you want to conceal a field such as notes, internal codes, or an intermediate calculation from the current worksheet view.
- Filter rows when you want to show only records that meet criteria, such as orders from one region or dates within a period. Excel’s filter controls hide rows that do not match; they do not hide columns.
- Group columns when people need to expand and collapse the same related columns repeatedly.
- Delete columns only when you intend to remove the data and have checked that formulas, charts, or other workbook content do not rely on it.
A common misconception is that filtering a table hides fields. A filter changes which rows are displayed based on values in selected columns; the columns themselves remain visible. Conversely, hiding a column does not filter out any records. If your goal is to show fewer categories of data, filtering may be the right tool; if your goal is to simplify a wide sheet, hide or group columns.
Common Problems and How to Fix Them
If Unhide appears to do nothing, first check that you selected the columns on both sides of the hidden column, or selected the whole worksheet before using Unhide Columns. For a hidden first column, use the Name Box method described above. Also check whether the column is merely extremely narrow rather than hidden: select the neighboring headers and choose Home > Format > Column Width, then enter a suitable width.
If you cannot hide or unhide columns, the worksheet may be protected. On a protected sheet, formatting permissions can restrict changes to column widths and visibility. If you have permission to change the workbook, review the sheet’s protection settings on the Review tab; otherwise, ask the workbook owner to make the change or provide an editable copy. Do not assume that an inability to unhide means the data has been deleted.
Another source of confusion is the small double line between column headers. It can indicate a hidden column, especially when the letters skip—for example, the headings jump from B to D. Double-clicking a boundary may instead resize a column to fit its contents, so use the explicit Unhide command when you want to restore a hidden column.
Excel for the web also supports hiding and unhiding columns, typically through the column-header context menu. Its ribbon and keyboard behavior can differ from the Windows desktop app, and available controls may change as the web app is updated. If a command is not where you expect it, use the column header’s right-click menu or open the workbook in the desktop app.
Visibility Is Not Security
A hidden column remains part of the workbook and can be revealed by someone who can edit or inspect the sheet. Hiding should not be used to protect confidential information such as personal details, passwords, or sensitive business data. A recipient may unhide the column, copy the worksheet, inspect formulas, or otherwise access information that remains in the file.
Sheet protection can limit certain editing actions, but it is not the same as removing sensitive content. If people should not receive particular data, remove it from the shared workbook or create a separate version containing only the information they are authorized to see. When sharing a file, consider the workbook as a whole rather than relying on what is currently visible on screen.
Frequently Asked Questions
Can I hide multiple columns at once?
Select all the column headers you want to hide, including nonadjacent ones if needed, and choose Hide from the right-click menu. Use Shift for a continuous range and Ctrl on Windows or Command on Mac to select separate columns.
How do I unhide column A?
Enter A:A in the Name Box and press Enter, then choose Home > Format > Hide & Unhide > Unhide Columns. Selecting the whole sheet before using Unhide Columns is another option if you want to reveal every hidden column.
Does hiding a column delete its data or affect formulas?
No. Hiding changes the worksheet display, while the cell contents remain in the workbook. Formulas can continue to calculate using hidden cells, although charts may need their hidden-data setting adjusted to display those values.
Can I hide columns in Excel for the web?
Yes. Select the column header and use its context menu to hide the column. The web app’s ribbon and shortcuts may differ from Excel for Windows, so the header menu is a practical place to look for the command.
Why can’t I unhide a column?
Make sure your selection includes the hidden column’s neighboring headers, or select the entire worksheet and run Unhide Columns. If the sheet is protected, you may need the owner to allow column formatting or unprotect the sheet.
Related
- Bullet in Excel: Add Bullets to Cells and Lists
- Free Budget Tracker Excel Template: Setup and Tips
- Budget Template NZ Excel: Build a Practical Household Plan
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel: How to Paste Only Into Visible RowsTo enter the same value in filtered rows without changing hidden rows, select the destination cells, choose Home…
- How to Create File Labels in Word: A Step-by-Step GuideTo create file labels in Microsoft Word, open Mailings > Labels, choose the label brand and product number…
- Excel Max Value in a Column: Find the Largest NumberIf your values are in B2:B100, enter =MAX(B2:B100) in an empty cell; Excel returns the largest numeric value…
- How to Close an Open Dialog Box in ExcelTo close an open dialog box in Excel for Microsoft 365 on Windows, press Esc, click the dialog’s…
- How to Auto Archive Emails in New OutlookTo auto archive email in New Outlook, create a rule that matches the messages you want to file…
- How to Create and Print Return Address Labels in WordTo make return address labels in Microsoft Word, open Mailings > Labels, enter your return address, choose the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.