excell
 

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

excell
 

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



"ABDUL MUMTAZ" skrev:

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

excell
 

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

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

FormatCellsProtection. Uncheck "locked"

Select the cells you want hidden from view in the formula bar and
FormatCellsProtection

Check "locked" and "Hidden"

ToolsProtectionProtect 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
wrote:

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