Close button: click this button to exit the Data Form utility.Delete button: click this button to immediately delete the current 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.Previous one, Next one buttons: click to show the data in the preview or next row.If you click the Undo entire row button, the entire row will be restored back. If you click the Undo cell button, the changes you made in current cell will be undone. Undo cell, Undo entire row buttons: these two buttons are used to reset data to the original data.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. 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.What’s more, there are more options you can apply:
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. 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.ĥ.
Then apply this feature by clicking Kutools > Data Form, and it opens the Data Form dialog box.ģ. Click at a cell or a range of the table that you want to create a data entry form.Ģ.
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. Supposing, you have a big table with multiple columns of data as the below screenshot shows. 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.Ĭreate a data entry form Click Kutools > Data Form to enable the feature. 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.
0 kommentar(er)
