Block Manual Entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hassan,

Try to use protection menu:
1. Select Cells by clicking upper left border of a sheet
2. choose format cells menu>Protection> then Uncheck Loked checkbox
3. then select G1:H1
4. choose format cells menu>Protection> then Check Loked checkbox
5.Then protect your sheet.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Numbering rows by font color, but skipping blanks 1
Multiple Criteria 11
Attendance sheet 1
Sound repeats unending until closing workbook 2
NEED MACRO TO GET BALANCE 2
copy data to one file from all files 4
Subtraction by row 6
simple code but it doesn't look like usual vba code 2

Back
Top