How to Create a Form in Excel 2007
- 1). Open the Microsoft Excel 2007 application on your computer. Click on the "Microsoft Office" button and then click on the "Open" option.
- 2). Locate the Excel 2007 file stored on your computer for which you want to create a form. Select the file so that it's highlighted, and then click on the "Open" button.
- 3). Add any column headers to the columns within the table of data in your 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 then click on the "More Commands" option. Click on the "All Commands" option and then click on 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 the "Enter" key on your keyboard.
- 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 the "Enter" key and the row will be updated on the form and in your spreadsheet.
Source...