Yes. In Excel for Microsoft 365 on Windows, select a column or columns, right-click a selected column heading, and choose Hide; the cells stay in the workbook, but their columns are no longer displayed. You can show them again later with Unhide. Hiding is useful for tidying a worksheet, but it does not secure the data from someone who can access the workbook.
How to hide a column in Excel
A column is the vertical set of cells identified by a letter at the top of the worksheet. To hide one, click its letter heading, such as C, to select the entire column. Then right-click the heading and select Hide. Excel removes the column from the visible grid and adjusts the layout so the columns on either side appear next to each other.
You can also use the ribbon: select the column, then choose Home > Cells > Format > Hide & Unhide > Hide Columns. In desktop Excel for Windows, Ctrl+0 is a keyboard shortcut for hiding selected columns. If a shortcut does not work on your computer, use the menu command; system settings or other software can affect shortcut behavior. Excel for Mac has similar Hide and Unhide commands on the ribbon, though keyboard shortcuts can differ by keyboard and macOS settings.
To hide several neighboring columns, select their headings as a range. For example, drag from D to F, or click D and Shift-click F, then use Hide. To select separate columns, hold Ctrl while clicking each heading on Windows, then choose Hide. On Mac, use Command while selecting separate headings. The command applies to all selected columns.
How to unhide columns
To reveal a hidden column, select the visible headings on both sides of it. For example, if column C is hidden, select B and D together, right-click either selected heading, and choose Unhide. You can also select the neighboring headings and use Home > Cells > Format > Hide & Unhide > Unhide Columns.
If several columns in a range are hidden, select the headings on either side of the range before choosing Unhide. If the hidden columns are at the far left or right edge of a worksheet, there may not be a visible heading on both sides. For the first column, click the Name Box to the left of the formula bar, type A:A, and press Enter to select column A. Then use the ribbon’s Unhide Columns command. You can use the same approach with another column letter or range when locating a hidden area is difficult.
Another clue is a break in the sequence of column letters: for instance, A, B, D indicates that C is hidden. A very narrow column can look similar to a hidden one, so selecting the column and choosing Home > Cells > Format > Column Width can help distinguish a zero-width column from a narrow column. Unhide is usually the quickest fix either way.
What hiding a column does—and does not do
Hiding changes what is shown on the worksheet, not the underlying cell contents. The values, formulas, and formatting remain in those cells. Calculations that refer to a hidden column continue to use its values. For example, a total formula can still include figures in a hidden column, and a lookup formula can still return a value stored there.
Hidden cells are not erased, and hiding is not a privacy feature. Someone with access to the workbook may reveal the column, select cells through the Name Box or other navigation methods, inspect formulas that refer to them, or copy worksheet content. Whether a particular route is available can depend on workbook protection and the way the file is shared, but a hidden column alone should never be treated as a safe place for passwords, confidential personal details, or sensitive business information.
Hiding can affect what appears in other parts of a workbook. Hidden columns are normally omitted from a printed worksheet, just as they are omitted from the visible grid. Charts may also omit values in hidden rows or columns by default. If a chart should continue plotting hidden data, select the chart and look under Chart Design > Select Data > Hidden and Empty Cells for the option to show data in hidden rows and columns. Check the chart after changing the setting because chart behavior depends on its configuration.
When hiding is useful
Hiding is a practical choice when the information should remain available in the same worksheet but does not need to be visible during a particular task. A budget sheet, for example, might hide a temporary calculation column after its totals have been checked. A report may hide internal reference numbers so the main view focuses on names and results. A wide tracking sheet can hide older periods while keeping recent columns on screen.
It is also useful for temporarily reducing clutter while reviewing or presenting a workbook. Since the data remains in place, formulas and references generally do not need to be rebuilt just to change the view. Consider leaving a note, using a clear heading, or documenting the hidden fields on a separate instructions sheet if colleagues may need to find them later. A concealed column with no explanation can be mistaken for missing data or an error.
Protecting a hidden column from casual changes
If the goal is to stop ordinary users from unhiding a column accidentally, worksheet protection can add a barrier. In Excel for Microsoft 365 on Windows, choose Review > Protect Sheet. In the protection dialog, review the permissions and make sure users are not allowed to format columns if you want to restrict column-formatting actions such as hiding and unhiding. You can set a password, but anyone who needs to work with the sheet will need to know how it is protected.
Protection is not the same as keeping information confidential. It is designed to limit editing actions on a worksheet, not to encrypt selected cells or make hidden values inaccessible. A user may still be able to see or extract information in ways permitted by the workbook’s setup. Workbook-structure protection is a separate control, found under Review > Protect Workbook, and is aimed at actions such as changing sheet structure; it is not a substitute for protecting sensitive data.
For information that must not be shared with a recipient, the dependable approach is to remove it from the copy you share, or create a separate workbook containing only the authorized data. If you need to protect access to an entire Excel file, Excel’s file-encryption option is under File > Info > Protect Workbook > Encrypt with Password. Keep passwords in a safe place: losing one can make it difficult or impossible to open the protected file. Choose the protection method based on the actual risk, rather than assuming that a hidden column is secure.
Hiding columns versus filtering or grouping
Hiding a column is different from filtering. A filter hides rows that do not match selected criteria; it is suited to showing a subset of records, such as orders from one region. Hiding a column removes a field from view for everyone looking at that worksheet, without deciding which records qualify. If the issue is too many rows, use a filter rather than hiding data fields.
Grouping columns is another option when you want a visible control for collapsing and expanding a section. Select the columns and choose Data > Group. Excel adds an outline control, usually shown above the columns, so a reader can expand or collapse the group. Grouping is convenient for optional detail, such as monthly figures beneath an annual summary. It is still a presentation aid, not a security measure: collapsed columns remain in the workbook and can be expanded.
For a workbook intended for different audiences, separate sheets or separate files can be clearer than a large number of hidden columns. A summary sheet can display selected results while a detail sheet holds supporting data. Remember that hiding a sheet also does not, by itself, make its contents confidential.
Common problems and fixes
- Unhide is unavailable or does nothing: Check whether the worksheet is protected. If you have permission, review Review > Unprotect Sheet, then try Unhide again. If you do not have permission or the password, ask the workbook owner.
- The column seems to have disappeared: Look for a skipped letter in the headings, select the surrounding columns, and use Unhide. If the column is merely very narrow, select it and set a reasonable width through Home > Cells > Format > Column Width.
- You cannot select several columns as expected: Click the column letters, not just cells inside the grid. Use Shift for a continuous range and Ctrl on Windows or Command on Mac for separate selections.
- A chart no longer shows the figures: Check whether the chart is set to plot data in hidden rows and columns. The hidden cells can still contain correct values even when the chart leaves them out.
- The hidden data still affects a total: That is normal. Hiding is visual; formulas continue to calculate using referenced cells unless the formula itself excludes them.
Frequently Asked Questions
Can someone see a hidden column in Excel?
Yes. Anyone who can work with the worksheet may be able to unhide it or otherwise access its contents, depending on workbook permissions. Hiding alone does not protect the data.
Does hiding a column delete its formulas?
No. The cells and formulas remain in the workbook, and formulas elsewhere can continue to calculate from them. Unhide the column to view its contents again.
How do I hide multiple columns at once?
Select their column headings, either as one continuous range or as separate columns, then right-click and choose Hide. The ribbon option is Home > Cells > Format > Hide & Unhide > Hide Columns.
Can I hide a column in Excel without deleting it?
Yes. Use Hide on the selected column heading. This changes the worksheet display but leaves the cells and their contents in place.
Why can I not unhide a column?
The sheet may be protected, the column may be at the edge of the worksheet, or it may have an extremely small width rather than being hidden. Try selecting the column through the Name Box and using Unhide Columns, and check protection settings if needed.
Related
- ISERROR in Excel: How It Works and When to Use It
- ISBLANK in Excel: Examples and How It Works
- ISNUMBER in Excel: Check Whether a Cell Holds a Number
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Insert a Signature in Microsoft Word: StepsTo insert a signature in Microsoft Word, add a picture of your handwritten signature with Insert > Pictures…
- Conditional Formatting by Date Range in ExcelYes. In Excel for Microsoft 365 on Windows, select the cells to format, then choose Home > Conditional…
- Excel Data Validation List from a Table: How to Set It UpYes. In Excel for Microsoft 365 on Windows, create a workbook-level name that refers to the table column,…
- How to Create a Real Handwritten Signature in OutlookTo create a real handwritten signature in Outlook, write your name on paper, save a clear photo or…
- How to Change Email View in Outlook 365: Layouts and PanesTo change the email view in Outlook 365, use View > Change View in classic Outlook for Windows…
- Excel Data Model vs Power Query: How They Work TogetherPower Query cleans, reshapes, and imports data; the Excel Data Model stores related tables so you can analyze…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.