A "form" for feeding an Excel Sheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Access you can create a "form" with fields conveniently arranged on a
page, and you can then tab through them as you enter data. Is there any
counterpart in Excel so that you can set up the form to group some fields
together, or in an efficient order, and enter data quickly? Thanks.
dc
 
Hi,

Do the following;

1. Enter coulmn header for each column.
2. Select the column headers.
3. On the Data menu, click Form.
Microsoft Excel dialpays a dialog box with the following information:
'Microsoft Office Excel cannot determine which row in your list or
selection contains column labels, which are required for this command." Click
OK.
4. Based on the Sheet tab where you want to enter the data value, the
appriate sheet tab dialog box, with all the heaser information is displayed
as rows .
5. Enter values for cloumn header and press New. This will add the
information in the excel and creates a empty form for you to add a new row.
After entering the data in each column header, click close to close the
doalog box to return to the current worksheet.

Challa Prabhu
 
Back
Top