Keeping the column constant in a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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"
 
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
 
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"
 
Back
Top