ExcelBanter - Data Forms in Excel 2002

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - Data Forms in Excel 2002 (https://www.excelbanter.com/setting-up-configuration-excel/4982-data-forms-excel-2002-a.html)

Data Forms in Excel 2002

Hello helpers
I am quite new to excel . I use excel 2002 . Can someone please tell me how
to open or set up fields where I can type addresses quickly into the current
database? I seem to remember some years ago this feature was already there ?
I believe they are called Data Forms?
Thanks Kez

Kez

DataForm

Same as previous versions.

In top row have titles in separate cells for Name, Address, Phone etc.

Select a range you know will be large enough, say A1:G500 and name it
"DataBase"(no quotes)under InsertNameDefine.

Select a cell anywhere in that range and DataForm.

Start typing.

Gord Dibben Excel MVP

On Wed, 8 Dec 2004 19:43:24 -0000, "kez" wrote:

Hello helpers
I am quite new to excel . I use excel 2002 . Can someone please tell me how
to open or set up fields where I can type addresses quickly into the current
database? I seem to remember some years ago this feature was already there ?
I believe they are called Data Forms?
Thanks Kez