How to Hide Cells in Excel Without Deleting Data

How-to basics · Updated November 20, 2026

To hide cells in Excel, select the rows or columns containing them, then choose Home > Cells > Format > Hide & Unhide and select Hide Rows or Hide Columns. Excel does not have a built-in command to hide just one arbitrary cell while keeping the rest of its row and column visible. If you only need a cell’s contents to look blank, you can hide its display with a custom number format instead.

What You’ll Need

  • Excel for Microsoft 365 on Windows for the ribbon paths below. The commands are similar in Excel for Mac and Excel for the web, though some menu labels and dialogs may differ.
  • Permission to edit the workbook. If a worksheet is protected, you may need its password or the workbook owner’s help to change hidden rows, columns, or cell formatting.
  • A saved copy of the workbook if the data is important. Hiding data does not delete it, but it can make information easy to overlook when reviewing or sharing a sheet.

Step-by-Step

  1. Decide what should disappear. Hide a row or column when you want all of its cells out of view, such as a helper calculation column or a set of completed records. If only one cell’s displayed value should look blank, use the custom-format method in step 4. If you want to conceal a formula from the formula bar, use the protection method in step 5; that does not hide the calculated result displayed in the cell. Choose the method before changing anything so you do not hide more information than intended.
  2. Select the row or column that contains the cells. Click the row number at the left edge of the worksheet to select an entire row, or click the column letter at the top to select an entire column. To select several adjacent rows or columns, drag across their headers or click the first header, hold Shift, and click the last. For nonadjacent headers, hold Ctrl while selecting each one on Windows. You can also select a range of cells and hide every row or column touched by that selection, but Excel will hide whole rows or columns, not only the selected cells.
  3. Hide the selected rows or columns. On the Windows ribbon, go to Home > Cells > Format > Hide & Unhide, then choose Hide Rows or Hide Columns. The selected headers disappear and the remaining headers keep their original numbers or letters, so a jump from row 12 to row 16 indicates that rows 13–15 are hidden. As a keyboard alternative on Windows, select the row or rows and press Ctrl+9 to hide them; select columns and press Ctrl+0. On a Mac, the corresponding shortcuts are generally Command+9 for rows and Command+0 for columns. If a shortcut is unavailable or conflicts with a system setting, use the ribbon command.
  4. Make a cell look blank without hiding its row. Select the cell or range, press Ctrl+1 on Windows to open Format Cells, and select the Number tab. Choose Custom in the Category list, enter ;;; in the Type box, and select OK. This format suppresses the displayed contents for the selected cells while leaving their values in place. To restore the normal display, open Format Cells again and choose an appropriate category, such as General. On Mac, use Command+1 to open Format Cells. This is only a visual treatment: selecting a cell can still reveal its value or formula in the formula bar, and the underlying data remains available to formulas and other workbook features.
  5. Hide formulas from the formula bar, if that is the goal. Select the formula cells, open Format Cells with Ctrl+1, select Protection, and check Hidden. The cell is usually also marked Locked by default; leave that setting on if you want to prevent edits after sheet protection. Click OK, then go to Review > Protect Sheet and apply sheet protection. Follow the prompts and set a password only if appropriate; keep it somewhere safe because forgetting it can complicate access. The formula is hidden from the formula bar when the protected sheet is active, but its result still appears in the cell. To reverse this, unprotect the sheet, clear the Hidden setting in Format Cells, and protect the sheet again if needed.
  6. Check the result, then keep a way to restore it. Confirm that you hid the intended rows, columns, or contents and that totals, charts, and other calculations still behave as expected. If you hid rows or columns, note their numbers or letters before sharing the file. To unhide a row, select the row headers immediately above and below the hidden range, right-click the selection, and choose Unhide. For hidden columns, select the column headers on both sides, right-click, and choose Unhide. You can also select headers spanning the hidden area and use Home > Cells > Format > Hide & Unhide > Unhide Rows or Unhide Columns. If the hidden range is at the top or left edge, select the whole sheet using the triangle above row 1 and left of column A, then use the appropriate Unhide command.

Common Mistakes

Expecting Excel to hide a single cell independently. A cell sits inside a row and a column, so hiding either one also hides the other cells along that entire line. For a lone value, a custom format can make the cell appear blank, but it does not create genuine privacy. If you need a cleaner presentation, consider moving supporting data to a separate worksheet and controlling access to the workbook rather than relying on a visual trick.

Confusing hidden formulas with hidden results. The Hidden checkbox in Format Cells does not take effect by itself: you must protect the worksheet. Even after protection, the formula result remains visible in the cell. Conversely, a custom format such as ;;; hides the displayed value but does not remove the formula or stop others from examining the cell after changing its format or viewing the workbook through other means.

Assuming hidden means deleted or secure. Hidden rows and columns remain in the workbook and may still affect formulas, charts, and summaries. Sheet protection is intended to limit edits and casual viewing of formulas, not to encrypt sensitive information. Do not use hiding or sheet protection as a substitute for appropriate file permissions or encryption when data is confidential.

Hiding a row or column by mistake. If the whole worksheet looks empty or a large area vanishes, you may have selected a row or column header rather than a single cell. Use Undo immediately if you have not made further changes, or select the affected area and use Unhide. Check the row numbers or column letters for gaps to identify what disappeared.

Tips

Use descriptive labels for helper rows and columns before hiding them. A colleague who sees a gap in the worksheet can then understand that supporting information exists, while you retain a record of what the hidden section contains. For long sheets, record the hidden range in a nearby note or in a worksheet-maintenance document so it can be restored later without guesswork.

For data that is temporarily out of view, Excel’s filtering tools may be a better choice than hiding rows manually. A filter lets you show records that meet selected criteria and makes the selection easier to change. For collapsible detail, select the relevant rows or columns and use Data > Group; the outline controls let readers expand or collapse the detail. Grouping is not a privacy feature either, but it can make a report easier to navigate.

Before printing or exporting to PDF, preview the output. Hidden rows and columns are normally omitted from the printed worksheet, while a cell made blank by custom formatting may leave an empty space in the layout. Also check formulas that refer to hidden data: hiding a row does not remove its contribution to a total. If you intend a calculation to exclude filtered or hidden records, review the formula and use a method suited to that calculation rather than assuming visibility changes the result.

When working in Excel for the web, select the row number or column letter, right-click, and choose the available hide command; to restore it, select the surrounding headers and choose Unhide. In Excel for Mac, the ribbon and right-click options offer the same basic row and column controls, even if their locations differ slightly by release. For formula concealment, use the desktop Excel protection workflow if the web interface does not show the required Format Cells or protection options.

Troubleshooting

I cannot find the Unhide command. Select the headers on both sides of the gap, not just the visible row or column next to it. For example, if row 8 is hidden, select row headers 7 and 9, right-click, and choose Unhide. If you are unsure where the hidden area is, select the full worksheet and use the Unhide Rows or Unhide Columns command from the Format menu. You can also use the Name Box to select a known address or range, then adjust the relevant row height or column width if it was set to zero rather than hidden through the command.

The row or column still seems missing after Unhide. It may have a very small height or width, or a filter may be hiding records. Select the affected rows or columns and choose Home > Cells > Format > AutoFit Row Height or AutoFit Column Width. Check Data > Filter and clear or adjust filters if filtered records are the issue. Grouped rows or columns can also be collapsed; click the plus sign in the outline margin to expand them.

The custom format does not hide what I expected. Reopen Format Cells and confirm that ;;; appears in the Custom Type box for the exact cells you selected. Check the formula bar as well: a blank-looking cell can still contain data. To show the content again, change the format to General or another suitable number format. If you want a cell to display a dash or another substitute rather than nothing, use a format designed for that display instead of the three-section blank format.

I cannot change a protected sheet. Go to Review > Unprotect Sheet and enter the password if prompted. If you do not know it, contact the workbook owner; do not assume that changing the cell format will bypass protection. If the workbook opens in read-only mode or is locked for editing by another person, obtain editing access before making changes.

Frequently Asked Questions

Can I hide only one cell in Excel?
Not with Excel’s row and column hide commands. You can make its contents appear blank with a custom format, but the value remains in the workbook. Otherwise, hide the entire row or column containing it.

Does hiding a row remove it from formulas?
No. Hiding changes what is shown, not the stored data. Many formulas continue to include hidden rows. Some functions, such as SUBTOTAL, treat filtered or manually hidden rows differently depending on the function number, so check the specific calculation you use.

How do I hide a formula but keep its answer visible?
Mark the formula cell as Hidden in Format Cells > Protection, then protect the worksheet through Review > Protect Sheet. The formula result remains visible, while the formula is not shown in the formula bar on the protected sheet.

Can someone reveal hidden rows or columns?
Usually, yes: a person with editing access can select surrounding headers and use Unhide. Worksheet protection can restrict that action, but protection is not a secure way to store confidential information. Use suitable access controls for sensitive data.

Will hidden rows and columns appear when I print?
They are normally omitted from the printed sheet. Check Print Preview before printing, especially if you have used filters, custom formats, or grouped rows, because the visible layout may not match what you expect.

What is the fastest way to hide rows or columns?
On Windows, select the headers and press Ctrl+9 for rows or Ctrl+0 for columns. On Mac, the corresponding shortcuts are generally Command+9 and Command+0. The Home > Cells > Format menu is a dependable alternative if a shortcut is unavailable.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.