Open Excel and create a new workbook or open an existing one
Decide what fields you want in the form
Enter the field names in the first row of a worksheet
Select the data range
Go to the Insert tab
Click Table
Check My table has headers
Click OK
Use the table as a simple data entry form by typing into the next empty row
To use the built-in Form feature, add Form to the Quick Access Toolbar
Click the Quick Access Toolbar drop-down
Choose More Commands
Select All Commands
Find and add Form
Click OK
Select any cell in your table
Click the Form button on the Quick Access Toolbar
Enter data in the form fields
Click New to add a record
Click Find Prev or Find Next to review records
Save the workbook
Protect or format the worksheet if needed