How to Hide Cell Content in Excel: Rows, Columns, Formulas and Values

Quick answer

Three operations get called “hiding a cell” in Excel. To blank out what a cell displays while keeping its value, apply the custom number format ;;; via Ctrl+1 → Number → Custom. To stop a formula reaching the formula bar, tick Hidden on the Protection tab of Format Cells, then protect the sheet. To take cells out of view entirely, hide their rows or columns: Ctrl+9 hides rows, Ctrl+0 hides columns². None of the three is security.

Most people arrive here with one of two goals: working columns that should not appear on the printout, or a formula that should not be readable by whoever opens the file next. Those goals need different tools, and picking the wrong one is how a workbook gets treated as confidential when it is not.

Hide the display, keep the value

The three-semicolon custom number format is the cleanest way to make a cell look empty while leaving its contents intact.

1. Select the cells.
2. Press Ctrl+1 to open the Format Cells dialog box².
3. On the Number tab, choose Custom.
4. In the Type box, replace what is there with ;;; and click OK.

A custom number format has four sections separated by semicolons — positive, negative, zero, text. Three semicolons create four empty sections, so there is nothing to display in any case and the cell renders blank, on screen and in print.

What survives is the value, every formula referencing it, and the formula bar. That makes this useful for tidying a sheet and useless for keeping a secret. There is a worked example in hiding values in a column.

Hide the formula from the formula bar

This is the one most people want: the result stays visible, but the calculation behind it is not.

1. Select the cells containing the formulas.
2. Press Ctrl+1 and open the Protection tab.
3. Tick Hidden. Leave Locked ticked as well.
4. Go to Review → Protect Sheet and confirm.

The trap that catches everybody once: Hidden does nothing on its own. Locked and Hidden are dormant flags that take effect only when the worksheet is protected³. Once it is, those cells show a result but an empty formula bar — the formula still calculates, it is simply not displayed.

Hide whole rows, columns and sheets

When content should not be visible at all, hide the container rather than the contents. Select the rows or columns by their headers, right-click, and choose Hide¹. Microsoft documents the keyboard equivalents: Ctrl+9 hides the selected rows, Ctrl+0 the selected columns². The ribbon route, Home → Format → Hide & Unhide, gathers all six commands in one menu.

Sheets work the same way: right-click a sheet tab and choose Hide. VBA exposes a stronger option — open the editor with Alt+F11 and set the sheet’s Visible property to xlSheetVeryHidden, keeping it out of the ordinary Unhide dialog.

Hidden rows are still part of the range when you copy, so they reappear on paste unless you select visible cells first — see copying only visible cells.

Why white text is not a solution

White font on a white background looks identical to the ;;; format on screen. In every other respect it is worse.

• Select the cells and the values reappear as highlighted text.
• Change the fill colour, or apply a banded table style, and everything is legible again.
• Copying to another application carries the values across in plain sight.
• Greyscale printing often renders white as a readable light grey.
• Anyone applying Format Painter from a normal cell wipes it out by accident.

The three-semicolon format has none of these failure modes: the cell displays nothing rather than something invisible.

Hiding is not securing

Worth being clear about

Microsoft states it plainly: “Worksheet level protection isn’t intended as a security feature. It simply prevents users from modifying locked cells within the worksheet.”³ Hidden rows, hidden formulas and blanked-out number formats are presentation choices. Each is reversible in a handful of clicks by anyone holding the file, and none of them encrypts anything.

So the test is simple: if the recipient must not see a number, the number must not be in the workbook. Real encryption is a different feature — File → Info → Protect Workbook → Encrypt with Password. The password on Protect Sheet is a guard rail against accidental edits, not a lock.

Undoing it, and finding what someone else hid

Unhide rows and columns. Select the headers either side of the gap — a jump from column C to E means D is hidden — then right-click and choose Unhide¹. To clear everything at once, select the sheet with Ctrl+A and use Home → Format → Hide & Unhide. Column A and row 1 are the awkward cases, with nothing to the left or above to select: type A1 into the Name Box, then use the same menu.

Read carefully

Ctrl+Shift+9 and Ctrl+Shift+0 are both quoted as the unhide shortcuts, but they do not behave the same way. Ctrl+Shift+9 does unhide the selected rows, and it works normally on Windows. Ctrl+Shift+0 is the unreliable one: Windows claims that combination by default for switching the input language, so it is usually intercepted before Excel ever sees it. When nothing happens, use the menu instead — select the columns either side of the hidden ones, right-click, and choose Unhide.

Clear a ;;; format. Select the affected cells, or the whole sheet with Ctrl+A, and set the format back to General in the Number group on the Home tab. Every blanked cell shows its value again at once.

Use Go To Special to find what is there. This turns guesswork into an answer. Press F5 (or Ctrl+G), click Special, and choose Constants to select every cell holding a typed value, or Formulas for every calculated one. Any cell that looks empty but lights up is formatted to display nothing. The same dialog underpins clean-up jobs like deleting every picture or chart on a worksheet.

Hidden sheets and formulas. Right-click a sheet tab and choose Unhide; if the list is empty but formulas reference a sheet you cannot see, check the VBA Properties pane for xlSheetVeryHidden. If the formula bar is blank for a cell that clearly calculates, the sheet is protected with Hidden set — Review → Unprotect Sheet restores it.

Related

• Hide values in a column with a custom number format
• Copy only visible cells
• Format Painter in Excel
• How to indent in Excel
• MO-211 Excel Expert guide

Sources