Filling issues

  • Thread starter Thread starter Stumped
  • Start date Start date
S

Stumped

Hello All,

Is there a way to change how Excel fills a series? Currently, it is set to
keep the numeric portion of the cell reference static and go A-Z as it fills
to the right. Is there a way to keep the alpha static and decrease the
numeric filling to the right?

Thanks
 
If you meant, in say Sheet1, to link to:
=Sheet2!C3
=Sheet2!C2
=Sheet2!C1
in 3 consecutive horiz cells from left to right

you could use this in any start cell in Sheet1, say in B2:
=INDEX(Sheet2!$C$1:$C$3,COLUMNS($A:$C)-COLUMNS($A:A)+1)
then copy across to D2. Adapt to suit.
 
Back
Top