Protect individual cells on a worksheet

  • Thread starter Thread starter Gerry
  • Start date Start date
G

Gerry

I have a worksheet with 15 columns, I do not want the
folks accessing this worksheet to insert data in the last
10 columns but I do want them to be able to insert data in
the first 5 columns.
Can this be done? If so, how?

Thanks
 
-----Original Message-----
I have a worksheet with 15 columns, I do not want the
folks accessing this worksheet to insert data in the last
10 columns but I do want them to be able to insert data in
the first 5 columns.
Can this be done? If so, how?

Thanks
.
Highlight all the cells in your spreadsheet and then on
Click to expand...
the menu bar click FORMAT CELLS PROTECTION and make the
LOCKED box is checked. Click OK. Next highlight the 5
columns you want to allow users to input into and click
FORMAT CELLS PROTECTION and uncheck the LOCKED box.
Lastly click TOOLS PROTECTION PROTECT SHEET and provide a
password. Now users can't change anything other that the
columns you specified without your password.
 
Back
Top