copy formulas down non- adjacent columns?

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?
 
D

David McRitchie

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top