Forum Discussion
Spreadsheet to form
How can I make my spread sheet into a fill-in form?
Select all the cells that the user should be able to edit (fill in), and only those cells.
Press Ctrl+1 to activate the Format Cells dialog.
Activate the Protection tab.
Clear the Locked check box.
Click OK.
Activate the Review tab of the ribbon.
In the Protect group, click Protect Sheet.
Leave only the 'Select unlocked cells' check box ticked.
Enter a password that will be needed to unprotect the sheet. Do not forget this password!
Click OK.
Enter the password again as confirmation, then click OK.
The user can now enter data in the unlocked cells and move from cell to cell by pressing Tab or Enter.
All other cells will be locked and cannot be selected.