EXCEL FORMULA
This query is : Resolved
01 April 2009
Dear All,
I am working in excel sheet, and i want that in one excel sheet some row and column ritten by me should be block any body cannot change them. and in other column in which i want every body can write some thing which he want.
is it possible, pls, tell me and how
Thanking you
Harish
I am working in excel sheet, and i want that in one excel sheet some row and column ritten by me should be block any body cannot change them. and in other column in which i want every body can write some thing which he want.
is it possible, pls, tell me and how
Thanking you
Harish
01 April 2009
It is possible.
Step1: Select all cell, and right click on it and go to Format cell and then on protection and remove the check sign from 'locked'.
Step 2: Select You cellm and right click, go on protection, now insert the check sign on Locked'
Step3: Now go on Tools in Meenu Bar, go on protection, and assign a password for your cell.
Step1: Select all cell, and right click on it and go to Format cell and then on protection and remove the check sign from 'locked'.
Step 2: Select You cellm and right click, go on protection, now insert the check sign on Locked'
Step3: Now go on Tools in Meenu Bar, go on protection, and assign a password for your cell.
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
- Depreciation Chart Companies Act
- EPF ECR NEW FILE SEP 17TH 2026
- GST Audit whether Govt Companies are exempt?
- PTRC Show Cause Notice on Email
- Capital Gail Exemption Certificate
- Utilisation Fy 25-26 TDS challans in Fy 26-27 TDS Return
- Oct 2025 Invoices
- SECTION 393(3) TAX ON CASH WITHDRAWAL
- Under marginal scheme
- TAX AUDIT ON PROFESSIONAL INCOME
- EPF ECR NEW RULES Sep 17th 2026
- Taxation of crypto futures in India Fy 2026- 2027
- Transfer of Physical Stock Between Two Proprietorship Concerns
- Unable to File TDS Q2 Return – New TRACES Portal Error
- 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
- Sales of goods of amount Rs97 lakhs to a party
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
