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
|