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

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



DeeDeeCee wrote:

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

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

"Dave Peterson" wrote:

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



DeeDeeCee wrote:

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

Select your range
Data|Form


DeeDeeCee wrote:

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

"Dave Peterson" wrote:

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



DeeDeeCee wrote:

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


--

Dave Peterson

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


"DeeDeeCee" wrote:


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