Hide cell value only without hiding Row and column - quick tips

Hide cell value only without hiding Row and column

Sometimes you want to hide cell value only and not any row or any column. But that hidden value can be used in any formula without any issue.

To hide only cell values first select that particular cell.

Then right click on it and select option Custom from Format Cells

Then in Type field enter three times semicolon (;;;) same as highlighted in below screenshot and hit Ok.

Now you can see cell value is hidden but it is not affected formula and also note it is display only in Insert Formula Bar.

Hope you understand as it is very easy

Watch video

Thank you…Enjoy Excelling