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

@VaibhavJ

@VaibhavJ (Expert)
Follow

03 February 2014 read this tutorial: https://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 - .:

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Join the CA Students WhatsApp Community for ICAI Updates, Trending Courses & Notes!

Similar Resolved Queries

Unanswered Queries

Popular
Recent

Trending Online Classes

Direct Tax Laws & International Taxation May 26,Sept 26 & Jan 27

CA Arvind Tuli

Enroll Now
Audit Fast Track Recorded Batch For May 26,Sept 26 & Jan 27

CA Aarti Lahoti

Enroll Now
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English

CA Bhanwar Borana & CA Shubham Keswani

Enroll Now

view all classess

Meet our CAclubindia PRO Members

CA.Pinank Arvindbhai Shah

Nayan shetty

madhu sudan

velichety.l.narasimharao

SANJAY GOSALIA

Subscribe Now

Excel sheet

Similar Resolved Queries

Trending Online Classes

Meet our CAclubindia PRO Members

Quick Links

Browse by Category

Latest Job Openings

Senior Executive

Manager- Finance and Compliance

GST CONSULTANT

GST CONSULTANCY

Accountant

CA Final

Article Assistant

Associate CA