Excel sheet

This query is : Resolved

Accounting Home Services (Querist)
Follow

01 February 2014 Dear All,

can anyone help me.
please tell me how to lock specific Row/Column in Excel 2003.
i know how to protect sheet but i want specific Row/Column.

Thanks

@VaibhavJ

@VaibhavJ (Expert)
Follow

01 February 2014 First you need to protect sheet after That select row you want to lock then right click then select property then select lock cell.

Accounting Home Services

Accounting Home Services (Querist)
Follow

03 February 2014 SIR WHEN I PROTECT SHEET & THEN RIGHT CLICK WHERE I WANT TO LOCK SPECIFIC CELL/ROW/COLUMN BUT THERE IS NO OPTION OF PROPERTY IN RIGHT CLICK

Upgrade to CAclubindia Pro. Subscribe Now!

@VaibhavJ

@VaibhavJ (Expert)
Follow

03 February 2014 read this tutorial: http://office.microsoft.com/en-in/excel-help/freeze-or-lock-rows-and-columns-HP001217048.aspx

Accounting Home Services

Accounting Home Services (Querist)
Follow

03 February 2014 i found solution sir.
Under Excel Sheet - Tools - Protection - Allow user to edit range - .: