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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top