excell

A

ABDUL MUMTAZ

HI THERE,
IM PREPARING A PROGRAM IN EXCELL SOFTWARE AND WOULD LIKE TO KNOW HOW TO HIDE
FORMULA WHICH APPEARS IN A CELL.
PLEASE HELP ME OUT.
THANKS A LOT
ABDUL MUMTAZ
 
E

excelent

Rightclick on cell > Format cell > Click protection-tab > Checkout Hide > OK
Protect ur sheet



"ABDUL MUMTAZ" skrev:
 
G

Gord Dibben

By default, all cells are protected when sheet protection is enabled.

Hit CTRL + a(twice in 2003) to select all cells.

Format>Cells>Protection. Uncheck "locked"

Select the cells you want hidden from view in the formula bar and
Format>Cells>Protection

Check "locked" and "Hidden"

Tools>Protection>Protect Sheet. Note the options when protecting.

Supply a password and OK.

Excel's internal security is weak but this will prevent overwriting by accident.


Gord Dibben MS Excel MVP

On Sat, 26 May 2007 00:21:02 -0700, ABDUL MUMTAZ <ABDUL
 
Top