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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Additions of Round Function and Minus Sign at Once 7
Count, Sum, and Filter by Color 3
Data Validation 1
Multiple data validation criteria? 1
retrieve data from two columns and sort 17
Different password for different worksheet 11
Excel Comparing two columns 1
Creating Data Validation Dependent Lists 2

Back
Top