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: http://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
- Is this income indian or foreign income?
- ITC temporary reversal and reclaim
- Applicable TDS rate for sale of property in Nov 2024
- Inventory of finished goods
- Tds on building rent monthly
- Quiery in relation to GST liability in case of an advocate who has obtained GST registration.
- Confusion around Form 26QB fields
- Can we claim ITC of Feb-2024 in the month of November-2024 which was not claimed by oversight
- Sale of property furniture sale
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- Clarification on Documentation of Paid-Up Capital Contribution by Directors
- TDS under section and rate of TDS
- GST input on scooter purchased
- TDS under section 194Q and TCS under section 206C
- GST input on car insurance and repairs
- GST input on Diwali gift to employee
- GST input on Mobile Handset
- Material and freight in same invoice
- TDS under section 194J inclusive of reimbursement of expenses
- TDS on Material and Labour in same invoice
Trending Online Classes
CAclubindia
