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
- Form 3CEAB
- Form 3CEAA and Form 3CEAB
- DIR 3 Web KYC
- Can i declare LTCG income as business income if I
- Stock entry in new software
- I have an EMI collection shop, what is its SAC cod
- Making payment once in quarter possible under QRMP
- Master File Documentation related
- Applicability of 44AD needs clarification
- ITC reversal in GST 3B
Related Threads
CAclubindia
