Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding
good day all.
I have done up a excell sheet with formulas which i do not want anyone else to view, as i will be emailing this to several individuals, how do i prevent people from viewing the unwanted areas? thanks. i know how to set up the area for printing, this is not what i am looking for do. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding
I assume you want to hide the formula, but want to show the value.
You can protect the sheet. 1. Select all the cells with formulas that you want to hide. 2. Format-Cells, in the Protection tab, check Locked and Hidden 3. Tools-Protection-Protect Sheet Again, this will hide the formula in the formula bar. Users would see the value in the cell. "help with excel" wrote: good day all. I have done up a excell sheet with formulas which i do not want anyone else to view, as i will be emailing this to several individuals, how do i prevent people from viewing the unwanted areas? thanks. i know how to set up the area for printing, this is not what i am looking for do. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
Hiding #N/A | Excel Discussion (Misc queries) | |||
HIDING DIV/0! | Excel Discussion (Misc queries) | |||
#DIV/0! hiding | Excel Discussion (Misc queries) | |||
Hiding #N/A | Excel Worksheet Functions |