Data entry forms in Excel: Excel can generate a built-in data form. A data form is a dialog box that displays one complete record at a time. You can use data forms to add, change, locate, and delete records for your range. The data form displays all of your column labels in a single dialog box, with a blank space beside each label for you to fill in data for the column. You can enter new data, find rows based on cell contents, update existing data, and delete rows from the range.
Use a data form when a simple form listing the columns is sufficient and you don’t need more sophisticated or custom features. A data form can make data entry easier than typing across the columns when you have a wide range with more columns than will fit on the screen at one time. A custom data form is described in the training video at creating a custom dialog box.
Excel Data Entry Form