Excel 2007: Insert Row into Defined Area & Inherit Above Formulas

A

Andrew Gill

I swear that prior to Excel 2007, if you inserted above a range of cells with
formulas that the new row was not totally blank - it fill-copied down the
inherited (from row above) formula.

Am trying to do the same in 2007. Have an input template defined on a
protected spreadsheet where the user enters some data and there are automatic
calculations. If during Sheet protection I allow the user to be able to
insert rows, it inserts a row and maintains the cell fill color, but does not
copy down the cell formula from the row above.
 
S

Sheeloo

:)

Excel 2003 also does NOT copy the formula. Formatting is inherited in the
new row but not the formulas.

You need to use a macro to do this.
 
A

Andrew Gill

Thanks. Anyone have a good macro for this?

Sheeloo said:
:)

Excel 2003 also does NOT copy the formula. Formatting is inherited in the
new row but not the formulas.

You need to use a macro to do this.
Click to expand...
 
S

Sheeloo

I have seen a few on this forum...

You can have a insert button which will insert a new row and copy the
formulae from the row above...

Let me know if you are unable to find a solution.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas Affected by Insert Row 7
insert blank row and formulas 1
Insert row with a locked cell 1
using the =page! feature to transpose a row to column 0
Repeating formulas when inserting new row 3
Changes in How Code Acts After Upgrade of Excel 2
Insert/ delete row in protected worksheet 7
Insert Copied Rows or Drag/Drop Formulas While Protected 2

Top