Security for worksheet

Excel 983 views 4 replies

Can any one tell me how to secure an worksheet with a password to disallow others even to view the content in that work sheet...?

Replies (4)

I assume you are using office 2007/2010.

In such case, go to Office Button (which is on top left-side). Click that and select 'Prepare' option which will show more options. From those options, you need to select 'Encrypt Document'. Then it will ask for password 2 times. Choose your password and you are done. Next time when you open the file, you need to put-in the password. In this way, no body else can even view the content because it asks password. Hope this helps you.

Thank you Krishna..!!!

It is really helpful.

if any1 forget the password of excel workbook. how can we able to open it.

 

Subhash..!!!

If any one forgot password, then, they can't access that workbook.

Data in that may be lost.

 


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details
Company
Featured 14 March 2026
Article Trainee

N N V Satish&co

Hyderabad

CA Inter

View Details
Company
Featured 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 12 March 2026
Customer Relationship Executive

TAXLET

Calicut

B.Com

View Details