Two columns Data Validation and Password Recovery

  • Thread starter Thread starter Khalil
  • Start date Start date
K

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