Thursday, 12 March 2015

How to Make Cell Contents or Formulas InVisible in Excel

Custom Cell Format to Make Cell Contents or Formulas InVisible in Excel
Generally in some cases if you dont want to show the Cell Contents/Formulas to the users ; we can apply  the < Custom Cell Format > to the Range or Selected cells as follows :

Custom Format Apply as below :
Select a Cell or Range that you want to make Invisible
Next Press 'Ctrl+1' to Go to Format Cells > Custom  
Next enter 3 Semicolons(;;;) in the < Type > box as shown below


Finally say 'OK'.

How to Get back from Invisible mode to Visible Mode ?

Simple , Change the Cells format to < General >

Note :
This method is very appropriate than making the Font Color to White.

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts