how fill formular?

[Ian Elliott]

Thanks for any help.
I would like to have a series of rows with formulas:
=12*0
=12*1
=12*2
till about =12*20
I could do this by hand, and it would only take a couple of minutes, but is
there a way to do by automation?
I know about the Edit>Fill>Series, but this would only show the values, not
the formula behind it, and I want the next user (or me, if I look at it in
the future) to understand why it is. Of course, I could do:
=12*A1
=12*A2
etc
where A1 has 0, A2 has 1, but I don't want to have to reference another cell
if necessary.
Thanks again.

 

[Mike H]

Here's another way

Select a column of 21 cells and enter the formula

=ROW(1:21)*12-12

IMPORTANT - Enter this as an array as follows

This is an array formula which must be entered with CTRL+Shift+Enter and NOT
'just enter. If you do it correctly then Excel will put curly brackets around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array

Mike

 

[T. Valko]

Try this...

Assume you want the results to appear starting in cell C1.

Enter this formula in C1 and copy down to C21 ( "till about =12*20" ):

=12*(ROWS(C$1:C1)-1)

 

[Mike H]

Hi,

You could put the formula below in a cell and drag down as required

=12*(ROW(A1)-1)

Mike

 

[Ian Elliott]

Those all worked. Thanks very much Mike H and T. Valko!

 

[T. Valko]

You're welcome. Thanks for the feedback!