In excel, if a person has restricted the values to be entered ina cell,...How do we remove tht...!?
Say,.if a person has rectricted a cell which has some formula,..i need to modify that....and change the formula,...how can i do tht..!?
Reply asap...
5 Replies
Rashmi
(CA)
(83 Points)
Replied 04 December 2009
Hi...try this...
u can go to Data Menu and choose Validation option and check if there is a formula and change accordingly
CA GIRISH
(Chartered Accountant)
(1796 Points)
Replied 04 December 2009
you can do following ....
1} GO to tools - protection-unprotect sheet/workbook..if it prompts password u need to have that password...
2} press CTRL+~ SIGN U CAN VIEW ALL FORMULAS IN A SHEET.TO GO BACK TO NORMAL VIEW REPEAT THE SAME......
CA GIRISH
(Chartered Accountant)
(1796 Points)
Replied 04 December 2009
You can do 1 more thing mail that password protected file to yourself and download it n open then go to tools protection unprotect sheet its done.....let me know if it works...
vinayak
(article clerk)
(62 Points)
Replied 11 December 2009
first trick worked but i dont have the password
Recent Topics
- NRO Interest - Taxed at source and in Foreign Coun
- Clarity needed on effective date
- Income Tax Refund Deadline Shortened to Five Years
- Rectification Applications for Past GST Demands
- Where can I find a trusted provider to hire a skip
- GST Invoices Series
- FILING OF ITR AY 20-21
- CLAIMING OF U CLAIMED RCM
- Building construction works
- REGARDING GSTR-9 F.Y 2023-24
Related Threads
CAclubindia
