To hide multiple columns in Excel at once, select their column letters, right-click the selection, and choose Hide. For separated columns, hold Ctrl on Windows (Command on Mac) while selecting each letter, then use the same command. Hiding columns keeps their contents in the workbook but removes them from view, which is useful for simplifying a worksheet without deleting data.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows, with the worksheet you want to change.
- Permission to edit the worksheet. If it is protected, you may need to unprotect it first.
- The column letters you want to hide. Check these carefully before acting, especially if the columns are separated or contain data used elsewhere.
The steps below use the Windows desktop version of Excel. The ribbon method is also available in Excel for Mac and Excel for the web, though ribbon placement can vary slightly. Hiding a column does not erase its values or formulas; it only changes what is shown on that worksheet.
Step-by-Step
-
Open the right worksheet. Select the worksheet tab at the bottom of the Excel window. If the workbook has several sheets, verify the sheet name before you hide anything. Column hiding applies to the active worksheet, not automatically to every sheet in the workbook.
-
Select the columns by their letters. The letters A, B, C, and so on appear above the grid. To select adjacent columns, click the letter at the beginning of the range, hold Shift, and click the letter at the end. For example, click C, hold Shift, and click F to select columns C through F. You can also click and drag across the column letters.
To select columns that are not next to each other, click the first column letter, then hold Ctrl and click each additional letter on Windows. On a Mac, use Command-click instead. For instance, select B, then Ctrl-click E and H on Windows to select B, E, and H without selecting C, D, F, or G. Take care not to click inside a worksheet cell, which changes the selection.
-
Choose how to hide the selection. Use any one of these methods; you do not need to repeat the command:
- Right-click: Right-click one of the selected column letters and choose Hide from the context menu.
- Ribbon: Go to Home > Format > Hide & Unhide > Hide Columns. In the Windows ribbon, Format is in the Cells group.
- Keyboard shortcut: Press Ctrl+0 on Windows. On a Mac, press Command+0. If a shortcut is intercepted by your system or does not work in your Excel setup, use the right-click or ribbon method.
-
Check that the columns are hidden. Excel removes the selected columns from the visible grid. The column letters on either side will sit next to each other even though their lettering is not consecutive. A narrow boundary or double line between visible headers can also mark the location of hidden columns. The columns are still present in the worksheet.
-
Verify the result in the sheet. Look at the columns on both sides of the hidden range and check that the intended data is no longer visible. For separated selections, confirm each chosen column disappeared and that any columns you meant to keep are still shown. If you hid the wrong columns, use the unhide steps below rather than deleting or moving data.
-
Unhide a range when you need it again. Select the visible column letters on both sides of the hidden range. For example, if D and E are hidden, select C and F by dragging across their headers, then right-click the selection and choose Unhide. You can also use Home > Format > Hide & Unhide > Unhide Columns. For a range at the edge of the sheet, or if you cannot identify all hidden columns, select the whole worksheet using the small triangle above row 1 and left of column A, then choose Unhide Columns. This reveals every hidden column on that sheet, including any you may have wanted to leave hidden.
-
Save the workbook if the change should persist. Hiding is a worksheet formatting change, so save the file to keep it when you close the workbook. If you are editing a shared workbook, consider telling collaborators which columns are hidden; other people with edit access can unhide them.
Excel for the web uses the same basic selection idea: select the column headers, then use the Home ribbon’s formatting controls to hide the columns. The exact position of the Format command can differ with window size. If you cannot find it, use the context menu on the selected headers. On Mac, use Command-click for a nonadjacent selection; the right-click and ribbon options are alternatives to the keyboard shortcut.
Common Mistakes
- Selecting cells instead of whole columns. Clicking a cell selects that cell, not its entire column. For a clear and reliable selection, click the column letters at the top of the grid. This also makes it easier to see precisely which columns will be affected.
- Using the wrong modifier key for separated columns. On Windows, hold Ctrl while clicking each column letter. On Mac, hold Command. Without the modifier, clicking another letter replaces the existing selection instead of adding to it.
- Choosing a range that includes unwanted columns. When selecting adjacent columns with Shift or dragging, Excel includes every column between the endpoints. If you want B and E only, do not select B through E; use Ctrl-click or Command-click to pick them separately.
- Assuming hidden means deleted or private. Hidden column data remains in the workbook. Formulas can still refer to it, and another editor can unhide it. Do not use hiding to remove sensitive information or to make data inaccessible.
- Confusing hidden columns with collapsed groups or filtered data. A plus or minus outline control may indicate grouped columns that can be expanded or collapsed. Filters usually hide rows, not columns. Check the column letters and nearby controls to identify what changed.
Tips
- Use the Name Box for a large continuous range. The Name Box is to the left of the formula bar. Type a column range such as C:F and press Enter to select those entire columns, then choose Hide. This can be quicker than dragging across many headers. Use a colon between the first and last column letters.
- Keep a record of hidden data. If colleagues will use the workbook, add a brief note in a visible area or document which columns are hidden and why. This reduces confusion when formulas or totals depend on values that are not currently displayed.
- Check formulas and charts after hiding. Hiding does not normally remove values from calculations, but charts have settings that affect whether they display data in hidden rows and columns. If a chart changes unexpectedly, select the chart and look at its data settings for hidden and empty cells.
- Use grouping if you expect to hide and show the same columns often. Select the columns and choose Data > Group to create an outline control. The plus and minus buttons make it easy to expand or collapse that group later. Grouping is different from the Hide command, so choose the approach that matches how you plan to work.
- Use the ribbon when a shortcut is unreliable. Keyboard shortcuts can vary with operating-system settings, keyboard layouts, or Excel versions. The right-click menu and Home ribbon are visible ways to perform the same action and are useful when helping someone with a different setup.
Troubleshooting
- Hide is unavailable or nothing happens: Check whether the worksheet is protected. Go to Review > Unprotect Sheet if you have permission and the required password. If the workbook is shared or restricted, ask its owner for editing access. Also check that you selected column headers rather than a chart, shape, or cell object.
- The shortcut does not work: Select the column letters again and use Home > Format > Hide & Unhide > Hide Columns. On Windows, Ctrl+0 can be affected by system or keyboard settings. On Mac, use the ribbon or context menu if Command+0 is unavailable in your setup.
- You cannot find the hidden columns: Look for a jump in the column letters, such as B followed by F, or a very narrow boundary between headers. Select the surrounding visible column letters and choose Unhide. If the hidden range is at the first or last edge, select the whole sheet and unhide columns instead.
- Unhide does not reveal the columns you expected: Make sure your selection includes the columns immediately on both sides of the hidden range. If the range touches the edge of the worksheet or several hidden ranges are hard to distinguish, select the whole sheet before using Unhide Columns. Remember that this shows all hidden columns on that worksheet.
- A column seems hidden, but Unhide does not help: Check whether its width has been set to zero or an extremely small value, or whether an outline group is collapsed. Select the relevant column area and use Home > Format > Column Width to enter a visible width. For grouped columns, use the outline plus button to expand the group.
Frequently Asked Questions
Can I hide several nonadjacent columns at once?
Yes. Select the first column letter, then hold Ctrl and click the other letters on Windows. On Mac, hold Command while clicking. Right-click one of the selected headers and choose Hide, or use the ribbon’s Hide Columns command.
Does hiding columns change formulas or delete data?
No. Hiding changes what is displayed, not the cell contents. Formulas can continue to use hidden values. If you want to remove data, hiding is not a substitute for deleting it, and it should not be treated as a privacy or security measure.
How do I hide every column to the right of my data?
Select the first column you want to hide, then press Ctrl+Shift+Right Arrow on Windows to extend the selection to the last worksheet column. Right-click the selected headers and choose Hide. On Mac, use Command+Shift+Right Arrow if that shortcut is available, or select the range using the Name Box and hide it from the ribbon.
Can I hide columns in more than one worksheet at the same time?
You can group worksheet tabs by selecting multiple tabs, then hide the same column positions while the sheets are grouped. Use this carefully: the change applies to each grouped sheet, and other edits may also affect all selected sheets. Right-click a sheet tab and choose Ungroup Sheets when finished.
How do I show all hidden columns again?
Select the whole worksheet using the triangle at the top-left corner of the grid, then choose Home > Format > Hide & Unhide > Unhide Columns. This restores all hidden columns on the active sheet, so use it only if you are comfortable revealing every one.
Related
- Excel Letter Count: Count Letters and Characters in Cells
- Excel Very Slow Loading Data? Causes and Fixes
- How to Calculate VaR 99 in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel: Hide Row and Column Numbers from the Worksheet ViewTo hide row numbers and column letters in Excel for Microsoft 365 on Windows, select the worksheet, open…
- How to Track Changes in Microsoft Word and Review EditsTo track changes in Microsoft Word, open the document, select Review > Track Changes, then edit as usual.…
- Inclusive vs Exclusive Median in Excel Box Plots ExplainedIn an Excel box-and-whisker chart, Inclusive median includes the data-set median in both halves when the sample has…
- Excel Flash Fill for Rows: How It Works and When to Use ItIn Excel for Microsoft 365 on Windows, Flash Fill recognizes a pattern from examples and fills matching values…
- Excel Solver for Data Analysis: Setup, Models, and LimitsExcel Solver is an optimization add-in: it changes selected input cells to maximize, minimize, or reach a target…
- Automate Text to Columns in Excel: Methods and LimitsYes—but Excel’s Text to Columns command does not automatically repeat itself whenever new data arrives. For a one-time…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.