This form option will require our Excel workbook to be saved into SharePoint or OneDrive. If we need a simple data entry form, why not use Microsoft Forms? This will open up a customized data entry form based on the fields in our data. Click on the Form icon in the quick access toolbar area.Select a cell inside the data which we want to create a data entry form with.We can then open up data entry form for any set of data. Press the Add button to add the command into the quick access toolbar.Press F to jump to the commands starting with F. Select Form from the list of available commands.This will open up the Excel option menu on the Quick Access Toolbar tab. Select Customize Quick Access Toolbar from the menu options.Right click anywhere on the quick quick access toolbar.Data Entry FormĮxcel actually has a hidden data entry form and we can access it by adding the command to the Quick Access Toolbar.Īdd the form command to the Quick Access Toolbar. This is a perfect and simple data entry form. When the active cell cursor is in the last cell of the table (lower right cell), pressing the Tab key will create a new empty row in the table ready for the next entry. This will cause the active cell cursor to move to the right instead of down so we can add the next value into our record. We can use the Tab key instead of Enter while entering our data. To add new data into our table we can start typing a new entry into the cells directly below the table and the table will absorb the new data. We now have our data inside an Excel table and we can use this to enter new data.
Make sure the Create Table dialog box has the My table has headers option checked and press the OK button. The Ctrl + T keyboard shortcut will do the same thing. We can also use a keyboard shortcut to create a table.
Press the Table button in the Tables section.Select the range of data including the column headings.They’re perfect data containers and can be used as a simple data entry form. In this blog post, we’re going to explore 5 easy ways to create a data entry form for Excel.