Excel filling using fill handle
 

Can you fill down such the cell reference goes from A1 to A3 .

Excel filling using fill handle
 

If there is a formula in cell A1, grabbing the fill handle in the lower right
corner of A1 and pulling it down WILL copy those formulas down to cells A2
and A3. Any cell references that are NOT preceded by $ signs will adjust
themselves accordingly during the fill-down.

Does that answer your question? It was a little vague.


--
"Actually, I AM a rocket scientist." -- JB


"Pete G" wrote:

Can you fill down such the cell reference goes from A1 to A3 .

Excel filling using fill handle
 

In B1 enter =INDIRECT("A"&(ROW()-1)*2+1)

Copy down to return every second cell from column A


Gord Dibben MS Excel MVP

On Tue, 13 Jan 2009 02:41:01 -0800, Pete G <Pete G
@discussions.microsoft.com wrote:

Can you fill down such the cell reference goes from A1 to A3 .