| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Block Manual Entry
Hi All,
I have a spreadsheet that has 5 coloumns, where 3 I have to put data and I applied the formula on other two i.e. g1 & h1, is it possible to restrict g1 & h1 on manual entry? Regards |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Block Manual Entry
Hassan,
Try to use protection menu: 1. Select Cells by clicking upper left border of a sheet 2. choose format cells menuProtection then Uncheck Loked checkbox 3. then select G1:H1 4. choose format cells menuProtection then Check Loked checkbox 5.Then protect your sheet. -- Regards, Halim "Hassan" wrote: Hi All, I have a spreadsheet that has 5 coloumns, where 3 I have to put data and I applied the formula on other two i.e. g1 & h1, is it possible to restrict g1 & h1 on manual entry? Regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "What-if" formula for either a manual entry and automated entry | Excel Discussion (Misc queries) | |||
| Combine IF function with manual entry | Excel Worksheet Functions | |||
| block manual entry | Excel Programming | |||
| Prohibit manual entry via Drop Down | Excel Worksheet Functions | |||
| Manual or Formula entry in cell. | Excel Discussion (Misc queries) | |||
Linear Mode
