Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Calc - how to fill a series from multiple rows that all reference the same row

I have cells in a few rows that all reference one row on another sheet:

=Sheet2.A1
=Sheet2.B1
=Sheet2.C1

When I select these cells and drag the fill handle to fill the cells below, Calc fills them like this:

=Sheet2.A1
=Sheet2.B1
=Sheet2.C1
=Sheet2.A4
=Sheet2.B4
=Sheet2.C4
=Sheet2.A7
=Sheet2.B7
=Sheet2.C7
etc.

I guess it's doing this because each new row is three cells below the original row.

This is not the behaviour I want - I want to fill them in a series, like this:

=Sheet2.A1
=Sheet2.B1
=Sheet2.C1
=Sheet2.A2
=Sheet2.B2
=Sheet2.C2
=Sheet2.A3
=Sheet2.B3
=Sheet2.C3
=Sheet2.A4
=Sheet2.B4
=Sheet2.C4
etc.

Any ideas how to do this?

I'd like to use either a formula or a manual way of doing this - I'm not familiar with macros so would rather avoid if possible, please.