Saturday, March 16, 2013

How to Create Input Forms in Excel 2003


1. Open the file you want to modify in Excel 2003. If you have multiple worksheets, go to the worksheet you want to edit.
2. Add column headings to the first row of the spreadsheet. To insert a row, click on the row header for the first row. Right-click and select 'Insert.'
3. Go to cell 'A1' and type a heading for that column. Press the 'Tab' key to advance to the next column.
4. Add column headings to the remaining columns on the worksheet.
5. Highlight the content you want to include in the input form, such as the column headings and any existing content in the spreadsheet.
6. Select 'Data' and 'Form' from the toolbar. If Excel displays a message box, click 'OK' to use the first row for labels. A dialog box for the input form you've created opens.

Blogger news