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
- Post Office RD Interest
- Reporting Income under Section 44ADA
- Itr 1 processing
- Building and other construction workers welfare cess act 1996
- ITR validation error - Balance sheet is not filled
- ITR 1: Details for showing Exempt Income
- Bank Accounts in Balance Sheet for ITR 3
- TDS ON CASH WITHDRAWALS...
- Eway bill for machinery reparing
- Annual return of gst limit
- ITR 3 FILING OF AN INDIVIDUAL (PARTNER IN A PARTNERSHIP fIRM)
- Delisted shares sold in off market/ Rebate u/s87A
- In Exports Sales HSN details where to fill
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- Difference in tax comparison report
- 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
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
