top of page

Hide cell contents with semicolons

In Excel, you can use semicolons in Format Cells to control whether or not text and numbers are displayed.

Entering two semicolons in the Custom category on the Number tab will hide the contents of any cells which contain only positive or negative numbers:

Entering three semicolons will hide the text and numbers:

bottom of page