| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
| create a slides show with excell spreadsheets using excell | Charts and Charting in Excel | |||
| editing documents with excell that are not excell format | Excel Discussion (Misc queries) | |||
| how do you open an excell email attacment, if I dont have excell | Excel Discussion (Misc queries) | |||
| Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
Hybrid Mode
