Auto enter formulas

C

CJ

Hi Groupies:

In Excel 2003 I have a list of data with formulas in column G.
If I insert a new row between 2 rows that already have formulas, is there a
way for Excel to automatically enter the formula in the new row, or is this
only possible if the data is set up as a list?
 
S

Sean Timmons

Not sure if it would be better or worse, but you coudl always copy one of the
existing rows and insert copied cells insetad of inserting a blank row.

Other than that, pretty sure Excel will truly enter a blank row, so you'd
have to copy and paste...
 
S

Sheeloo

Excel does not copy the formula to the cell in the inserted row.

You need to enter the fourmula in the new cell either manually or through a
macro...

If you do it often then you may record a macro while you perform the actions
once and then run that macro anytime you need it.
 

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

Excel Help to copy information from one row at a time to another sheet 1
Auto Fill formula when inserting a new line 4
Saving Formulas when addin rows 8
Microsoft Excel - Automatically Extending Formulas 2
Automatically copy formulas in selected row into a new row? 3
how do I insert row keeping formulas from previous row? 1
Creating a Unique List 5
Excel keeps copying formulas into other cells!! 2

Top