Ms Excel...Doubt!

763 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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 09 June 2026
Article Trainee

Numbertree LLP

Mumbai

CA Inter

View Details
Company
09 June 2026
Accounts Associate

S Madan and CO

New Delhi

Graduate (Any)

View Details
Company
ARTICLESHIP 24 June 2026
CA Article Trainee

Rahul Dang & Associates

Pune

CA Inter

View Details
Company
ARTICLESHIP 20 June 2026
Articleship

RB KESHRI & CO

Mumbai

B.Com

View Details
Company
ARTICLESHIP 08 June 2026
Internal & Taxation Article

O P Bagla & Co LLP

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 27 June 2026
CA Articled Trainee And Paid Assistant

SKAA & Associates

New Delhi

CA Inter

View Details
Company
Featured 24 June 2026
HEAD - AUDIT AND TAXATION

A R JADHAV AND ASSOCIATES

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 24 June 2026
ARTICLE ASSISTANT

BHUPINDER SHAH AND COMPANY

New Delhi

CA Inter

View Details