I keep a content calendar that ranks what I pitch next, and the ranking leans on columns nobody else needs to see. Every cell in that sheet carries a number format, and most of the time picking the right number format for each column is about making figures readable.

This one does the opposite. Three semicolons typed into the Custom box blank a cell on screen and in print, while the value underneath stays live for every formula pointing at it. So the ranking survives, but the argument about how the ranking was calculated does not. However, it’s worth knowing the limits first.

A custom number format has four slots

Leave every one of them empty, and Excel draws nothing

Every custom format in Excel is built from four sections in a fixed order. Positive values, then negative, then zero, then text, each separated by a semicolon. Fill a section, and Excel uses it. If you leave one empty, then Excel doesn’t display anything for that value type.

That is the whole mechanism. Typing three semicolons produces four empty sections rather than three, which is where most people miscount. Nothing is left to draw, so the cell reads as blank. Applying it takes four steps.

1. Select the range you want blanked.
2. Press Ctrl + 1 to open Format Cells.
3. Open the Number tab and choose Custom from the category list.
4. Type three semicolons into the Type box and click OK.

You don’t need to check anything before you start. The syntax predates the ribbon, so it behaves the same way in recent desktop Excel releases (Excel 2016 and later, and Microsoft 365 builds) on Windows and macOS.

Formulas still read the hidden value

Blanking the display never touches the data underneath

The Rank column in my spreadsheet is the whole demonstration. It reads 1 through 8; it is the only scoring information anyone else sees, and every number in it comes out of RANK reading a column that displays nothing.

The summary underneath the table behaves the same way. It uses LARGE and SMALL to run a calculation across a whole range in a single formula, and both functions read the blanked column without complaint.

Those figures still resolve. The average score across the eight pieces comes to 4.04, the top score is 6.1, and the bottom three pieces sit within three tenths of a point of each other. All three numbers live in cells that show nothing. Anything downstream works too. A TEXT function pointed at a blanked score pulls 6.1 into a visible cell, and multiplying that cell by ten returns 61, so joined strings and rescaled figures carry the value through.

This beats hiding columns or turning the font white

Both of the obvious workarounds fail in ways this one does not

Hiding the columns is the first instinct, and it advertises itself. The header row jumps from E straight to J, which invites the question. Two clicks bring it back, and the conversation I was avoiding arrives anyway.

White font fails faster because when you add a fill color later, the text reappears against it. If you print on colored paper, it shows up there too. The format holds up in all three. The grid stays clean, the printout stays clean, and the sheet keeps its structure, so nothing breaks the way it does when a column vanishes mid-range.

Nothing in those columns is confidential. I blank them because the bottom three pieces sit three-tenths of a point apart, and showing the math turns every discussion about the calendar into a debate over whether effort deserves its weighting.

On a bigger build, I would still consider moving the background calculations onto a separate sheet, which solves a different version of the same problem. For one tab, this is less work.

It hides the number, but it does not hide much else

Where three semicolons stop being enough

The formula bar gives it away. When you click any blanked cell, the value sits there in plain view. Show Formulas ignores number formatting, so pressing Ctrl + ` (grave accent) and the grave accent key reveal the whole sheet at once.

Charts are the real surprise. Build one on a blanked range, and the data labels lose their numbers, and so does the value axis below them. Both default to Linked to source, so they inherit the format from the cells feeding them. The tell is a label reading “Average score, Excel,” with a trailing comma and nothing after it. Uncheck that box under Format Data Labels, then do the same under Format Axis, and set a real format in each.

Similarly, errors punch straight through. A number format acts on values, and an error is not one, so #DIV/0! displays as normal among blank cells. Copy a blanked cell and Paste Special as Values, and 6.1 appears in the new cell in plain sight.

Exporting is the one place the format holds. Saving as CSV writes what each cell displays rather than what it holds, so the scoring columns come out as empty fields while the ranks survive. The dates export as Sep 4 rather than a serial number, which confirms the mechanism.

The rest is one symptom repeating. The format controls what a cell shows, and it was never built to control who sees it. Nothing in my scoring columns would hurt anyone, which is why it belongs there. The moment a blanked column holds something that does, lock the cells you do not want anyone editing instead.

Where I would take this next

The display layer is worth using on purpose

The version I want next applies the code through a rule instead of permanently, so a column blanks itself only while a piece is unfiled. That does come with the usual caution about keeping conditional formatting rules under control as a sheet grows.

Dashboards are the other direction. I keep staging data on a separate tab out of habit, though there is an argument for leaving it beside the tiles it feeds. Excel has always kept what a cell shows apart from what it holds, and there is more room in that gap than most sheets ever use.

OS

Windows, macOS

Supported Desktop Browsers

All via web app

Developer(s)

Microsoft

Free trial

One month

Price model

Subscription

iOS compatible

Yes