Filling a reference series in alphabetical order, not numerical
 

I need to fill formulas from another worksheet as following: B29, C29, E29,
F29, etc... Instead, Excel fills the series as follows: B29, B30, B31, B32,
etc... I wanted to know how to change the sequence.

Filling a reference series in alphabetical order, not numerical
 

If B29 etc are cell references, then try:
=INDIRECT(ADDRESS(29,ROW(A2)))
and drag down


"maub" wrote:

I need to fill formulas from another worksheet as following: B29, C29, E29,
F29, etc... Instead, Excel fills the series as follows: B29, B30, B31, B32,
etc... I wanted to know how to change the sequence.