Open the spreadsheet you want to protect in Excel, click the "Review" tab and then click "Protect Sheet" in the Changes group to display the Protect Sheet dialog.

Create a Sheet Structure for Random Password Generator At first, you need to create a basic structure of your sheet to generate a random strong password.

To add password protection to sheet 2, right-click on it, select “ Protect sheet,” create a password and click OK. This is how you can create an automated quiz in MS Excel by using formulae.