Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically copy formulas down columns or copy formulas all the
is there a way to make excel remember to copy formulas down by itself, so I
don't have to do it when I reach the bottom of how far I copied the first time? or, is there a way to copy the formula down to the bottom (65535, I guess) without taking a performance/size hit? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically copy formulas down columns or copy formulas all the
If you have data in an adjacent column, double-clicking on the fill handle of
the cell with the formula will copy it down as far as the end of data in the adjacent column. Maybe that will do the trick for you? Gord Dibben MS Excel MVP On Fri, 16 Mar 2007 15:22:12 -0700, HowlingBlue wrote: is there a way to make excel remember to copy formulas down by itself, so I don't have to do it when I reach the bottom of how far I copied the first time? or, is there a way to copy the formula down to the bottom (65535, I guess) without taking a performance/size hit? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Skip columns and copy formulas | Excel Discussion (Misc queries) | |||
Automatically copy formulas/functions to inserted rows. | Excel Worksheet Functions | |||
How do I copy formulas but using the same range each time I copy | Excel Worksheet Functions | |||
copy formulas | Excel Discussion (Misc queries) | |||
copy formulas to cells absolute rows and variable columns | Excel Discussion (Misc queries) |