Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping the column constant in a formula
I am trying to drag a formula in a row while keeping the source column
constant and incrementing the column number... A B C 1 1.1 2 2.2 3 3.3 4 4.4 5 6 =A1 =A2 =A3..... I know how to use the $ to keep the row from changing, but how do you keep the comlumn constant? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping the column constant in a formula
You do it the same exact way.
A$1 will keep the row constant. $A1 will keep the column constant. $A$1 will keep both the row and column constant. HTH, Paul "Arithmetic functions with embedded text" icrosoft.com wrote in message ... I am trying to drag a formula in a row while keeping the source column constant and incrementing the column number... A B C 1 1.1 2 2.2 3 3.3 4 4.4 5 6 =A1 =A2 =A3..... I know how to use the $ to keep the row from changing, but how do you keep the comlumn constant? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping the column constant in a formula
One way ..
In A6: =INDEX($A$1:$A$5,COLUMN(A1)) Copy A6 across to E6 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Arithmetic functions with embedded text" wrote: I am trying to drag a formula in a row while keeping the source column constant and incrementing the column number... A B C 1 1.1 2 2.2 3 3.3 4 4.4 5 6 =A1 =A2 =A3..... I know how to use the $ to keep the row from changing, but how do you keep the comlumn constant? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping the column constant in a formula
When I use the $ in front of the column, $A1, and drag it across a row, both
the row and the column are kept constant "PCLIVE" wrote: You do it the same exact way. A$1 will keep the row constant. $A1 will keep the column constant. $A$1 will keep both the row and column constant. HTH, Paul "Arithmetic functions with embedded text" icrosoft.com wrote in message ... I am trying to drag a formula in a row while keeping the source column constant and incrementing the column number... A B C 1 1.1 2 2.2 3 3.3 4 4.4 5 6 =A1 =A2 =A3..... I know how to use the $ to keep the row from changing, but how do you keep the comlumn constant? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping the column constant in a formula
That is because you are dragging it across which means you are still in same
row. Are you saying that when you drag across, you'd like the Row number to increment? "Arithmetic functions with embedded text" icrosoft.com wrote in message ... When I use the $ in front of the column, $A1, and drag it across a row, both the row and the column are kept constant "PCLIVE" wrote: You do it the same exact way. A$1 will keep the row constant. $A1 will keep the column constant. $A$1 will keep both the row and column constant. HTH, Paul "Arithmetic functions with embedded text" icrosoft.com wrote in message ... I am trying to drag a formula in a row while keeping the source column constant and incrementing the column number... A B C 1 1.1 2 2.2 3 3.3 4 4.4 5 6 =A1 =A2 =A3..... I know how to use the $ to keep the row from changing, but how do you keep the comlumn constant? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiplying a column of data by a constant | Excel Discussion (Misc queries) | |||
Keeping cell references constant | Excel Discussion (Misc queries) | |||
keeping a shape constant regardless of changes in variables | Excel Discussion (Misc queries) | |||
Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
Right Filling A Formula Whilst Keeping A Static Column | Excel Discussion (Misc queries) |