How do i can lock more than one range in worksheet

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

Guest

without any doubt excel is a great help to Accountants. I do a lot work on
excel. Even once I maintain company account for a year in 2000 and 2001.

Now my question is that how I can lock more than one range (Row & Coloumn)
in a worksheet.
Thanks and best regards
Nazr-ul-Haque
 
By default all cells in a sheet are locked and this is activated by
protecting the sheet. So to do what you want you have to remove the lock from
cells you want to edit.

select all the cells in your sheet and then
Format|cells|protection and remove the 'Locked' checkmark.

Now select the ranges ypu want to protect by holding down the CTRL key and
selecting them and then
Format|cells|protection and replace the 'Locked' checkmark.

Tools|protection|protect sheet and your done.

BTW its' not very secure.

Mike
 
Thanks Mr. Mike

Its realy work.

Nazr-ul-Haque

Mike H said:
By default all cells in a sheet are locked and this is activated by
protecting the sheet. So to do what you want you have to remove the lock from
cells you want to edit.

select all the cells in your sheet and then
Format|cells|protection and remove the 'Locked' checkmark.

Now select the ranges ypu want to protect by holding down the CTRL key and
selecting them and then
Format|cells|protection and replace the 'Locked' checkmark.

Tools|protection|protect sheet and your done.

BTW its' not very secure.

Mike
Click to expand...
 
Back
Top