The Excel data entry form is a built-in dialog that shows one row of a table as a set of labelled boxes, so you type a transaction field by field and press Enter to save it. It is free but hidden: you add its Form button to the Quick Access Toolbar, then open it from any table with headers.
What is the Excel data entry form, and where is it hidden?
The Excel data entry form is a dialog box that turns each column header into a labelled text box and saves your entries as a new row at the bottom of the table. Microsoft no longer shows it on the ribbon, so you add a Form button yourself before you can use it.
Microsoft's article on adding, editing, finding and deleting rows with a data form gives the steps. In short:
- Click the arrow next to the Quick Access Toolbar and choose More Commands.
- In "Choose commands from", pick All Commands.
- Scroll to Form, select it, click Add, then OK.
- Click any cell inside your table, then click the new Form button.
The button stays on the toolbar for every workbook afterwards, so this is a one-time job. Microsoft's article lists Excel for Microsoft 365 and Excel 2016 through 2024. It does not mention Excel for the web, so if you work in a browser, check for the button before you plan around it.
Why bother with a dialog when the grid is right there? Because a statement transaction has four or five fields, and the grid makes it easy to type the amount into the balance column or start a new row one line too low. The form shows only the record you are on. You cannot drift into the wrong cell, because there are no other cells on screen.
Building the transaction table behind the data entry form
The data entry form reads its labels from the header row, so the table comes first. Give every column a short, distinct header, keep the range free of blank rows, and put any formulas to the right of the typed columns. A clean header row is all the form needs to build its boxes.
A layout that suits a bank statement looks like this. The values in the last column are examples.
| Column | Header | What you type | Example entry |
|---|---|---|---|
| A | Date | Posting date from the statement | 03/14/2026 |
| B | Description | Payee text, shortened if you like | FLOUR SUPPLY CO |
| C | Amount | Signed amount, debits negative | -412.80 |
| D | Category | Your own category name | Supplies |
| E | Balance check | A formula, not typed | (computed) |
A few rules from Microsoft's article shape this table. The range must not contain blank lines, or the form stops at the gap. The form holds up to 32 columns, which a statement never needs. A column that holds a formula appears in the form with its result shown, but you cannot edit it there. That suits the Balance check column: it fills itself as each record is saved.
For the balance check, put the opening balance in a cell above the table, say E1, and in E3 write a formula that adds the first amount to it. Each row below adds its own amount to the row above. When the computed balance matches the printed one on the statement, every row so far is right.
The Category column works better if you settle the names before you start. Typing "Groceries" on one row and "Grocery" on the next splits one category into two. A fixed list such as the one in a budget categories list built from real statement rows gives you names to type the same way every time.
Typing a month of statement records in the Excel form
Typing in the Excel form follows one rhythm: click New, type a field, press Tab to move down, and press Enter to save the record. Shift+Tab moves back a field. Microsoft's article confirms that Enter saves the row and adds it to the bottom of the table, ready for the next record.
Here is a worked example. The statement, the row count and the timings are illustrative, not measurements.
You have a checking statement with 45 transactions for March. You set the PDF on the left half of the screen and Excel on the right, with the form open.
- Click New. The boxes clear.
- Type the date, press Tab, type the description, press Tab, type the signed amount, press Tab, type the category.
- Press Enter. The record drops into the table and the form clears for the next one.
- Every ten records, glance at the Balance check column in the grid behind the form and compare it with the statement's printed balance on that line.
At an example pace of 25 seconds a record, 45 records take about 19 minutes. The form adds a second or two per record over typing in the grid, because of the extra Enter and New. What you get back is fewer placement errors: no amount typed into the date column, no record started on the wrong row.
If you change your mind about a record before pressing Enter, the Restore button puts the boxes back to what they were. After Enter, the record is in the table, and you fix it by finding it again.
Finding a typed transaction with the form's Criteria button
The Criteria button turns the data entry form into a simple search. You click it, type what you are looking for into any box, and Find Next jumps to the first matching record. It is a quick way to check a single transaction without scrolling the table.
Matching works on the start of the text. Microsoft's example is that "Dav" finds both "Davidovski" and "Davis". The wildcards ? and * work too, for one character and any number of characters. For statement work that means:
- Type "FLOUR" in Description to step through every payment to that supplier.
- Type a date in Date to find what you entered for one day.
Once you are on the record, edit the box and press Enter to save the change. Delete removes the record, and Microsoft warns that a deletion cannot be undone once you confirm it. On a statement sheet, delete with care: a missing row breaks the balance check for every row below it, which at least tells you something went.
Excel data entry form limits for statement work
The Excel data entry form is a plain tool with real limits. It has no drop-down lists, it shows formulas but will not let you edit them, it cannot be printed, and a deleted record is gone for good. It also cannot read a PDF: every digit still passes through your fingers.
The limits that matter most when typing statements:
- No drop-downs in the form itself. Category names are typed freehand. Rules set on the table's cells, such as a list of allowed categories, are the way to catch spelling drift. The guide to Excel data validation rules for data entry typos covers date, amount and list rules for each column; test whether your version applies them to form entries on a spare row.
- One record at a time. That is the point of the form, but it means no copying a block of rows from somewhere else.
- Modal dialog. While the form is open you cannot work in the sheet. Close it to fix a formula.
- Desktop only, as far as Microsoft's article says. Plan for the desktop app.
If you prefer to type on a phone or share entry with someone else, a form that writes into a shared sheet is the closer fit. Google Forms data entry into Sheets for transactions walks through that route, with response validation built into the form itself.
When is the Excel data entry form slower than typing in the grid?
The Excel data entry form is slower than the grid whenever the data already exists as text you could copy, or when you type fast enough that the extra keys per record cost more than the errors they prevent. It is a typing aid, and the cheapest record is the one you never type.
Skip the form in these cases:
- The PDF has selectable text. If you can highlight the statement's lines, copying them into Excel and splitting them into columns beats retyping. The steps and the cleanup are in how to copy a PDF into Excel and fix the paste.
- You only need a few rows. Three payments to one vendor take less time in the grid than opening the form.
- You are fixing, not entering. Editing 20 categories at once is a filter-and-fill job in the grid.
- The statement is long. At 25 seconds a record, a 200-row business statement is about 83 minutes of typing before any checking.
For that last case it helps to put a price on your time. At an example rate of $25 an hour, 83 minutes is about $34.58. CheapBankConvert's early pricing lists $2.99 for a statement of up to 10 pages and $5.99 for 11 to 40 pages, with the first 2 pages previewed free so you can see the rows before paying. It is not open yet, and you would still compare the converted totals with the statement. If that trade looks better than an evening with the form, get started and you will hear when it opens.
The form earns its place on paper records, handwritten notes and statements that exist only as photos, where there is no text to copy. For those, set up the table once, add the Form button once, and let the dialog keep your place while you type.