locking a particular cell in excel
This query is : Resolved
16 September 2009
Dear all,
I have created a invoice template in excel. While I have been successful in creating an auto incrementing serial number feature, i would like that particular cell to be locked so that the serial number cell is prevented being edited .
I have created a invoice template in excel. While I have been successful in creating an auto incrementing serial number feature, i would like that particular cell to be locked so that the serial number cell is prevented being edited .
23 October 2009
go to that particular cell
right click .......> Format cell........> Lock Cell
Go to Tools.........>Protection..........>Protect sheet
and do not allow user to select locked cell
i think it will work
right click .......> Format cell........> Lock Cell
Go to Tools.........>Protection..........>Protect sheet
and do not allow user to select locked cell
i think it will work
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Query regarding applicability of UDIN on MCA forms signed using DSC by a Chartered Accountant
- Cash gift by grand mother to her grand daughter
- Tax amount diff in Gstr1 and 3B in tax compare reports
- Spice form, ? mark comes in address
- Tds on GST in connection with sale to public company
- Restoration of certificate of practice
- Regarding change in correspondence address in SSP portal
- No Compliences after incorporation
- USEFUL LIFE OF USED/SECOND HAND COMMERCIAL VEHICLES
- Surcharge on pvt discretionary trust
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
