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
- Itr 1 processing
- Off Market debit and credit transaction
- Showing Gift from relative in ITR for this year
- Reporting Income under Section 44ADA
- Short Term Capital gain on shares bought and sold after 2018 onwards
- ITR 1: Details for showing Exempt Income
- ITR 2 Short Term gain & Long term gain
- Share accounting-->fifo - capital gain - period as per fifo?
- ITR selection for salaries and capital gain less than L
- ITR returnFY25-26
- ITR validation error - Balance sheet is not filled
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
- Tax amount diff in Gstr1 and 3B in tax compare reports
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
