Excel sheet
This query is : Resolved
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
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
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.
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
03 February 2014
read this tutorial: https://office.microsoft.com/en-in/excel-help/freeze-or-lock-rows-and-columns-HP001217048.aspx
03 February 2014
i found solution sir.
Under Excel Sheet - Tools - Protection - Allow user to edit range - .:
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
Click here to login now
Similar Resolved Queries
Unanswered Queries
- EPF ECR NEW FILE SEP 17TH 2026
- Gst registered proprietorship firm
- GST Intimation due to Government took possession of Business Premises under PPE Act
- Non filing of I T Returns
- SALARY CAN BE CAPITALIZE
- Capitalgain tax purposes for valuation report compulsory
- TAX AUDIT ON PROFESSIONAL INCOME
- TDS on Fixed Assets purchased
- TDS on purchase of under construction property from a reseller
- Under marginal scheme
- Import of Software Service.
- Clarification Requested: Gift → NRO → NRE → Overseas Transfer - USA/CANDA (FEMA & Tax Compliance)
- GST on Renting godown to KFCSC for Storage of Raagi
- How to Handle Active E-Invoices in GST Portal Deleted from Tally?
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
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
