how fill formular?
 

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 EditFillSeries, 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.

how fill formular?
 

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

"Mike H" wrote:

Hi,

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

=12*(ROW(A1)-1)

Mike

"Ian Elliott" wrote:

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 EditFillSeries, 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.

how fill formular?
 

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)

--
Biff
Microsoft Excel MVP


"Ian Elliott" wrote in message
...
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 EditFillSeries, 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.

how fill formular?
 

Hi,

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

=12*(ROW(A1)-1)

Mike

"Ian Elliott" wrote:

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 EditFillSeries, 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.

how fill formular?
 

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


"Ian Elliott" wrote:

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 EditFillSeries, 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.

how fill formular?
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Ian Elliott" wrote in message
...
Those all worked. Thanks very much Mike H and T. Valko!


"Ian Elliott" wrote:

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 EditFillSeries, 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.