quicker entry of list rows

[Steve Bold]

If a cell within a list contains a formula, when a add a new row to the list
#I typically want the formula copied to the new row. While this is not hard
to do it gets repetitive.

I'd like either for Excel to auto-copy formulae when entering a new row
within a list or to have an option to choose columns within a list that are
to be auto-copied.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...2-6ab7d08eb8f8&dg=microsoft.public.excel.misc

 

[Bryan Hessey]

This would be OK where formula apply across the row.
Where formula apply to a preceeding row (ie, carry down a balance) then the
following row will need to be amended also (it currently retains it's now
preceeding row reference), and where a formula apples to a following row, or
a number of following rows then this could become something of a problem.