Insert, Row, or use a "Form" for data entry.
Insert Row doesn't work, as I have summary data off to the right.
Let me know which of the following is the right direction:
I went into Excel Help and looked up Form:
The following got me to a web site:
On the File menu, click New, and then click General Templates.
In the Templates dialog box, click the tab that contains the template
(template: A workbook that you create and use as the basis for other
similar workbooks. You can create templates for workbooks and
worksheets. The default template for workbooks is called Book.xlt. The
default template for worksheets is called Sheet.xlt.) for the form,
and then double-click the template.
If the template for your form is not displayed on one of the tabs,
make sure the template is stored in your Templates folder or one of
its subfolders, or ask your system administrator how to find and use
the form.
=============================================
The following looks like a wrong guess:
Data forms
Excel can generate a built-in data form (data form: A dialog box that
displays one complete record at a time. You can use data forms to add,
change, locate, and delete records.) for your range. The data form
displays all of your column labels in a single dialog box, with a
blank space beside each label for you to fill in data for the column.
You can enter new data, find rows based on cell contents, update
existing data, and delete rows from the range.
Use a data form when a simple form listing the columns is sufficient
and you don't need more sophisticated or custom features. A data form
can make data entry easier than typing across the columns when you
have a wide range with more columns than will fit on the screen at one
time.
=====================================
This looks like a better guess, but so far I haven't gotten it to
work:
A data form is a dialog box that gives you a convenient way to enter
or display one complete row of information, or record, in a range or
list at one time.
Before you can use a data form to add a record to a new range or list,
the range or list must have labels at the top of each column.
Microsoft Excel uses these labels to create fields on the form.
Click a cell in the range or list you want to add the record to.
On the Data menu, click Form.
