Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formular | New Users to Excel | |||
I still need help with formular? | Excel Worksheet Functions | |||
formular | Setting up and Configuration of Excel | |||
If formular | Excel Discussion (Misc queries) | |||
Need Help With A Formular | New Users to Excel |