Excel Forms
 

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?

Excel Forms
 

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?

Excel Forms
 

When you have it in the format you want, select File, Save As, and in the
"Save as Type" box select "Template(*.xlt)" and assign the file name you
want and the Directory you want to save it in.
"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?

Excel Forms
 

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?

Excel Forms
 

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?
|
|
|