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...
Menu
Ms Excel...Doubt!
Replies (5)
Hi...try this...
u can go to Data Menu and choose Validation option and check if there is a formula and change accordingly
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......
Thanks...worked out! :)
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...
first trick worked but i dont have the password
Recent Topics :
- Query on scenario related to FAST DS 2026
- Audit Executive (Remote, India) - Ace Auditing Off
- GST Transaction On Used Clothing
- ITC availed on 5%-rate passenger transport (AC bus
- Extension of Due Date of AY 2026-27
- FAST DS 2026
- Does AIS GST Purchase aggregate GSTR-2B expenses?
- Form 26A - System has encountered some technical p
- Tool to convert GST invoice PDFs into Excel —
- Revised or rectification or leave it?
Related Topics :
CAclubindia
