Excel Forms

W

wheresleo

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

Jim Rech

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

Paul Dusterhoft

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.
 
W

wheresleo

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.
 
J

Jim Rech

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