Can You Hide Cells in Excel? Methods and Limits

How-to basics · Updated November 21, 2026

You cannot hide one individual cell in Excel with a dedicated hide-cell command. You can hide its entire row or column, make its displayed contents appear blank, hide formulas, or hide the worksheet that contains it; the right choice depends on whether you want a cleaner view or actual data protection.

What hiding a cell means in Excel

Excel organizes a worksheet into rows and columns, and its built-in Hide command applies to whole rows or whole columns, not to a single selected cell. If you hide a row, every cell in that row disappears from the worksheet view. Hiding a column has the same effect on all cells in that column. The values are still in the workbook, and formulas can continue to use them.

There are also ways to make a cell look empty without removing its value. A number format can suppress what appears in the grid, for example, while leaving the underlying value available to formulas. To conceal a formula from the formula bar, you can mark the cell as Hidden and then protect the sheet. These options behave differently, so it helps to distinguish visual tidiness from restricting access.

None of these display methods is a reliable way to keep sensitive information secret from someone who can open and inspect the workbook. Hidden data may be revealed, copied, or accessed in other ways. If confidentiality matters, use appropriate file permissions and encryption rather than relying on hidden rows, columns, or formatting.

Hide a whole row or column

To hide a row in Excel for Microsoft 365 on Windows, select its row number, right-click, and choose Hide. To hide a column, select its column letter, right-click, and choose Hide. You can select multiple adjacent or nonadjacent row numbers or column letters before choosing Hide. The rows or columns vanish from view, but their contents remain in the workbook.

You can also use the ribbon: select the row or column, then choose Home > Format > Hide & Unhide > Hide Rows or Hide Columns. Windows keyboard shortcuts are Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. In Excel for Mac, the corresponding shortcuts are Command+9 and Command+0. Shortcut behavior can depend on keyboard settings, so the ribbon or context menu is a dependable alternative.

This method is useful when a worksheet has supporting calculations, old periods, or extra detail that readers do not need to see all the time. For example, a monthly report might hide columns containing individual transaction counts while showing only the total. Remember that hiding a column also hides every other value in it, so do not use this approach if unrelated information in that column still needs to remain visible.

Make a cell look blank with formatting

If the goal is to remove a value from the visible grid while keeping it available for calculations, apply a custom number format. Select the cells, press Ctrl+1 to open Format Cells, choose the Number tab, select Custom, enter ;;; in the Type box, and choose OK. The three semicolons define empty display sections, so the cell looks blank for positive numbers, negative numbers, zero, and text.

The value is not deleted. A formula that refers to the cell can still use it, and selecting the cell shows its value or formula in the formula bar. Someone who knows to inspect the formatting can also change the number format to reveal the display. This technique can be handy for suppressing zeroes in a presentation-style report, but it can confuse readers if blank-looking cells are mistaken for missing data.

To show the value again, select the cells and choose a normal format from Home > Number, or open Format Cells and select a suitable number format such as General. Custom formats can also affect how numbers are displayed without changing their stored values, so check the result before sharing or printing a worksheet.

Hide formulas while displaying results

Excel can hide a formula from the formula bar while continuing to show its calculated result. First select the formula cells and open Format Cells with Ctrl+1. On the Protection tab, select Hidden. Then protect the worksheet using Review > Protect Sheet. The Hidden setting does not take effect by itself; sheet protection is what stops the formula from appearing in the formula bar when that cell is selected.

Sheet protection can also restrict editing, depending on the options you choose when protecting the sheet. Cells are usually locked by default, so if users should be able to edit input cells, unlock those cells before protecting the sheet. For example, a budget template could leave its assumption cells editable while protecting the cells that calculate totals. Test the permissions with the intended user workflow so protection does not prevent ordinary data entry.

Formula hiding is a convenience and editing safeguard, not strong security. It does not encrypt the formula or guarantee that a determined user cannot recover information from the workbook. Do not use it to protect passwords, personal details, or other confidential data.

Hide an entire worksheet

When a complete worksheet is supporting material rather than part of the main presentation, hide its tab. In Windows Excel, right-click the sheet tab and choose Hide, or select the sheet and use Home > Format > Hide & Unhide > Hide Sheet. The sheet’s data remains in the workbook, and formulas on other sheets can still refer to it.

To restore a hidden sheet, right-click any visible sheet tab and choose Unhide, select the sheet in the list, and confirm. The ribbon route is Home > Format > Hide & Unhide > Unhide Sheet. If Unhide is unavailable or no sheet appears in the list, there may be no ordinarily hidden sheet to restore.

Workbook structure protection can prevent users from unhiding or rearranging sheets through the normal interface. In Windows Excel, use Review > Protect Workbook and enable the structure protection option. This is still not the same as securing confidential information: ordinary hiding and structure protection are workbook controls, not a substitute for access permissions or encryption. Excel for the web and Mac may present some controls differently, but hidden sheets remain a display and organization feature rather than a secrecy guarantee.

Choose the method that fits your goal

Before hiding anything, decide what should happen to the data and who needs to be able to reveal it. These examples can help:

  • Keep a report compact: Hide a full row or column when all its contents can be out of sight together.
  • Show a blank instead of a value: Apply a custom number format when formulas should still be able to use the value.
  • Show a result but not its formula: Mark formula cells Hidden and protect the worksheet, understanding that this is not strong security.
  • Move supporting material out of view: Hide the worksheet tab, and protect workbook structure if you want to limit routine changes to the sheet layout.
  • Keep information confidential: Do not rely on hiding. Remove information recipients should not have, or use suitable file-level security and sharing permissions.

Consider whether colleagues will understand the blank or missing-looking information. A note such as Values are hidden for presentation can prevent confusion, especially when a blank-looking cell still affects totals. If people need to inspect or update the data, a separate clearly labeled detail sheet may be easier to maintain than a collection of concealed rows and special formats.

How to reveal hidden rows, columns, and content

To unhide rows or columns, select the visible row numbers or column letters on both sides of the hidden section, right-click the selection, and choose Unhide. For example, if rows 5 through 7 are hidden, select rows 4 and 8 together and use Unhide. If the hidden section is at the top or left edge of the sheet, selecting adjacent headers can be less obvious; use the Name Box to select the range that includes the hidden rows or columns, then use Home > Format > Hide & Unhide > Unhide Rows or Unhide Columns.

To restore content hidden by the custom format, change the cells to General or another visible number format. To show a hidden sheet, use Unhide as described above. To allow formulas to appear again, remove sheet protection if you are authorized to do so, then open Format Cells > Protection and clear Hidden. A workbook may require a password to change its protection settings; do not assume that a blank-looking cell has been deleted just because it is not visible.

Common problems and misconceptions

A frequent source of confusion is treating hidden content as deleted content. Hiding rows or columns does not remove values, and it generally does not stop formulas from referencing them. Likewise, a cell formatted to look blank can still contain a number or text. If a total seems to include information that cannot be seen, inspect hidden rows and columns and check the source cells rather than assuming the formula is wrong.

Another issue is hiding a row or column that contains something needed elsewhere on the sheet. Because the command applies to the whole row or column, review nearby data before using it. Also, filtering is different from hiding: a filter temporarily displays only records that meet selected criteria, while the other rows remain part of the data and can be shown again by clearing the filter. For a sortable table, Data > Filter is often more useful than manually hiding rows.

Finally, a hidden sheet is not necessarily protected, and a protected worksheet is not necessarily confidential. These features help control presentation and routine editing. They should not be treated as a method for concealing sensitive information from a person who can access the workbook.

Frequently Asked Questions

Can I hide just one cell in Excel?
No. Excel does not have a built-in command that hides only one cell. You can hide the entire row or column, or use formatting to make that cell’s displayed contents appear blank.

Can people still see a hidden cell’s value?
Usually, yes. They may reveal a hidden row or column, select a formatted cell and inspect the formula bar, or change its format. Hiding changes what is displayed; it does not erase or securely protect the value.

Will formulas still calculate with hidden cells?
Yes. Hiding a row or column does not normally remove its values from formulas. A cell that looks blank because of a custom number format also retains its underlying value and can be referenced by calculations.

How do I hide zeroes without deleting them?
Select the cells, open Format Cells with Ctrl+1, choose Number > Custom, and enter ;;;. This hides displayed values, including zeroes, while leaving the stored data intact. Use a visible format later to display them again.

Is hiding a worksheet a safe way to protect private data?
No. A user who can access the workbook may be able to unhide the sheet or inspect its contents. Use appropriate file security and sharing permissions for private information, and do not treat hidden sheets or protected formulas as encryption.

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.