| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto enter formulas
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? -- Thanks for the brainwaves! CJ I blame the parents........ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto enter formulas
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... "CJ" wrote: 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? -- Thanks for the brainwaves! CJ I blame the parents........ |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto enter formulas
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. "CJ" wrote: 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? -- Thanks for the brainwaves! CJ I blame the parents........ |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto enter formulas
Thanks to both of you. You have confirmed what I thought.
-- Thanks for the brainwaves! CJ I blame the parents........ "Sheeloo" wrote: 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. "CJ" wrote: 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? -- Thanks for the brainwaves! CJ I blame the parents........ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enter info in one sheet, auto enter in another based on one field | New Users to Excel | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| Auto enter date | Excel Discussion (Misc queries) | |||
| Enter name on 1st worksheet and have it auto. enter on all others | Excel Discussion (Misc queries) | |||
| how do I turn ON auto REcalculate for formulas if new data enter? | Excel Worksheet Functions | |||
Linear Mode
