Page 469 - Excel 2013 All-in-One For Dummies

✦ C16:D16 with the salesperson and job fields
✦ Cell G16 with the due date field
✦ C19:F38 with the quantity, description, and unit price fields
All the rest of the cells in this worksheet are locked and off limits.
Protecting the Spreadsheet 451
Figure 1-8:
Using the Tab key to move from unlocked cell to unlocked cell in a protected worksheet.
To fill in the data for this new invoice, you can press the Tab key to complete the data entry in each field such as Invoice No., Date, Customer ID, Name, Company Name, Street Address, and so on. By pressing Tab, you don’t have to waste time moving through the locked cells that contain headings that you can’t modify anyway. If you need to back up and return to the previous field in the invoice, you just press Shift+Tab to go back to the previous unlocked cell.
To make it impossible for the user to select anything but the unlocked cells in the protected worksheet, you clear the Select Locked Cells check box in the Allow All Users of This Worksheet To list box of the Protect Sheet dialog box.
Book IV Chapter 1
Protecting Workbooks and Worksheet Data