Excel filling using fill handle

J

JBeaucaire

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.
 
G

Gord Dibben

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

Copy down to return every second cell from column A


Gord Dibben MS Excel MVP
 
Top