Auto enter formulas

  • Thread starter Thread starter CJ
  • Start date Start date
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?
 
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...
 
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
Use macro to write formula 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Auto Fill formula when inserting a new line 4
Copying a formula with an increase of more than 1 6
Help needed 0
Inserting new rows, which contain the formula in the above the new 5
Formula Extend in Excel 2007 1

Back
Top