How to Hide Columns in Excel Without Deleting Data

To hide columns in Excel for Microsoft 365 on Windows, select the column letters, right-click the selection, and choose Hide. The data stays in the workbook and can be shown again later. You can hide one column, a continuous range, or several separate columns; first save the workbook if you are making a substantial layout change.

What You’ll Need

A workbook open in desktop Excel. The steps below use Microsoft Excel for Microsoft 365 on Windows.
Permission to change the worksheet. If the sheet is protected, you may need the password or permission to format columns.
The letters of the columns you want to hide. Check the headers carefully so you do not hide information needed for the worksheet’s current task.

You do not need to delete, move, or copy any data. Hiding a column changes what is displayed, not the underlying cell values, formulas, or references. If you are using Excel for the web or Excel for Mac, the main selection and right-click steps are similar; menu and keyboard details are noted below.

Step-by-Step

Open the worksheet and identify the columns. Click the worksheet tab that contains the columns. Column letters appear across the top of the grid, above the cells. Decide which columns should be out of view, and check the letters before selecting anything. For example, if you want to conceal a column containing internal notes, make sure you have identified that column rather than a nearby column with information other people need.
Select one column or a continuous range. To select a single column, click its letter at the top of the worksheet. To select adjoining columns, click the first column letter and drag across the other letters, or click the first letter, hold Shift, and click the last letter. For example, selecting the headers C through E selects all three columns, including every cell in those columns. You can also click a column letter, hold Shift, and use the left or right arrow key to extend the selection.

Make sure the entire column is selected: the column letter should be highlighted and the selection should extend down the worksheet. Clicking a cell inside the grid selects only that cell or range, not the whole column. If you hide a cell selection, Excel may hide the row or column only when the selection covers the appropriate full rows or columns, so using the header letters is the clearest approach.
Select separate columns if they are not next to each other. Click the first column letter, then hold Ctrl on Windows while clicking each additional column letter. Keep Ctrl held until all the desired columns are selected. For example, you can select B, E, and H without selecting C, D, F, or G. On a Mac, hold Command instead of Ctrl while clicking separate column headers. Check the highlights before proceeding; clicking a header without the modifier key can replace the existing selection.
Hide the selected columns. Right-click one of the highlighted column letters and choose Hide. Excel removes the selected columns from view and the remaining columns shift together visually. If you selected several separate columns, they should all disappear from the grid. Do not choose Delete: that removes cells or data rather than simply concealing the columns.

You can use the ribbon instead. With the columns selected, choose Home > Cells > Format > Hide & Unhide > Hide Columns. The commands are under the Home tab in the Cells group. If the ribbon is collapsed or the Excel window is narrow, expand the ribbon or look for the Format menu in the Cells group. The wording may be arranged slightly differently in a localized version of Excel.
Check the result and the surrounding layout. Look at the column letters on either side of the gap. Excel does not show a normal-width column where the hidden columns were; for instance, the visible letters may jump from A to D if B and C are hidden. Review nearby formulas, headings, and charts to confirm the sheet still makes sense. Hiding a column generally does not change formulas that refer to it, but a chart or report may still use its values.
Unhide columns when you need them again. Select the visible column headers on both sides of the hidden range, including the space where the hidden columns are. For example, if B and C are hidden, select A through D by dragging across the headers, then right-click the selection and choose Unhide. Alternatively, choose Home > Cells > Format > Hide & Unhide > Unhide Columns.

If the hidden column is at the far left or right edge, or you cannot select the surrounding headers, click the Select All button at the top-left corner of the grid, where the row and column headings meet. Then use the ribbon’s Unhide Columns command. This reveals every hidden column on that worksheet, so use it when revealing all hidden columns is acceptable. You can also use the Name Box to select a specific column reference, such as A:A, and then choose Unhide from the ribbon or a context menu.

On Excel for Mac, you can use the same column-header selection and right-click menu, or use the Home tab’s Format commands. The Mac shortcut for hiding selected columns is Command+0; use the menu if that shortcut is intercepted by macOS or does not work on your keyboard. In Excel for the web, select the headers and use the right-click Hide command when available, or look for the column-hiding command on the Home ribbon. Some desktop options and shortcuts may differ in the browser.

Common Mistakes

Selecting cells instead of column headers. A selection such as C2:C20 is a range of cells, not the entire column. Click the C header when the goal is to hide all of column C. This also makes the intended action easier to verify before you apply it.
Using Delete instead of Hide. Delete can remove cell contents or shift other cells, depending on the command chosen. Hide simply removes the column from view. If you only want a cleaner display or to temporarily limit what is visible, choose Hide.
Assuming hidden means private or protected. Hiding is a display choice, not a security measure. Someone who can edit or inspect the workbook may be able to unhide the columns, and formulas or charts may still reveal information from them. Do not rely on hiding columns to protect confidential data.
Hiding a column that a reader needs to use the sheet. A worksheet may appear broken if an important input or label is concealed. Consider whether a group of columns should be hidden only in a separate presentation copy, or whether an explanatory note would prevent confusion.
Forgetting that multiple selections need the modifier key. When choosing nonadjacent columns, Ctrl-click on Windows or Command-click on Mac. Without the modifier, Excel may replace the previous selection, leaving only the last column selected.

Tips

Use a clear selection before applying the command. For a continuous span, selecting the first and last headers with Shift is often more reliable than dragging a long distance. For separate columns, pause to check each highlighted header before choosing Hide.
Keep a record of what you concealed. If columns are hidden to simplify a shared worksheet, add a note in a visible cell or document the column letters for collaborators. This helps someone understand why the sequence of visible letters skips over a section.
Consider grouping for columns that will be opened and closed repeatedly. Excel’s outline feature can add a plus or minus control to expand or collapse a selected range. Use Data > Group after selecting the columns. Grouping is useful for optional detail, while Hide is more direct for a one-time change. Grouping does not replace worksheet protection or make data private.
Remember that hiding does not remove values from calculations. A SUM formula or other calculation can still include cells in hidden columns. If a report should exclude those values, change the formula or data source rather than relying on the columns being out of sight.
Use a copy when preparing a special-purpose view. If the workbook is shared or used for important work, save a separate copy before changing its layout. This gives you a straightforward way to return to the original display without changing the source file.

Troubleshooting

The Hide command is unavailable or has no effect. Check that you selected column letters rather than individual cells, and try the Home ribbon command. If the worksheet is protected, Excel may prevent formatting columns. Ask the workbook owner for access or, if you are authorized, use Review > Unprotect Sheet and enter the password. A protected sheet may allow column formatting only when that permission was enabled.
You cannot find a column to unhide. If the letters jump across a range, select the visible headers on both sides of the jump and choose Unhide. If the hidden column is the first one, selecting the whole sheet with the top-left Select All button is a reliable way to reveal it. The Name Box can also select a known column such as A:A even when it is hidden.
The keyboard shortcut does nothing. On Windows, Ctrl+0 hides selected columns, but system settings or keyboard utilities can intercept shortcuts. Use the right-click Hide command or the ribbon instead. On Mac, use Command+0 only if it works in your setup; otherwise use the menu. A menu command is also preferable when you are unsure which columns are currently selected.
A column looks missing, but Unhide does not restore it. Check whether the column width was set to zero rather than the column being hidden. Select the column or surrounding range, then choose Home > Cells > Format > Column Width and enter a positive width, or choose Home > Cells > Format > AutoFit Column Width. Also check for a collapsed outline group using the plus control above the column headings.
The sheet appears to skip rows or columns for another reason. Frozen panes, filters, and split windows can change what is visible without hiding a column. Look for a thick divider that indicates frozen panes, or check whether a filter is hiding rows. Those features need their own commands; unhide will not undo a filter or remove a frozen-pane divider.

Frequently Asked Questions

Does hiding a column delete its data?
No. The cell contents and formulas remain in the workbook. Hiding only changes the worksheet display. Use Delete only when you intend to remove cells or data.

Can I hide several nonadjacent columns at once?
Yes. On Windows, hold Ctrl while clicking each column letter; on Mac, hold Command. After selecting all the headers, right-click one of them and choose Hide.

Will formulas still use hidden columns?
Yes. Hiding a column does not remove its values from calculations or break ordinary cell references. Check the relevant formulas if the goal is to change a result rather than simply make the inputs less visible.

How do I hide a column in Excel for the web?
Select its letter, right-click the header, and choose Hide if that option appears. You can also check the Home ribbon for column-formatting commands. The exact interface can vary as Excel for the web changes.

Can I hide columns so other people cannot see the information?
No. Hidden columns can be unhidden, so hiding is not a confidentiality control. Remove sensitive information from a file before sharing it, or use appropriate access controls and a separate workbook containing only the information recipients should see.

Why do the column letters skip after I hide something?
Excel keeps the original column letters even when columns are hidden. A jump such as A to D usually means B and C are hidden, not deleted. Select the columns around the gap and use Unhide to show them again.

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.