banner_ad

Ms Excel...Doubt!

IPCC 747 views 5 replies

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...

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


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
19 May 2026
Fundraising Expert

MentorsWorld Ventures Private Limited

Ahmedabad

Others

View Details
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
19 May 2026
Accountant

ca kunjan

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 17 May 2026
CA Article /Trainee

Malik Sunil & co

New Delhi

CA Foundation

View Details
Company
23 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
26 May 2026
CA / MBA (Finance) / CMA / M.Com (Finance)

Sri Aurobindo Gnostic Centre of Education

New Delhi

CA

View Details
Company
ARTICLESHIP 31 May 2026
Article Assistant

KPRS And Associates

New Delhi

CA Inter

View Details
Company
22 May 2026
Audit assistant

Displayandbeyond

Mumbai

CA

View Details