Note: The other languages of the website are Google-translated. Back to English
English English

Quickly create a data entry form in Excel

If there is a big table containing multiple columns of data, you have to drag the scroll bar for viewing the whole contents of each row as below screenshot shown, which is too inconvenience and easy to miss data. Here the Data Form utility of Kutools for Excel displays all data in a row as a page of a form so that the data looks more clearly, and also supports data editor.
shot entry form

Applying the Data Form by clicking Kutools > Data Form. See screenshot:
shot entry form 1

Click at a cell or a range of the table that you want to create a data entry form, then click Kutools > Data Form.

In the popping Data Form window, you can set and edit data as below:

1. Set the working scope. Click the drop-down list of Scope to choose one scope you use.

Current range of active cell: the current range of the active cell will be displayed in the window. By default, if you choose one cell, this option will be selected.

Current range: only the data in the selected range will be displayed in the window.

Current sheet: all data of the active sheet will be displayed in the window.
shot entry form 2

2. shot entry form 4Here shows the number of all rows of data for you, in the textbox, you can type the specified row number that you want to view the data.

3. Drag the scroll bar to view the data of the row from up to bottom.
shot entry form 4

4. Add button: click Add button to add a new blank row above the current row, and then you can click at the textboxes in the Value section to type new data one by one.
shot entry form 3

Apply button: click this button, the changes you make in the Data Form window (including data changes and rows adding) will be synchronized to the original table. If you do not click Apply button before you close the Data Form window, the changes won’t be saved.

Revert button: this button is used to reset data to the original data. If you make some changes to the data in the Data Form window and have click the Apply button, before closing the window, you click Revert button to cancel the changes.

Previous one, Next one buttons: click to show the data in the preview or next row.

Previous page, Next page buttons: click to show the data of the row in the previous page or next page of the current sheet.

Delete button: click this button to immediately delete the current row.

Close button: click Close button to exit the Data Form utility.

Note: The hidden rows and columns cannot be viewed in the Data Form window.

Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Leave your comments
Posting as Guest
Rate this post:
0   Characters
Suggested Locations