How to set a password to encrypt an Excel spreadsheet 1. With your Excel spreadsheet open, click on the "File" tab, then click on "Info." 2. Click on the box labeled "Protect Workbook" to open a ...