How to Create the Input Form on Excel 2007

1. Plan your worksheet. Think about the type of information you will be keeping in the spreadsheet and set up your columns.The column headers will be used as the form labels next to the input boxes.
2. Set up your spreadsheet. Type in the column headers. Set the column lengths. Do not merge any cells in the column headers. Excel will not be able to generate an input form from merged cells. You can always make the columns bigger by changing the column width property.
3. Add the Form button to the Quick Access toolbar. Click the drop-down arrow on the Quick Access toolbar and then click 'More Commands.' A dialog box appears. Click the drop-down under 'Choose commands from:' and choose 'All Commands.' Stroll through the list and find 'Form.' Highlight 'Form' and click 'Add,' then click 'OK.' The Form button is now in your Quick Access toolbar.
4. Highlight the column headers. Click on the 'Form' button in the toolbar. Excel will generate an input form that will allow you to enter in new information into the columns. Notice your column headers on the left-hand side of the input form next to the text boxes.