How do i can lock more than one range in worksheet
 

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

How do i can lock more than one range in worksheet
 

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


"Nazr-ul-Haque" wrote:

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

How do i can lock more than one range in worksheet
 

Thanks Mr. Mike

Its realy work.

Nazr-ul-Haque

"Mike H" wrote:

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


"Nazr-ul-Haque" wrote:

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