View Single Post
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

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