Select the entire list including the header row. Then use Insert, Name,
Define (or the shortcut Ctrl-F3) and type in "database" in the "Names in
workbook" text box and click OK. This assigns that name to the range.
Excel should expand the range automatically when you enter new records via
the form. "database" is a special name Excel looks for.

--
Jim
"wheresleo" wrote in message
...
| Jim,
| thanks for responding, but I don't know what you mean by "assign the name
| database to the list. I don't know how to do that. And the answer is yes,
| that I'm referring to the excel's data.
|
| "Jim Rech" wrote:
|
| If you referring to Excel's Data, Form feature if you assign the name
| "database" to the list you do not have to select the list to use it with
| Data, Form.
|
| --
| Jim
| "wheresleo" wrote in message
| ...
| | Once I have created a form (for entering data in a spreadsheet)...is
there
| a
| | way to save the form for future use to avoid having to choose the
columns
| | each time I want to enter data?
|
|
|