Hide formulas for the entire workbook

S

Silfrido

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

Thanks in advance.

Silfrido
 
K

Ken Wright

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

Top