Data entry via Data Form

Built-in Data Forms

By Neale Blackwood

Excel can be used as a basic data base. One of Excel data base features is a built-in form dialog box. To see the dialog box click anywhere inside your data base then click the Data menu and click Forms. You can use the Tab key to move between fields within the record.

The Enter key moves between records. The scroll bar scrolls through the records. The Criteria button lets you find records. Click the Criteria button then enter a value in a field and Press Enter to see the record.