How to Password

1. Open Excel 2010 and click the 'File' tab. Click 'Open.' Browse the files and locate a workbook. Click the workbook and the 'Open' button. The workbook opens.
2. Select the worksheet where the password protection will be applied. Click the 'Review' tab and select 'Protect Sheet.' The Protect Sheet dialog box appears.
3. Type the password in the provided 'Password' field. Click 'Ok.' When prompted to confirm the password, retype the password. Click 'Ok.' Notice the ribbon has grayed out areas. These areas will not be accessible unless the user knows the password.