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.
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.
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.
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.