Home |
Search |
Today's Posts |
#1
|
|||
|
|||
quicker entry of list rows
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/comm...lic.excel.misc |
#2
|
|||
|
|||
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. "Steve Bold" wrote: 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/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional list without blank rows | Excel Worksheet Functions | |||
Data entry form - Add to list | Excel Discussion (Misc queries) | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
LOOP - Adddress List -to email | Excel Discussion (Misc queries) |