Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slight problem automating Excel in a service | Setting up and Configuration of Excel | |||
Excel Forms | Excel Discussion (Misc queries) | |||
Excel Forms - text fields decompressing font automatically | Excel Discussion (Misc queries) | |||
Can I create custom forms to add data to a Excel Spreadsheet? How. | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |