hiding

  • Thread starter help with excel
  • Start date
H

help with excel

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.
 
V

Vergel Adriano

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.
 
Top