copy formulas down non- adjacent columns?

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I want to copy formulas down columns. The columns have
two non-formula columns beteween them. Can I select the
non-adjacent columns and drag the formulas down?
 
Hi Todd,
I guess not since the fill-handle disappears, but you
can extend the selection of your multiple cells downward
and then use Ctrl+D though it might have been just as
easy to use fill handle one at a time.

However this might save you some time
in the namebox to the left of the formula bar
E2:E200, G2:G200, K2:g200
assuming you had something in row 2 for each column,
then use the Ctrl+D

You could use a defined name, anything with a range that
you can fill down on.
 
Back
Top