Excel has several features that can help automate data entry. Data forms enable users ... types into the text box associated with each column, moving through the fields using the Tab key.

go to the new record row and click the category cell (column D). As you can see in Figure F, the list (which you can see in Figure D) is available for data entry. (If you imported the example data ...