Question

How to create data in ms exel

Answer 1

Below are the steps to create a new entry using the Data Entry Form in Excel:

Select any cell in the Excel Table.

Click on the Form icon in the Quick Access Toolbar.

Enter the data in the form fields.

Hit the Enter key (or click the New button) to enter the record in the table and get a blank form for next record.