Two columns Data Validation and Password Recovery

[Khalil]

Dear Experts;

Please advise on the following.


1.. How to recover the lost password of protected sheet.
2.. How can I do the Data Validation for Two or more colums, where
both columns data may display Simultaneously.

thanks
Khalil

 

[Shane Devenshire]

If you are talking about a protected sheet not a workbook then highlight the
entire sheet and choose Copy. Move to A1 on an unprotected sheet and paste.
Delete the original sheet the new sheet will not be password protected.

Need more detail on the second question.