Current sheet: all data of the active sheet will be displayed in the window.Ĥ.Current range: only the data in the selected range will be displayed in the window.By default, if you choose one cell, this option will be selected. Current range of active cell: the current range of the active cell will be displayed in the window.Click the drop-down list of Scope to set the working scope. 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.