A "form" for feeding an Excel Sheet?

[DeeDeeCee]

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

 

[Dave Peterson]

In xl2003 and below, maybe you could use Data|Form

 

[DeeDeeCee]

The name sounds promising--how do you use it?

In xl2003 and below, maybe you could use Data|Form

 

[Dave Peterson]

Select your range
Data|Form

The name sounds promising--how do you use it?

 

[challa prabhu]

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