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.

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.