Hide cell values in Excel - Excel Tips and Tricks

Learn how to hide cell values in Excel.

In Excel, the cell formatting ";;;" is a custom number format that hides the contents of a cell completely. When you apply this format to a cell or range of cells, any value or text entered into those cells will not be displayed. It effectively makes the cell appear empty, even though it may contain data.

This formatting can be useful in situations where you want to keep certain data hidden from view, perhaps for organizational purposes or for hiding intermediate calculations in a worksheet. However, it's essential to remember that the data is still present in the cell and can be accessed through formulas or by changing the cell format.

Here are the steps featured in my video.

Hide Cell Value For Text
1) Select cell
2) Ctrl + 1
3) Number tab
4) Custom
5) ;;;"***NAME***"
6) OK

To Toggle Formatting
Ctrl + ~

To Undo Formatting
Ctrl + Shift + ~


What does ;;; means?
In Excel cell formatting, the semicolon (;) is used to separate different sections of the format. Each section corresponds to a different condition: positive numbers, negative numbers, zero values, and text, respectively.


Okay what does this mean ;;;"***NAME***" ?
Here's what each part means in the format you provided:

1) ;;;: This section is for formatting positive numbers. When there's no format specified for positive numbers, Excel will display them as is, without any additional formatting.
2) "***NAME***": This section is for formatting text. It specifies that the text "NAME" should be displayed in the cell. The text is enclosed within double quotation marks to indicate that it's a literal text string and should be displayed exactly as written.


So, the format ;;;***NAME*** tells Excel to display the text "NAME" in the cell, regardless of the value contained in the cell. Any positive numbers, negative numbers, or zero values in the cell will not be displayed; only the text "NAME" will be shown.

ADDITIONAL INFO not shown in video.

Hide Cell Value For Numbers
1) Select cell
2) Ctrl + 1
3) Number tab
4) Custom
5) [>0]"***AGE***"
6) OK

Hide cell values in Excel,How do I not show all text in an Excel cell?,How do I make Excel not show values?,How to Hide Cells in Excel,
How do you use a semicolon in Excel?,What are 3 ways to use a semicolon?,Why is colon (;) used in MS Excel?,

Check out my complete suite of Microsoft Excel Tips and Tricks.
https://www.youtube.com/@jjnet247/shorts
https://www.tiktok.com/@exceltips247
https://www.instagram.com/exceltips247/
https://www.dailymotion.com/ExcelTips247
https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/
https://x.com/ExcelTips247/media
https://www.reddit.com/r/Excel247/
https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks