Quickly create a data entry form in Excel
Kutools for 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.
Applying the Data Form by clicking Kutools > Data Form. See screenshot:
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.
2. 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.
3. Drag the scroll bar to view the data of the row from up to bottom.
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.
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.
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 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.
The functionality described above is just one of 300 powerful functions of Kutools for Excel.
Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.