How do I password protect an excel document that is read only?



How do I password protect an excel document that is read only?..

Answer / Kiran Kumar

To password-protect a read-only Excel file, you need to make the file read/write enabled first. Open the file, save it as a new copy with a different name, and then change the 'Read-only recommended' option to 'Read-only'. Next, click 'Protect Workbook', select 'Encrypt with password', input your desired password, and click 'OK'. Remember to save the file after encrypting.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

What is the difference between vlookup and lookup?

1 Answers  


Can you do text to rows in excel?

1 Answers  


How do I make an excel document read only?

1 Answers  


How do I set up scenario manager in excel?

1 Answers  


How do you do a lookup in excel?

1 Answers  


How do I calculate 10% of a number?

1 Answers  


How many types of excel sheets are there?

1 Answers  


How many excel functions are there?

1 Answers  


How do I make a chart?

1 Answers  


What do you mean by rows and columns?

1 Answers  


What is the use of chart?

1 Answers  


How do you use the left function?

1 Answers  


Categories