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
- CLOSING STOCK QUERY
- Exiting partner in partnership firm in gst portal
- TDS _Long term Capital Gain ref.sec 214 Table 2
- CASH GIFT FROM BLOOD RELATIVE
- TDS offline utility
- Due Date Clarity
- Can a single LLP in India legally operate multiple unrelated businesses (Travel, Cloud Kitchen, Ecom
- Taxability of credit in canara bank ET & T section (NRO)
- ITR-3 File/Error Found
- Loss of interest in PF transfer from EPFO to Trust
- Query regarding Item 61/62/63 vs Item 64 in ITR-3
- Account freezed for Ineligible ITC Scrutiny for GST Annual Return
- TDS on property - Form 141 query
- Seeking Advice: High Tax Shortfall on Job Switch + Let-Out House Property Loss in FY 2025-26
- Housing Society-ITR5
- TDS on Rent received on redevelopment of building
- Indian IT Portal issue in computing tax as per UK-India DTAA
- Capital Gains on sale of residential flat
- Upload Level ValidationITR3Category of Defect B/D
- PF Taxable Income
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
