When multiple employees have access to company spreadsheets, it’s important to prevent unauthorized changes. Excel has two methods for protecting a spreadsheet from changes. The “Mark as Final” command places a message at the top of the screen informing the employee that she shouldn’t make changes to the document. This is only a warning, however, as she can still freely edit the document. When you add password protection to the document, other employees can read the document but need to enter a password if they want to make changes.
Mark as Final
1. Click “File” in the menu bar, and then select “Info.”
2. Click “Protect Workbook,” and then select “Mark as Final.” The document is automatically saved if you previously saved it to your computer. Otherwise, the Save As window appears.
3. Select the folder where you want to save the Excel document, if you haven’t previously saved it, enter the document name in the “File Name” text box, and then click “Save.”
1. Click “File” and then “Save As.” Select the folder where you want to save the Excel document and enter a name in the “File Name” text box.
2. Click the “Tools” drop-down menu and select “General Options.” The General Options window includes the choice of two types of passwords.
3. Enter a password in the “Password to Modify” text box, click the “OK” button and then click “Save.”