Quickly create a data entry form in Excel
Kutools for Excel
Boosts Excel With 300+
Powerful Features
If there is a big table containing multiple columns of data, you have to drag the scroll bar to view the whole contents of each row, which is too inconvenient and easy to miss data. But with our Data Form utility of Kutools for Excel, it displays all data in a row as a page of a form so that the data looks more clearly, and it also supports the data editor.
Click Kutools >> Data Form to enable the feature. See screenshot:
Create a data entry form
Supposing, you have a big table with multiple columns of data. To avoid dragging the scroll bar to view the whole contents of each row and quickly edit specific cell, we need to create a data entry form. Please do as follows.
1. Click at a cell or a range of the table that you want to create a data entry form.
2. Then apply this feature by clicking Kutools > Data Form, and it opens the Data Form dialog box.
3. Click the drop-down list of Scope to set the working scope.
- 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.
4. Here 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.
5. Click the New button, you can add a new blank row above the current row, then you can click at the textboxes in the Value section to type new data one by one.
What’s more, there are more options you can apply:
- 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. Or after you make changes in the Data Form window, you can just click the Enter key on the keyboard, or move the mouse from the current Value box to another data entry, to save and synchronize the changes.
- Undo cell, Undo entire row buttons: these two buttons are used to reset data to the original data. If you click the Undo cell button, the changes you made in current cell will be undone. If you click the Undo entire row button, the entire row will be restored back.
- 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 this button to exit the Data Form utility.
Note: The hidden rows and columns cannot be viewed in the Data Form window.
Demo: Quickly create a data entry form in Excel
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 30 days.