Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Inserting row but with formula carried down
When i need to insert a row in my data, i need a formula to be present in the
inserted row. Example: i have a formula in cell c13 that states =sum(a13:b13). if i insert a row that becomes row 14, then i would like the new row to automatically contain the formula in c14 to be sum(a14:b14). I have a spreadsheet with about 25 rows that on any given day can go to 35 or 40 rows and it takes time to copy down the formulas down manually Is this possible ? Thanks Steve |
#2
|
|||
|
|||
Hi
see: http://www.mvps.org/dmcritchie/excel/insrtrow.htm -- Regards Frank Kabel Frankfurt, Germany Steve R wrote: When i need to insert a row in my data, i need a formula to be present in the inserted row. Example: i have a formula in cell c13 that states =sum(a13:b13). if i insert a row that becomes row 14, then i would like the new row to automatically contain the formula in c14 to be sum(a14:b14). I have a spreadsheet with about 25 rows that on any given day can go to 35 or 40 rows and it takes time to copy down the formulas down manually Is this possible ? Thanks Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |