Can forms be used for data entry?
A data form provides a convenient means to enter or display one complete row of information in a range or table without scrolling horizontally. You may find that using a data form can make data entry easier than moving from column to column when you have more columns of data than can be viewed on the screen.
How many fields can you have in an Excel data form?
What is an Excel Data Form? A data form is simply a modal dialog box with the fields for one record. The form sits on top of your Excel spreadsheet. It allows you to enter up to 32 fields per record on a cell-by-cell basis.