M
myronschroner
Hi,
I've got a rather complex Excel 2007 spreadsheet that others are going
to be editing, and when they insert rows I would like to have the
columns with formulas in them fill down to the new row.
I know there's a setting in Options to Extend Date Range Formats and
Formulas, but it doesn't seem to work when inserting a row in the
middle of a group. And I don't want to require them to put it at the
bottom and then manually move it to where it should go. And finally,
there's column that would work for sorting either.
I know it can be done if I use a macro, but they need to be able to
Undo, so I don't think macros are an option.
I know they could "copy" and "insert copied rows" or paste special,
but then the integrity of the spreadsheet would rely on them
remembering to do that rather than just insert a row.
Anyone have any ideas?
Thanks in advance!
Myron
I've got a rather complex Excel 2007 spreadsheet that others are going
to be editing, and when they insert rows I would like to have the
columns with formulas in them fill down to the new row.
I know there's a setting in Options to Extend Date Range Formats and
Formulas, but it doesn't seem to work when inserting a row in the
middle of a group. And I don't want to require them to put it at the
bottom and then manually move it to where it should go. And finally,
there's column that would work for sorting either.
I know it can be done if I use a macro, but they need to be able to
Undo, so I don't think macros are an option.
I know they could "copy" and "insert copied rows" or paste special,
but then the integrity of the spreadsheet would rely on them
remembering to do that rather than just insert a row.
Anyone have any ideas?
Thanks in advance!
Myron