How to Create a Form in Microsoft Excel 2007

By Paul Knorr

Microsoft Excel includes a feature that generates a data entry style form based on a range of cells. This feature makes it easier to enter data and also makes it easier to locate a specific record in a long list. The Forms feature still exists in Excel version 2007, but the button for it is not visible by default.

Things You'll Need

  • Microsoft Excel 2007

Step 1

Launch Excel from the start menu or from the desktop. Click the small drop-down arrow at the very top of the screen, to the right of the Save, Undo, and Re-do buttons. In the menu that appears, choose “More commands.” The Excel Options screen should appear.

Step 2

In Excel Options, click the drop-down at the top of the left-hand list of commands, labeled “Choose commands from.” In the list that drops down, choose “All commands,” which is the third item down from the top. In the list box below the drop-down, a long list of commands will appear, sorted alphabetically. Locate the command named “Forms,” click on it, and click the “Add” button in the center of the screen. Click "OK" to close the Excel Options screen, and the Forms button will appear next to the Re-do button at the top of the screen.

Step 3

Open the spreadsheet with the rows that are to be viewed in forms. Click on a cell that is in the list of data the form is to be for. It can be a heading cell or any cell within the data. Click on the Forms button that was added in step 1. Excel will automatically create the form.

Tips & Warnings

  • Make sure that every column has a column heading–Excel will use these headings as the field labels in the form it creates. Also make sure that there are no blank rows in the data.
  • Excel will consider a blank row as the end of the list, even if there are thousands of more rows after the blank one.
  • Clicking Delete in an Excel form will delete the row from the spreadsheet. This cannot be undone.