Using a form for data entry

Excel 365 2013 2010
Sometimes you need to manage lists where the information is arranged in rows. Excel offers a simple way to work with this big data in rows.

Unfortunately, the command to access the data form is not on the Ribbon, but you can do one of the following:

To use the data form, follow these steps:

   1.   Select data with headers of the columns in the first row of your data range:

Data in Excel 2016

   2.   Click the Form button on your own menu or in Quick Access toolbar. Excel displays a dialog box customized to your data:

Form in Excel 2016


  • To move between the text boxes, press Tab.
  • You can't modify formulas using the data entry form - the formula result appears as text, not as an edit box:
    Formula in Excel 2016
  • To add a new row to your table, click the New button.
  • You can also use the form to edit the existing data.

See also this tip in French: Comment utiliser un formulaire pour la saisie de données.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more