Hide formulas for the entire workbook

  • Thread starter Thread starter Silfrido
  • Start date Start date
S

Silfrido

Hi, can anyone tell me: How to hide all the formulas
present in the entire workbook?

Thanks in advance.

Silfrido
 
One way, though easily defeated by most that frequent these groups, would be to select the entire
sheet CTRL+A, then do Format / Cells / Protection Tab / Check 'Hidden' (Might want to uncheck
protected, or not as the case may be). Then protect the sheet and give it a password if you don't
want them to disable it.

Users will now not be able to view the formulas in the formula bar.
 
Back
Top