Excel why cant A(row()) replace A1 or A2 to repet formula dn rows

[jimmy]

I want to copy formula down many rows but don't want to have to retype row
numbers at every different row

 

[T. Valko]

I assume you're wanting to "build" a cell reference that increments as you
copy a formula.

Post the formula you want to copy and include a more detailed explanation.

 

[Gary''s Student]

=INDIRECT("A" & ROW(A1))

 

[gls858]

I want to copy formula down many rows but don't want to have to retype row
numbers at every different row

this is the easiest way.

http://www.ehow.com/how_4734730_formulas-down-excel-lightning-fast.html

gls858