Hide Columns in Excel Temporarily: Steps to Show Them Again

How-to basics · Updated November 18, 2026

To temporarily hide columns in Excel for Microsoft 365 on Windows, select the column headers, then choose Home > Cells > Format > Hide & Unhide > Hide Columns. The data stays in the workbook; it is simply out of view until you unhide the columns. Before you start, decide which columns to conceal and, if the workbook matters, save it so you can easily return to a known version.

Hiding is useful when you want to focus on a smaller part of a wide worksheet, present a cleaner view, or keep supporting calculations out of sight while you work. It does not delete values or formulas, and it is not a security feature: someone who can use the workbook may be able to show the hidden columns again.

What You’ll Need

  • A workbook open in Excel. The steps below are for Microsoft 365 on Windows.
  • The letters of the columns you want to hide, or a way to identify them by their headers.
  • Optional: permission to edit the sheet. Worksheet protection may prevent you from hiding or unhiding columns.

Step-by-Step

  1. Find the columns to hide. Look at the lettered headers across the top of the worksheet and identify the columns you want out of view. Check the column letters as well as the header text; a heading may be blank, repeated, or different from what you expect. If you are concealing sensitive information, remember that hiding is only a display change, not a way to restrict access.
  2. Select the whole column or columns. Click a column letter to select that entire column. To select a continuous block, click the first letter, hold Shift, and click the last letter. For example, clicking B and then Shift-clicking D selects columns B through D. To select separate columns, hold Ctrl while clicking each column letter. On a Mac, use Command rather than Ctrl for a non-adjacent selection. You can also enter a column reference such as C:E in the Name Box, to the left of the formula bar, and press Enter to select that range.
  3. Hide the selection from the Home tab. With the columns selected, choose Home > Cells > Format > Hide & Unhide > Hide Columns. Excel removes the selected columns from the visible grid. The letters on either side will appear next to each other, which is a useful clue that one or more columns are hidden.
  4. Use the keyboard shortcut if you prefer. In Excel for Windows, select the columns and press Ctrl+0 (zero) to hide them. On a Mac, press Command+0. Keyboard shortcuts can be affected by system settings or keyboard layouts, so use the ribbon command if the shortcut does not respond. In Excel for the web, the browser or web interface may handle shortcuts differently; the Home tab’s Format menu is a dependable option.
  5. Check that the worksheet still works as expected. Review the visible area and any formulas, charts, or summaries that depend on the hidden columns. Hiding columns does not remove their contents, so formulas can continue using those values. A chart’s display of hidden data can depend on its settings, so confirm that important charts still show the information you intend to present.
  6. Unhide the columns when you need them again. Select the visible column headers on both sides of the hidden area. For example, if C and D are hidden between B and E, select B through E, right-click a selected header, and choose Unhide. You can also use Home > Cells > Format > Hide & Unhide > Unhide Columns. Excel restores the columns without changing their cell contents.
  7. Save the workbook if you want the hidden view to remain its current saved state. Save normally with Ctrl+S on Windows or Command+S on a Mac. The hidden state is stored with the workbook, so other people opening that saved file may also see those columns hidden. If you need to give someone the data, make clear that it has been hidden rather than removed.

Common Mistakes

Selecting cells instead of column headers: Clicking inside a cell selects only that cell or range. The Hide Columns command applies to whole columns, so begin by selecting the lettered headers. If the command appears unavailable or behaves unexpectedly, check the selection before trying again.

Assuming hidden means private: The values remain in the workbook and are easy to reveal. Do not use hidden columns to protect passwords, personal details, confidential figures, or other restricted information. Remove the data or use an appropriate access-controlled copy if it should not be shared.

Choosing Delete instead of Hide: Deleting columns removes their contents and may shift or break references. Use the Hide Columns command when your goal is only to simplify the view. If you accidentally delete data, use Undo immediately if possible, or restore a saved copy.

Hiding only one column in a group: When several neighboring columns are involved, make sure the full range of header letters is selected. A small selection can make it look as though Excel has ignored the rest of your intended range.

Expecting a filter to hide columns: Filters hide rows that do not meet criteria; they do not hide fields or columns. Use the column-header selection and Hide Columns command for columns.

Tips

Keep a note of the hidden range. In a wide worksheet, it is easy to forget whether you hid one column or several. Record the range in a nearby note, worksheet instructions, or a separate change log if other people use the file. This makes it easier to restore the intended view later.

Use the outline feature for columns you hide and show repeatedly. Excel can group columns so you can collapse or expand them using outline controls. Select the columns, then choose Data > Group. Use the minus or plus outline button above the worksheet to collapse or expand the group. Grouping is convenient for recurring detail sections, while ordinary hiding is quicker for a one-off change. To remove the grouping, use Data > Ungroup.

Consider what other viewers will see. Hidden columns are generally omitted from the worksheet’s visible print area, but check Print Preview before printing or exporting to PDF. Also review charts and formulas that refer to the hidden data, especially when preparing a report for someone else.

Use the Name Box to move directly to a hidden range. If you know the column reference, enter it in the Name Box and press Enter. This can help you select a range that is difficult to reach by scrolling. It does not unhide the columns by itself; after selecting, use the Unhide Columns command.

Protect the worksheet only when appropriate. Sheet protection can limit changes, including hiding or unhiding columns depending on the protection options. It is intended to prevent certain edits, not to secure the workbook’s contents. Keep an unprotected working copy if you need to change the layout and do not have the required permission.

Troubleshooting

The Hide Columns command is unavailable: Confirm that you selected column headers, not just cells. If the sheet is protected, go to Review and check whether Unprotect Sheet is available. You may need the password or the workbook owner’s help. In a shared or restricted workbook, your permissions may also limit layout changes.

Ctrl+0 does nothing: Use Home > Cells > Format > Hide & Unhide > Hide Columns instead. Check that the intended columns are selected and that the keyboard focus is in Excel rather than another app or dialog. On Mac, use Command+0; on the web, prefer the ribbon if your browser intercepts the key combination.

You cannot find the hidden columns to select them: Look for a break or double line between neighboring column letters. Select the visible headers on both sides of that gap, then choose Unhide. If the hidden range is at the left edge, such as column A, there may be no visible column to its left. Select the whole worksheet using the small triangle at the top-left corner where the row and column headers meet, then use Home > Cells > Format > Hide & Unhide > Unhide Columns. Alternatively, enter A:B in the Name Box, press Enter, and use the same Unhide Columns command.

Unhide does not restore the columns: Check whether more than one column is hidden and expand the selection to include all visible headers around the hidden area. If the columns are merely extremely narrow rather than hidden, select them and use Home > Cells > Format > Column Width to set a visible width, or choose AutoFit Column Width. Protection can also prevent a change, so check the Review tab if the command is disabled.

The columns return, but the layout still looks wrong: Unhiding restores visibility, but a column may have a very small width or another display setting may make its contents hard to see. Select the restored columns and use Home > Cells > Format > AutoFit Column Width, or drag the boundary between column letters to set the width manually. If the workbook was saved after hiding, simply saving again will preserve the current visible state.

Frequently Asked Questions

Does hiding a column delete its data?
No. The cells, formulas, and formatting remain in the worksheet. Hiding changes what is displayed, and unhiding makes the columns visible again.

Can I hide several columns at once?
Yes. Select a continuous range by clicking its first and last column headers while holding Shift, or select separate columns with Ctrl-click on Windows or Command-click on Mac. Then use Hide Columns once.

How do I hide a column without a mouse?
Select the column using keyboard navigation, then press Ctrl+0 on Windows or Command+0 on Mac. If that shortcut is unavailable on your setup, use the ribbon command: Home > Cells > Format > Hide & Unhide > Hide Columns.

Can I hide columns in Excel for the web?
Yes. Select the column headers, then use the Home tab’s Format menu and choose Hide & Unhide, followed by Hide Columns. The web interface and keyboard shortcuts can vary with browser focus, so use the menu when a shortcut does not work.

Will other people see the columns I hid?
If you save the workbook with the columns hidden, people who open that saved workbook will generally see the same hidden layout. They can unhide the columns if they have permission. Hiding is not a way to keep data confidential.

What is the difference between hiding and grouping columns?
Hiding conceals selected columns until you manually unhide them. Grouping adds outline controls that let you collapse and expand a section repeatedly, which is useful for detail columns in a report. Neither method deletes or secures the data.

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.