To hide columns in Excel for Microsoft 365 on Windows, select one or more column headers, right-click the selection, and choose Hide. The columns disappear from view, but their contents remain in the workbook and can still be used in formulas. You can restore them later with Unhide. Before hiding anything, save the workbook if you are making a substantial layout change or working with an important file.
What You’ll Need
- An Excel workbook that you can edit. If it is read-only or protected, you may need permission or to remove worksheet protection first.
- A way to identify the columns you want to conceal, such as their letter headers or the labels in the first row.
No add-ins or special settings are needed. Hiding is a display change, not a way to encrypt or secure data: anyone who can edit the sheet may be able to unhide the columns.
Step-by-Step
-
Open the worksheet and find the columns. Open the workbook in Excel and select the worksheet tab that contains the columns. Look at the letters across the top of the grid, such as A, B, and C. Click a column letter to select that entire column. If you are hiding a field such as an internal note or an old calculation, check its header and a few cells first so you do not conceal information that readers need.
-
Select one or more columns. For one column, click its letter header. For adjacent columns, click the first header, hold Shift, and click the last header; for example, selecting B and then Shift-clicking E selects B through E. You can also drag across the column letters. To select columns that are not next to each other, hold Ctrl on Windows while clicking each header. On a Mac, use Command-click for nonadjacent selections. Keep the selection on the header row, not just on cells in the worksheet, when your goal is to hide whole columns.
-
Hide the selected columns with the context menu. Right-click one of the selected column letters, then choose Hide. Excel removes the selected columns from the grid. The letter sequence skips over them: if C is hidden, for example, the visible headers may jump from B to D. The cells in the hidden columns have not been deleted or cleared.
-
Use the ribbon if you prefer menus. Select the column or columns, then choose Home > Format > Hide & Unhide > Hide Columns. This is the Microsoft 365 for Windows ribbon path. It performs the same action as the right-click command. If the ribbon is collapsed, click the Home tab or expand the ribbon to see the Format menu.
-
Use the keyboard shortcut if it is available. In Excel for Windows, select the column headers and press Ctrl+0 (zero, not the letter O). Some Windows keyboard or system settings can prevent this shortcut from working. If nothing happens, use the context menu or ribbon path instead. On Mac, Excel commonly uses Command+0 to hide selected columns, but shortcut behavior can depend on the keyboard and macOS settings; the menu command is the dependable alternative.
-
Check the result and save. Confirm that the intended letters are missing from the header sequence and that neighboring columns are still visible. Then save the workbook with Ctrl+S on Windows or Command+S on Mac. Hiding columns does not change formulas, charts, or values by itself, but it can change what someone sees when they open or print the sheet.
-
Unhide columns when you need them again. Select the visible columns on both sides of the hidden range. For example, if C and D are hidden, select B and E by dragging across the headers from B through E, or select the range that spans them. Right-click a selected header and choose Unhide. Alternatively, use Home > Format > Hide & Unhide > Unhide Columns. Selecting the columns on both sides is important because the hidden headers themselves cannot be clicked.
-
Recover a hidden first or last column. If column A is hidden, there may be no visible column immediately to its left. Click the worksheet Select All button at the top-left corner of the grid, where the row and column headers meet, then use Home > Format > Hide & Unhide > Unhide Columns. You can also enter a range such as A:B in the Name Box to select it, then right-click the column headers and choose Unhide. If the last column is hidden, selecting the whole sheet is usually simplest.
In Excel for the web, you can generally select the column headers, right-click, and choose Hide columns; the wording and ribbon layout may vary slightly from the Windows desktop app. On Mac, use the same header-selection approach and the available Hide or Unhide menu command. If you cannot find the command in your version, select the headers and use the right-click menu.
Common Mistakes
- Selecting cells instead of column letters: Hiding a selected cell range is not the same as hiding the whole column. Click the letter headers at the top of the worksheet to select entire columns.
- Deleting instead of hiding: Do not choose Delete if you only want a cleaner view. Deleting a column removes its contents and can affect formulas or references. Hide leaves the column in place.
- Assuming hidden means private: Hiding only changes what is displayed. It does not prevent other workbook users from unhiding the data, and it does not remove the data from the file.
- Trying to unhide from a single neighboring column: If a hidden column lies between B and D, selecting only D may not expose it. Select the visible columns on both sides of the hidden range, or select the whole sheet.
- Hiding a column that is needed for printing or review: Hidden columns are commonly omitted from a printed worksheet. Preview the printout and check with the people who use the file before hiding key fields.
Tips
- Hide several columns in one action. Select all the relevant headers first, including nonadjacent headers with Ctrl-click on Windows or Command-click on Mac, then use Hide once. This is quicker and reduces the chance of hiding the wrong column one at a time.
- Keep a simple record of what you hid. If a workbook will be shared, add a note in a visible area or document the hidden fields in instructions. This helps another editor understand why the header letters skip and where supporting calculations are located.
- Use grouping when readers should expand and collapse columns repeatedly. Select the columns and choose Data > Group. Excel adds an outline control that can collapse or expand the grouped columns. Grouping is useful for optional detail, but it is not a security feature either.
- Check the worksheet before sharing. Review the visible data, formulas, charts, and print layout. If the goal is to share a clean report rather than the underlying working data, consider whether a separate presentation copy is more appropriate than hiding columns in the original.
- Remember that filters and hidden columns are different. A filter hides rows that do not match a condition; it does not hide columns. If you want to remove fields from view, select the column headers and use Hide.
Troubleshooting
Hide is unavailable or nothing happens. First confirm that you selected column letters, not just worksheet cells. If the sheet is protected, Excel may block formatting changes, including hiding columns. On Windows, check Review > Unprotect Sheet; you may need the password set by the workbook owner. If the workbook is opened in read-only mode, request edit access or save an editable copy if permitted.
Ctrl+0 does not work. The zero may be intercepted by Windows or a keyboard setting. Use the ribbon command Home > Format > Hide & Unhide > Hide Columns or right-click the selected headers. Do not keep pressing the shortcut if you are unsure whether the correct columns are selected.
Unhide does not reveal the column. Select the visible headers on both sides of the hidden area, then choose Unhide. If you cannot tell which columns are hidden, use the Select All button and run Home > Format > Hide & Unhide > Unhide Columns. Check for a very narrow column as well: a column set to a tiny width can look hidden even when it is not. Select it and choose Home > Format > Column Width to enter a readable width.
The hidden column seems to have disappeared permanently. Check whether the column was deleted, whether you are on the correct worksheet, and whether the workbook was saved after the change. If it was deleted, try Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, provided you have not closed the workbook or performed actions that cleared the undo history. If the file was already saved and closed, restore from a backup or version history if available.
A hidden column appears in a chart or formula. That can be expected: hiding a column does not normally remove its values from formulas, and chart behavior depends on the chart’s data settings. If you need a chart not to plot hidden data, open the chart’s data settings and check whether data in hidden rows and columns is included. Do not assume hiding a column changes calculations.
Frequently Asked Questions
Can I hide multiple columns at once?
Yes. Select adjacent column headers with Shift-click or drag across them. For separate columns, Ctrl-click their headers on Windows or Command-click on Mac. Then right-click the selection and choose Hide.
Does hiding a column delete its data?
No. The values, formulas, and formatting remain in the worksheet. Hiding only removes the column from the current view. Use Delete only when you intend to remove the column and its contents.
How do I hide a column without using the mouse?
Select a cell in the column, then use the keyboard to select the entire column with Ctrl+Space on Windows; on Mac, the equivalent can depend on macOS keyboard settings. Press Ctrl+0 on Windows to hide it. If a shortcut is intercepted, use the ribbon menu. Selecting the header directly is often easier when hiding multiple columns.
Can I hide column A?
Yes. Select column A and choose Hide. To show it again, select the whole worksheet with the Select All button or enter A:B in the Name Box, then choose Home > Format > Hide & Unhide > Unhide Columns.
Will other people be able to see a hidden column?
Usually, yes. Anyone with suitable access to the worksheet can unhide it. Sheet protection can restrict some editing actions, but hiding alone is not a reliable way to protect confidential information. Remove sensitive data from a copy before sharing if recipients should not receive it.
Can hidden columns still affect formulas?
Yes. A formula can continue to refer to cells in a hidden column, and its results can remain visible. Hiding columns changes the view, not the underlying calculation. Check formulas and chart settings separately if you need to change which data is used.
Related
- Clean Excel Data With Power Automate: A Practical Guide
- Clean Excel Columns: Remove Spaces, Duplicates, and Errors
- Clean Excel Data: Practical Steps, Tools, and Common Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- BI Conditional Formatting in Power BI: Rules and UsesBI conditional formatting uses color, icons, data bars, or other visual cues to make important values in a…
- How to Name a Dropdown List in Excel with a Named RangeTo name a dropdown list in Excel, give its source cells a name, then use that name as…
- Google Sheets UNIQUE Function: How to Find Distinct ValuesTo list distinct values in Google Sheets, enter =UNIQUE(A2:A) in an empty cell, replacing A2:A with your data…
- Excel Workbook History: View, Compare, and Restore VersionsTo view Excel workbook history, open a workbook saved in OneDrive or SharePoint and choose File > Info…
- How to Schedule an Email in Outlook on the Web (OWA)To schedule an email in Outlook on the web, compose your message, open the menu beside Send, choose…
- How to Create a Mail Merge Document in Microsoft WordTo create a mail merge in Microsoft Word, prepare a recipient list—usually in Excel—then use Word’s Mailings tab…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.