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 to view the whole contents of each row, which is too inconvenient and easy to miss data. But with our Advanced 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 clearer, and it also supports the data editor.

Create a data entry form

To enable the feature, click Kutools > View > Advanced Data Form.

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 a specific cell, we need to create a data entry form. Please do as follows.

1. Click on 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 > View > Advanced Data Form, and it opens the Advanced 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 to add a new blank row above the current row. Then, you can click in the textboxes in the Value section to enter new data one by one.
(Shortcut: A)

What’s more, there are additional options you can apply — each supporting keyboard shortcuts for faster access:

• Undo cell, Undo entire row buttons: Used to reset data to its original state.
  - Click Undo cell to undo changes in the current cell. (Shortcut: R)
  - Click Undo entire row to restore the entire row. (Shortcut: E)
• Previous one, Next one buttons: Click to view the previous or next row.
  Shortcuts: P (previous), N (next)
• Previous page, Next page buttons: Click to navigate to the previous or next page of the current sheet.
  Shortcuts: U (previous page), D (next page)
• Delete button: Click this button to immediately delete the current row.
  Shortcut: Q
• Close button: Click this button to exit the Advanced Data Form utility.
  Shortcut: C

Note: Hidden rows and columns cannot be viewed in the Advanced Data Form window.

Demo: Quickly create a data entry form in Excel

Productivity Tools Recommended

Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...

Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...

---

Kutools for Excel

Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.

🌍 Supports 40+ interface languages

✅ Trusted by 500,000+ users and 80,000+ businesses worldwide

🚀 Compatible with all modern Excel versions

🎁 30-day full-featured trial — no registration, no limitations

Try It Now!See PricingUnlock Full Features