| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I hide the formula in an excel sheet?
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?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I hide the formula in an excel sheet?
Format | Cells... | Protection | Hidden: checked
Then Tools | Protection | Protect Sheet... | and provide a password for the sheet Regards Trevor "The Greek" wrote in message oups.com... 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?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I hide the formula in an excel sheet?
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 Trevor Shuttleworth wrote: Format | Cells... | Protection | Hidden: checked Then Tools | Protection | Protect Sheet... | and provide a password for the sheet Regards Trevor "The Greek" wrote in message oups.com... 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?? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I hide the formula in an excel sheet?
Works for me. Can only guess that you didn't check the hidden box on the
cell protection tab Regards "The Greek" wrote in message oups.com... 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 Trevor Shuttleworth wrote: Format | Cells... | Protection | Hidden: checked Then Tools | Protection | Protect Sheet... | and provide a password for the sheet Regards Trevor "The Greek" wrote in message oups.com... 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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data exctraction from multiple sheets | Excel Discussion (Misc queries) | |||
| Excel automatically inserts a formula in my sheet | Excel Worksheet Functions | |||
| Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
