How to desable one cell in Ms excel. I mean to say that there is one formula in one cell there fore i want that at the time to type some data in particular sheet the cell containing the formula could not be altered.
3 Replies
Anil Kumar Agarwala
(CA)
(67 Points)
Replied 03 January 2008
Dear Deepak
This can be done by protecting the sheet.
Now that would lock all cells! The trick is to first format cells which you donot want locked and clear the check mark against lock cell for those cells (Format cell --> protection). Then protect the sheet.
If you want only one (or a few) cell locked, first select all cells (ctrl+A) and in cell-format, unlock all cells. Then you may select cells you want to lock. Last, protect the sheet and Bingo! u are done.
This can be done by protecting the sheet.
Now that would lock all cells! The trick is to first format cells which you donot want locked and clear the check mark against lock cell for those cells (Format cell --> protection). Then protect the sheet.
If you want only one (or a few) cell locked, first select all cells (ctrl+A) and in cell-format, unlock all cells. Then you may select cells you want to lock. Last, protect the sheet and Bingo! u are done.
DIPAK AGARWAL
(Service)
(554 Points)
Replied 05 January 2008
thank you...Sir
i am able to do the same what i want, from your suggestions.
Recent Topics
- Bill TO SHIP TO INVOICE HSN
- LTCG for property sold and bought new
- E Waybill regarding
- LONG TERM CAPITAL GAIN TAX REG
- Key actions - businesses can take to adjust their
- GST Manpower services
- Top Digital Marketing Agency in Australia
- Bank deducted TDS at a higher rate and PAN is obta
- Holding Multiple PANs May Impose Penalties
- GSTR-9 2023-24
Related Threads
Trending Online Classes
-
Excel Mastery Program
CA Rishabh Pugalia
CAclubindia
