posted Feb 25, 2011 11:11 PM by Ayush Jain
This trick will let you hide the formulas & keeping the worksheet usable, by performing the following steps: - Select all cells (either press Ctrl+A or click on the small upper left square on the edge of the worksheet)
- Right Click and select Format Cells
- In the popup menu that opens, click on the Protection tab (it should be the last one on the menu)
- Deselect the small box tagged Locked
- Click on OK. Now all your cells can be overwritten, regardless the protection status of the worksheet.
- Select only the cells containing formulas that you want to hide (If
you need to perform multiple selection, you can press and hold down the
Ctrl key, while clicking on each cell you want to select)
- Right Click and select Format Cells
- In the popup menu that opens, click on the Protection tab
- Tick the small box tagged Hidden and the Locked box as well. If you
don’t tick the Locked box, other users of your worksheet would be able
to overwrite the formula cells, without even knowing that they contain
formulas (as they become invisible following this operation).
- Click on OK
- Go to Review Tab and Select Protect Sheet
- If you want, you can input a password for unlocking the worksheet.
This will prevent others from unlocking it. If you don’t want to do
that, leave the password field blank and press OK.
- Now click on one of your cells containing formulas and look at the
formula bar. It should be empty, although the formula is still there.
The cell would remain locked, but it would be automatically updated when
changing the content of its precedents relating to the contained
formula.
|
|
