To hide columns in Excel on a Mac, select the column letter or letters, then choose Home > Format > Hide & Unhide > Hide Columns. The cells stay in the workbook—hiding only removes the columns from view. You can bring them back later with the Unhide Columns command, so this is useful for simplifying a worksheet without deleting information.
Before you start, save the workbook if you have made changes you do not want to lose. You do not need a special setting or add-in. The steps below apply to the desktop version of Excel for Microsoft 365 on Mac; ribbon wording and layout can vary slightly between releases.
What You’ll Need
- An Excel workbook open in the desktop app on your Mac.
- Access to the worksheet containing the columns you want to hide. If the sheet is protected, you may need permission to change its layout.
- The letters of the columns you want to hide, if you already know them. For example, column D is identified by the D at the top of the worksheet.
Step-by-Step
-
Open the right worksheet. If the workbook has several sheets, click the sheet tab at the bottom that contains the columns you want to conceal. Check that you are in the correct sheet before making a change: hiding a column affects only the active worksheet, not every sheet in the workbook. If you are unsure which sheet is active, look for its highlighted tab.
-
Select the column or columns. Click a column letter at the top of the grid, such as C, to select the entire column. The letter area becomes highlighted. To select adjacent columns, click the first letter and drag across the other letters, or click the first letter, hold Shift, and click the last letter. For example, selecting C through F targets all four columns, including any blank cells in those columns.
-
Select separate columns if needed. To hide columns that are not next to each other, select the first column letter, then hold the Command key and click each additional column letter. Check the highlighted column headings before proceeding. On some Excel for Mac versions or setups, selecting nonadjacent columns this way may be inconvenient; hide each column separately if the selection does not remain intact. Do not click inside individual cells when your intention is to hide whole columns.
-
Hide the selection from the ribbon. With the column headings selected, open the Home tab. Choose Format, then Hide & Unhide, then Hide Columns. Excel removes the selected columns from the grid. The column letters on either side will appear next to each other; for example, after hiding D, the visible headings may go from C straight to E. The column contents remain stored in the sheet.
-
Use the context menu or shortcut as an alternative. You can also Control-click a selected column heading (or right-click if your mouse has a right button) and choose Hide. On a Mac, Command+0 is the shortcut for hiding selected columns. The equivalent Windows shortcut is Ctrl+0. If you use a shortcut, make sure the column heading is selected first; selecting a cell alone may not produce the result you expect. If the shortcut is intercepted by macOS or does nothing, use the ribbon or context menu instead.
-
Confirm the result and save if appropriate. Look for the jump in the column letters and check that the information you meant to hide is no longer visible. If the sheet contains formulas, check a relevant total or calculation: hiding columns normally does not remove their values from formulas. Save the workbook when you are satisfied. Hiding is a display change, not a privacy control; someone who can edit or inspect the workbook can usually unhide the data.
Common Mistakes
Selecting cells instead of column headings: Choosing a cell range and using a hide command may affect rows or produce a different selection than intended. Click the letter at the top of the column to select the full column. A highlighted letter is a quick visual check that the selection is correct.
Deleting when you meant to hide: Hiding preserves the underlying values, formulas, and formatting. Deleting a column removes its contents and can change formulas or references. If you only want a less cluttered view, use Hide Columns rather than Delete Sheet Columns.
Assuming hidden means protected: Hidden data is still part of the workbook. It may still be referenced by formulas, and another person can unhide it. Do not use column hiding to secure confidential information. If you must share a file without particular data, make a separate copy and remove that data from the copy, taking care to check formulas, linked sheets, and other places it may appear.
Hiding the wrong area: The row numbers are along the left edge, while column letters are across the top. Clicking a row number selects a row, not a column. Also, selecting the entire sheet and choosing Hide Columns can hide every column, leaving a confusing blank-looking grid. Select only the specific headings you need.
Forgetting which columns are hidden: A gap in the letter sequence is the clue, but it is easy to overlook when several columns are concealed. Before hiding a large group, note the column letters or add a temporary comment in your own workflow. Do not assume an apparently missing value has been deleted without checking for hidden columns.
Tips
Use hiding for temporary decluttering: for example, keep a customer list easier to read by hiding internal notes, helper calculations, or columns used only for a chart. If the information is useful to some people but not everyone, communicate that it is still present rather than implying that it has been removed. For a worksheet you share regularly, a short note explaining how to reveal the columns can prevent confusion.
You can hide several neighboring columns in one action by selecting their letter headings as a continuous range. This is often quicker and less error-prone than hiding each one separately. For columns that are scattered across the sheet, a few separate selections may work, but verify each highlighted heading before choosing Hide Columns.
Keep in mind that hiding columns changes how the worksheet is displayed and can also affect what readers see when they print or export the sheet. If the layout matters, preview the printed pages or exported file after hiding columns. A workbook can still calculate using data in hidden columns, so a displayed result may depend on information that is not currently visible.
For a more controlled presentation, consider making a separate presentation sheet that contains only the fields intended for viewing. That can be clearer than hiding many columns in a busy source worksheet. If you do hide columns in the original, record the change or leave a note for collaborators, especially when the hidden columns contain inputs used by other parts of the workbook.
On Mac, the ribbon command is a dependable option when keyboard shortcuts conflict with system settings. If your Excel window is narrow, some ribbon controls may be condensed; look for the Format menu on the Home tab rather than assuming the command is unavailable. You can also use the right-click menu on a selected column heading for a direct route.
Troubleshooting
The Hide command is unavailable or does not work: Confirm that at least one column heading is selected, then try Home > Format > Hide & Unhide > Hide Columns. If the worksheet is protected, Excel may block layout changes. Look on the Review tab for sheet protection controls; if the sheet is protected, ask the workbook owner for permission or for the password rather than trying to bypass the protection.
The shortcut does nothing: Check that you are using the Mac shortcut, Command+0, and that the column letter is selected. Mac keyboard settings or another app can capture a shortcut. Use the ribbon or the column-heading context menu instead. On a Windows computer, the hide-columns shortcut is Ctrl+0, but this guide’s ribbon steps are for Excel on Mac.
A column seems to have disappeared, but you cannot tell which one: Look for a break in the column letters. If the visible headings jump from B to E, columns C and D may be hidden. Select the headings on both sides of the gap and use Home > Format > Hide & Unhide > Unhide Columns. If the hidden columns are at the far left or right, where there is no visible heading on one side, use the Name Box method described below.
You cannot reveal the first column: Click the Name Box, the small field to the left of the formula bar, type A:B, and press Return. This selects columns A and B even if A is hidden. Then choose Home > Format > Hide & Unhide > Unhide Columns. For a different hidden range, enter a range that includes the hidden columns and at least one neighboring column, such as D:F to reveal E if E is hidden.
The letters appear to skip, but Unhide Columns does not help: Make sure the neighboring column headings are selected, not just cells in the grid. If a column has been set to a very small width rather than hidden, select it and use Home > Format > Column Width to assign a visible width. If the sheet is protected, you may need the owner to change its layout. Also check that you are on the intended worksheet, since each sheet has its own hidden-column state.
The data is missing from a printout or export: Hidden columns are not shown in the normal worksheet view and may be omitted from printed or exported output. Unhide them before producing a version that must include those fields, then check Print Preview. If the goal is a clean report rather than concealing source data, consider copying the needed information to a separate report sheet.
Frequently Asked Questions
How do I hide a column in Excel on Mac with the keyboard?
Select its column letter, then press Command+0. If that shortcut does not work because of a macOS setting or another shortcut conflict, use Home > Format > Hide & Unhide > Hide Columns. On Windows, the corresponding hide shortcut is Ctrl+0.
How do I hide multiple columns at once?
Select the headings for adjacent columns by dragging across them or using Shift-click, then choose Hide Columns. For separate columns, hold Command while clicking their headings, if your Excel selection behaves as expected, or hide each column individually. Check the highlighted headings first.
How do I unhide columns in Excel for Mac?
Select the visible column headings on both sides of the hidden area, then choose Home > Format > Hide & Unhide > Unhide Columns. If the hidden column is at the edge, use the Name Box to select a range that includes it, such as A:B when column A is hidden.
Does hiding a column delete its data or change formulas?
No. Hiding changes the display, not the stored cell values. Formulas can generally continue to use values in hidden columns. Deleting the column is different and can remove data or alter references, so choose Hide Columns when you want to keep the information.
Can other people see columns I have hidden?
Yes. People with access to the workbook can usually unhide columns, and hidden values are not secure or private. If a recipient must not receive particular information, prepare a separate copy with that information removed and verify that it is not present elsewhere in the workbook.
Related
- Excel Column Width: Units, Settings, and AutoFit
- Excel SWITCH Greater Than: Test Ranges and Conditions
- Excel Row Formatting: How to Format and Manage Rows
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 Checkbox in Word Online for ChecklistsTo add clickable checkboxes in Word Online, open the document, go to Home, and choose Checklist in the…
- Microsoft Excel: Remove Page Break Lines and Hide ThemTo hide page-break lines in Excel for Microsoft 365 on Windows, open File > Options > Advanced, find…
- Excel Keyboard Shortcuts to Select Cells and RangesIn Excel for Microsoft 365 on Windows, use Ctrl+A to select the current data region, then press it…
- Google Sheets VLOOKUP: Link Two Sheets Step by StepTo look up a value in a different Google Sheets file, combine VLOOKUP with IMPORTRANGE: allow access to…
- Excel Power Query Merge vs Append: Which Should You Use?In Excel Power Query, Merge joins two queries side by side using one or more matching columns; Append…
- Excel Stop Showing Page Break Lines: FixesTo stop Excel from showing page break lines, go to File > Options > Advanced, find Display options…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.