G'day,
You could actually use Sheet Protection to do this. The steps are:
Highlight the data entry range (columns A-G). Format cells, Protection tab, then unlock the cells. Then when you get into a data entry mood go to tools/protection/protect sheet (defaults).
While the sheet is protected you can only enter data into unlocked cells. The good part is that you can quickly move through the cells by hitting TAB to move to the right or to a new record.
Hope that helps,
Adam
Like this thread? Share it with others