Data entry in an Excel spreadsheet can be tedious. Use the power of restricted access to speed up data entry. The idea is that by restricting access to only specific cells (which are for the data), data entry can be quickly completed because the Enter key also serves a dual role by moving the cursor to the next available cell. The "move to the next cell" is down and then to the top of the next column (the first cell).

Excel Tips And Tricks

Home Links

Specific steps to restrict access to specific cells:

  1. Unlocking specific cells for data entry. After selecting the cells, from Format - uncheck the "Locked" box on the Protection tab. This also works for selecting entire columns or rows. But nothing happens until you do #2 below.
  2. Protect the Worksheet to control which cells can be changed. From the ribbon menu for Review - Protect Sheet and uncheck "select locked cells". This restricts cursor movement to unlocked cells only, which you specified in step #1 above.
  3. Enter the data!
  4. Reverse the "Protect the Worksheet" steps in #2 above so that you can access all cells in the worksheet.


Other Excel Pages: Excel References Page, Excel Statistics For Grading, Excel Tips And Tricks, Excel-Data Entry Tip


For a long time it had seemed to me that life was about to begin - real life. But there was always some obstacle in the way. Something to be got through first, some unfinished business, time still to be served, a debt to be paid. Then life would begin. At last it dawned on me that these obstacles were my life.

Fr. Alfred D'Souza

Page Views: 1286 | << | Trail Index | >> | HomeLinks