How to Create a Form in Excel 2007

1. Open the Microsoft Excel 2007 application. Click the “Microsoft Office” button and select “Open.”
2. Locate the Excel 2007 file stored on your computer for which you want to create a form. Select the file and click on the “Open” button.
3. Add any column headers to the columns within the spreadsheet. Click on any cell in the data table where you want to add the form.
4. Click on the arrow next to the Quick Access Toolbar and click on the “More Commands” option. Click on the “All Commands” option and select the “Form” button from the list.
5. Click on the “Form” button from the Quick Access Toolbar. The data form will appear as a dialog box within the spreadsheet.
6. Click on the 'New' button within the data form dialog box if you want to enter data for a new row. Enter the data into the new field that appears in the dialog box and the press 'Enter.'
7. Click on the 'Find Next' or 'Find Prev' buttons to navigate to each row in the data form dialog box. Click on the 'Criteria' button to enter any data you want to search for within the form.
8. Change data in a row in the data form dialog box by clicking on any row and entering the new data. Press 'Enter' and the row will be updated on the form and in your spreadsheet.