Data 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. |