Excel Hide Specific Columns: Steps and Tips

How-to basics · Updated November 19, 2026

To hide specific columns in Excel for Microsoft 365 on Windows, select the column letter or letters, then choose Home > Cells > Format > Hide & Unhide > Hide Columns. The columns disappear from view, but their data remains in the workbook and can be unhidden later.

What Hiding Columns Does

Hiding a column changes how the worksheet is displayed; it does not remove the column or its contents. For example, if column C contains internal notes that are not needed in a presentation, you can hide C while keeping the data available in the workbook. Columns to its right shift visually, so the visible headers may jump from B to D.

Values in hidden columns can still be used in formulas, charts, and other workbook features. A formula that refers to a hidden cell continues to calculate normally. Hiding is therefore useful for tidying a view, but it is not a way to delete data or keep confidential information secure. Anyone with access to the workbook may be able to unhide the column or inspect its contents in another way.

Hide One Column or Several Columns

For a single column, click its letter at the top of the worksheet to select the entire column. Then use Home > Cells > Format > Hide & Unhide > Hide Columns. You can also right-click the selected column header and choose Hide. Both approaches hide the full column, including cells that are currently blank.

To hide a continuous range, click the first column letter and drag across the headers, or select the first header and Shift-click the last one. For example, selecting C through F and choosing Hide Columns hides all four columns together. The same operation works when you select a range of cells that spans those columns: Excel hides the selected columns as a whole, not just the cells in the selection.

To select columns that are not next to each other, hold Ctrl while clicking each column letter on Windows. For instance, select B, then Ctrl-click E and H; use the Hide Columns command to hide all three. If selecting headers with the mouse is awkward, click the Name Box to the left of the formula bar, type a range such as B:B or C:F, and press Enter. To select nonadjacent ranges there, enter a comma-separated reference such as B:B,E:E. With the desired columns selected, use the same Hide Columns command.

Unhide Columns Later

To reveal a hidden column, select the visible columns on both sides of it, right-click one of their headers, and choose Unhide. If C is hidden, select B and D together first. For several hidden columns in a continuous block, select the visible columns that bracket the block and choose Unhide.

You can also select the surrounding columns and use Home > Cells > Format > Hide & Unhide > Unhide Columns. If the hidden column is at the far left of the sheet, select the worksheet using the Select All button at the intersection of the row numbers and column letters, then choose Unhide Columns from the Format menu. Be aware that selecting the whole sheet this way can reveal every hidden column in that worksheet, not just the one you were looking for.

When you are unsure which columns are hidden, look for a break in the header lettering—for example, B followed by D—and for a narrow double line between column headers. You can also select the entire sheet and unhide all columns, then hide only the ones you want again. That is quick for a small, uncomplicated worksheet, but it may expose columns intentionally hidden by someone else, so check the sheet before doing it in a shared workbook.

Keyboard Shortcuts and Other Ways to Hide

On Windows, select the column or columns and press Ctrl+0 to hide them. The ribbon and right-click menu are useful alternatives when you cannot remember the shortcut or when a keyboard layout, system setting, or device intercepts it. If the shortcut does not work, use the menu path rather than assuming the column selection is wrong.

Excel for Mac has different keyboard conventions, and shortcut behavior can depend on the keyboard and macOS settings. Use the column-header context menu or the Format controls in the Excel ribbon if a shortcut is unavailable. In Excel for the web, select the column headers and use the context menu’s Hide option; some keyboard combinations may be handled by the browser instead of Excel. Menu labels can vary slightly across platforms and interface updates, but the essential action is to select whole columns and choose Hide.

Hiding columns is also different from narrowing them until they appear absent. A very narrow column can be difficult to identify and restore, whereas the Hide command gives Excel a distinct hidden-column state. Prefer Hide when the goal is to temporarily remove fields from view.

Hide, Group, Filter, or Delete?

Choose the tool that matches the job. Hiding is a simple way to remove particular columns from the current view. Grouping is better when people should be able to expand and collapse a related set of columns themselves. Filtering controls which rows are displayed based on values; it does not hide selected columns. Deleting removes the columns and their contents, which is a different and potentially destructive action.

  • Hide: Use it for fields you want to keep in the workbook but temporarily leave out of sight.
  • Group: Select the columns and choose Data > Outline > Group to add an outline control for collapsing and expanding them. Grouped columns are still present and can be shown with the outline buttons.
  • Filter: Use Data > Filter when you want to show or exclude rows based on criteria, such as displaying only orders marked Open.
  • Delete: Use it only when the columns and their data should actually be removed. Check formulas and linked content first, because deleting can affect references.

For example, a monthly report might keep transaction IDs and staff notes in the workbook but hide those columns for a cleaner review. If reviewers need to open and close a block of supporting detail repeatedly, grouping it may be more convenient than hiding it outright. If the goal is to prevent readers from seeing sensitive information, neither hiding nor grouping is sufficient protection.

Formulas, Charts, Printing, and Sharing

Hidden columns remain part of the worksheet’s data. Calculations that reference them generally continue to work, and hiding a column does not itself erase a chart’s source values. Chart display options can affect whether hidden data appears in a chart, so if a chart changes unexpectedly, review its data settings rather than assuming the source column has been deleted.

Hidden columns are usually omitted from a normal worksheet printout, just as they are omitted from the on-screen grid. If a printed report must include the information, unhide the columns before printing or create a separate print-friendly layout. Check Print Preview, since page scaling and print-area settings can make a sheet look different on paper than it does in the worksheet.

When sharing a workbook, remember that the hidden state is part of the workbook’s presentation, not a confidentiality boundary. A recipient can select neighboring columns and unhide the hidden ones. If a file must not disclose certain data, remove that data from the copy you share and review other places it could appear, such as formulas, comments, charts, or other sheets. Worksheet protection can limit some editing actions, but it should not be treated as a way to securely conceal information.

Common Problems and Fixes

A frequent issue is trying to unhide a column by selecting only the visible column on one side. Excel needs the hidden column to be included between selected headers, so select columns on both sides of the gap. For a hidden first column, select the whole sheet or enter A:A in the Name Box, then use Unhide Columns.

If the column seems missing but Unhide does not restore it, check whether its width was set to zero or made extremely small. Select the columns around the gap and choose Home > Cells > Format > Column Width to assign a visible width, or use AutoFit Column Width where appropriate. Also check whether the worksheet is protected; protection may restrict formatting actions, including hiding or unhiding columns. If so, you may need permission from the workbook owner to change the sheet.

Another common misunderstanding is that hiding columns changes a formula’s result. Usually it does not: the underlying values remain available. If a total changes, investigate edits to the data, formula references, filters, or calculation settings rather than treating the hide operation as a deletion. Similarly, hiding a column does not guarantee it will stay hidden in every copy or view; a user can change the workbook’s display state.

Frequently Asked Questions

Can I hide only one column in Excel?
Yes. Click its column letter, then choose Home > Cells > Format > Hide & Unhide > Hide Columns, or right-click the header and choose Hide.

How do I hide multiple nonadjacent columns?
On Windows, hold Ctrl and click each column letter you want to hide. Then use the Hide Columns command. On Mac, use the platform’s selection modifier or select ranges through the Name Box if the mouse-selection behavior differs.

How do I unhide column A?
Select the whole worksheet with the button above row 1 and left of column A, then choose Home > Cells > Format > Hide & Unhide > Unhide Columns. This can reveal other hidden columns on the sheet as well.

Does hiding a column delete its data or affect formulas?
No. Hiding changes the display, not the stored contents. Formulas can still refer to hidden cells, and you can restore the column later.

Can I password-protect a hidden column?
Excel does not provide a secure password for an individual hidden column. Sheet protection can restrict certain actions, but it is not a reliable method for concealing confidential data. Remove sensitive information from any workbook copy that should not contain it.

Why can’t I unhide a column?
Make sure you selected the visible headers on both sides of the hidden column, or select the entire sheet if the missing column is at an edge. If that does not help, check for a zero or very small column width and whether sheet protection limits formatting changes.

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.