How can I hide the formula in an excel sheet?

T

The Greek

How can I hide the formulas in an excel sheet when I need to circulate
a sheets to some of my workmates or when I send it to a client??
 
T

Trevor Shuttleworth

Format | Cells... | Protection | Hidden: checked

Then

Tools | Protection | Protect Sheet... | and provide a password for the sheet

Regards

Trevor
 
T

The Greek

Thanx trevor,

I tried your solution, however, I still can see the fomula. The only
thing I cant do is to modify the sheet once it is protected.

How can I hide the formula from the sheet..

Izz
 
T

Trevor Shuttleworth

Works for me. Can only guess that you didn't check the hidden box on the
cell protection tab

Regards
 

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

Similar Threads

Hide a Formula 3
hiding formulas 2
EXCEL - IF(IFERROR(VLOOKUP question 0
Hiding and protecting formula 1
All my work has gone 1
hide columns on a protected sheet??? 1
Can I hide sheet tabs so only some are accessible? 3
Hide Formula & Allow Copy 1

Top