Smartstaff, administrator
3,732
edits
Changes
→Locking The Excel Spreadsheet
===Locking The Excel Spreadsheet===
Now that we have set up our Excel spreadsheet and named the cells we want to parse, we need to lock the spreadsheet. We will lock the entire spreadsheet except our desired cells so the applicant cannot add rows, columns or otherwise modify the spreadsheet as that could cause the parse process to fail.
# Click the box to the left of column A (in between column A and row 1). This will select all cells. [[File:Excel-parser-2020-spreadsheet-selectall.png|thumb|none|500px|Select all cells in the spreadsheet by clicking between column A and row 1]]
# Right click the same box – select '''Format Cells''' then click the '''Protection''' tab.
# Make sure the "Locked" checkbox is checked. [[File:Excel-parser-2020-spreadsheet-locked.png|thumb|none|500px|Make sure all cells are locked]]
# Click '''OK''' (these first few steps make sure that all cells are locked. See steps 5-6 for unlocking individual cells).
# Right click just the cell(s) you wish to have editable by the end user (i.e. unlocked).
# Select '''Format Cells''' then click the '''Protection''' tab. Then un-check the '''Locked''' box. This will '''unlock''' the cells that you want the end user to be able to edit.
# Click the '''Review''' tab, then click '''Protect Sheet''' (In older versions of Excel, this may be found under the '''Tools''' menu, then '''Protection''').
# Only allow the user to select unlocked cells and enter a password in the prompt to be used to un-protect the sheet.
