Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill formula when inserting a new line
I had someone show me this and I do not know how to set it up to work
like we saw. If I have a column of data and a formula in the column next to when he inserted a new row at the end of the formulas, the new row would contain a copy of the formula incremented from the row above. Just like clicking on the box in the lower right hand corner of a cell and dragging it down. I am always inserting new lines and have to continually go out and drag my formulas down to the new row. There are now macros running, I am on XP and Excel 2007 Thanks Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible to auto-fill in gaps between numbers on straight line bas | Excel Worksheet Functions | |||
Auto fill formulae when inserting rows | Excel Discussion (Misc queries) | |||
Inserting line breaks in text formula | Excel Discussion (Misc queries) | |||
auto update formula when inserting additional columns | Excel Worksheet Functions | |||
Auto formula fill | Excel Discussion (Misc queries) |