Yes. In Excel for Microsoft 365 on Windows, select the column letter, right-click it, and choose Hide. To show it again, select the column headers on both sides of the hidden column, right-click, and choose Unhide. Hiding changes what is displayed, not the underlying data: formulas and other workbook features can still use the values.
What hiding a column does
Hiding a column makes it disappear from the worksheet grid by reducing its displayed width to zero. The column is still part of the worksheet, and its cells, values, formulas, and formatting remain in the workbook. For example, if you hide column C, the visible headers may jump from B to D. The data in C has not moved into D or been deleted.
This is useful when a sheet contains supporting calculations, identifiers, notes, or older-period figures that are not needed for a particular view. You can keep those details available without asking every reader to scroll past them. Hiding is reversible and generally quicker than deleting data and rebuilding it later.
There is an important limitation: hiding is not a security measure. Someone with access to the workbook can usually unhide the column, and the hidden values may still be used in formulas, charts, or other workbook content. Do not rely on hiding to protect confidential information.
Hide one or more columns using the ribbon
The ribbon command is easy to find and works well when you do not remember a keyboard shortcut. To hide a column in Excel for Microsoft 365 on Windows:
- Click the column letter at the top of the worksheet. Clicking the letter selects the whole column, not just the cell you are working in.
- To select several neighboring columns, drag across their letters, or select the first letter and Shift-click the last one. To select separate columns, hold Ctrl while clicking their letters.
- On the ribbon, choose Home > Format > Hide & Unhide > Hide Columns.
You can also right-click a selected column header and choose Hide. That is often the fastest method for a single column. If you right-click a cell inside the column instead of its letter, the context menu may show a different set of choices, so selecting the header first helps avoid confusion.
To hide a column at the far edge of a selected range, select its letter as usual. The same commands apply whether the column is empty or contains data. Hiding a blank column is rarely useful by itself, but it can help create a cleaner layout or presentation.
Keyboard shortcuts and Mac differences
In Excel for Windows, select one or more column headers and press Ctrl+0 to hide the selected columns. The shortcut for unhiding selected columns is Ctrl+Shift+0. On some Windows setups, that unhide shortcut may be intercepted by regional or keyboard settings; use the ribbon or right-click menu if it does not work.
Excel for Mac has different keyboard conventions, and shortcuts can vary with the keyboard and macOS settings. The dependable method is to select the column headers and use the contextual menu or the commands on the Home tab. Excel for the web also provides column-header context-menu commands; the exact menu presentation can differ slightly from the Windows desktop app.
Shortcuts act on the selection. If only a cell is selected, Excel may hide the column containing that cell, but selecting the column letter makes the intended scope clear. When working with several nonadjacent columns, verify that all intended headers are selected before using a shortcut.
How to unhide a column
For a hidden column between two visible columns, select the visible headers immediately to its left and right, right-click the selection, and choose Unhide. For example, if C is hidden, select B and D together before opening the context menu. You can select a range that spans the hidden column as well, such as B through D.
The ribbon offers another route: select the relevant headers, then choose Home > Format > Hide & Unhide > Unhide Columns. If the hidden column is at the left edge of the sheet, select column B and use Unhide Columns from the ribbon. This is useful because there is no visible column header to click on the hidden side.
If you do not know where hidden columns are, select the entire worksheet using the Select All button at the intersection of the row numbers and column letters, then choose Home > Format > Hide & Unhide > Unhide Columns. This can reveal hidden columns throughout the sheet, so use it carefully if the workbook intentionally keeps some columns out of view.
For more than one adjacent hidden column, select the visible headers on both sides of the hidden span and run Unhide. If the columns are at an edge, select the nearby visible columns and use the ribbon command. You can also inspect the header sequence: a missing letter, or a small boundary indicator between headers, can signal that a column is hidden.
Why a column may seem impossible to reveal
A common issue is selecting only one neighboring column. Excel needs the selection to include the hidden column’s boundary; select the visible headers on both sides, or use the ribbon method after selecting a range that includes the area. For column A, which has no visible column to its left, select B and use Unhide Columns.
Sometimes a column is not hidden but merely very narrow. Drag the boundary between its header and the next one to widen it, or select the column and choose Home > Format > Column Width to enter a width. A hidden column has effectively zero width, while a narrow column still has a small visible area or boundary you can adjust.
Worksheet protection can also prevent changes to column formatting. If Excel will not let you hide or unhide columns, check whether the sheet is protected. On the ribbon, look under Review for the sheet protection control; you may need the workbook owner or password to change protected-sheet settings. Do not confuse sheet protection with a hidden column: protection can restrict editing, while hiding changes visibility.
Finally, check whether the apparent gap is caused by collapsed outline groups. Grouped columns can be expanded or collapsed using the outline controls above the column headers. That is related to hiding, but it is a separate feature and may be easier to manage when you regularly switch between summary and detailed views.
Hide, filter, group, or delete?
Choose the feature that matches the result you want. Hiding a column changes the sheet’s layout while retaining all its data. Filtering usually hides rows that do not meet criteria; it does not remove a field from the worksheet. Grouping columns lets readers expand or collapse a set of related columns, which is useful for repeatable detail-versus-summary views.
- Hide: Use it to temporarily remove one or more columns from view, such as an internal note column while presenting a report.
- Filter: Use it to show only records matching a condition, such as orders from one region. The records are still in the sheet.
- Group: Use it when users should be able to expand and collapse a related block of columns with outline controls.
- Delete: Use it only when you intend to remove the column and its contents. Deleting can affect formulas or references, so it is not a substitute for hiding.
For example, a sales worksheet might have visible columns for product, quantity, and total, plus a hidden column containing a commission rate. The total formula can continue to refer to that rate even while the column is hidden. If colleagues need to reveal the calculation on demand, grouping the supporting columns may be clearer than leaving them hidden with no visual cue.
What happens to formulas, tables, and printed sheets?
Formulas continue to calculate when a referenced column is hidden. If a total in column E refers to values in column C, hiding C does not ordinarily stop the calculation. The formula bar can still show a selected cell’s formula, and the hidden cell remains available to workbook functions. Hiding changes visibility, not calculation logic.
Excel tables also retain their data when a worksheet column is hidden. A table column does not cease to exist merely because its worksheet column is out of sight; formulas and structured references can still use it. Be mindful that hiding a worksheet column can hide more than one field if your sheet layout includes multiple table or report elements in that column.
Hidden columns are generally omitted from the ordinary worksheet view and may not appear in printed output, which can affect a report’s meaning. Before distributing a workbook or printing, review the visible columns and use Print Preview to check the result. If a reader needs to see the hidden information, unhide it or provide a separate view rather than assuming it will be obvious.
Good practices for sharing a workbook
When hiding columns in a workbook for other people, make the choice intentional and easy to understand. A hidden column can be overlooked, especially if it contains information that a reader needs to interpret visible results. Consider adding a note, a clear worksheet title, or a separate summary sheet to explain where supporting information lives.
- Keep a copy of the original workbook before making extensive layout changes.
- Use clear headers in hidden columns so the information remains understandable when revealed.
- Check formulas, charts, and print previews after changing visibility, particularly in a report used by others.
- Use sheet protection only to restrict specified edits, not as a replacement for removing sensitive information.
- For a presentation, test the workbook in the same Excel version or viewing environment your audience will use.
Hiding columns is a lightweight presentation tool, not a way to create separate permissions for different readers. If different people should have access to different data, consider keeping that data in separate files or worksheets with appropriate access controls rather than depending on column visibility.
Frequently Asked Questions
Can I hide a column without deleting its data?
Yes. Select the column header, then choose Hide. Its contents remain in the workbook and can still be used by formulas; choose Unhide later to display it again.
How do I hide multiple columns at once?
Select the column letters for the columns you want to hide, then right-click and choose Hide, or use Home > Format > Hide & Unhide > Hide Columns. For separated columns, Ctrl-click their headers on Windows.
How do I unhide column A in Excel?
Select column B, then choose Home > Format > Hide & Unhide > Unhide Columns. Because A is the first column, there is no visible column header to select on its left.
Why can I still use data from a hidden column in a formula?
Hiding only changes the column’s visibility. It does not delete or disable the cells, so formulas can continue to refer to their values.
Is hiding a column a way to protect confidential data?
No. A person who can access the workbook may be able to unhide the column, and its data remains in the file. Remove sensitive data or control access to the workbook instead of relying on hiding.
Related
- How to Name a Print Range in Excel and Reuse It for Printing
- How to Name a Selected Range in Excel and Use It Easily
- Excel Shortcuts for Naming a Range and Managing Names
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 Present PowerPoint and See Your Speaker NotesTo present a PowerPoint while keeping your notes visible, connect a second display, set Windows to extend the…
- Find and Replace Colors in Excel: A Practical GuideYes. In Excel for Microsoft 365 on Windows, use Home > Find & Select > Find, open Options,…
- Schedule an Email Reminder in Outlook: Step-by-StepTo get a reminder to follow up on an Outlook email, flag the message and set a reminder…
- How to Add a Date Stamp to a Checkbox in ExcelTo add an automatic date stamp to an Excel checkbox, place the checkbox in column B, use the…
- How to Make a Poster in Word or PowerPoint That Prints WellTo make a poster in Word or PowerPoint, set the page or slide to the finished poster size…
- VLOOKUP Data Validation in Google Sheets: How It WorksTo use VLOOKUP with data validation in Google Sheets, create a dropdown from a range of lookup keys,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.