Keeping the column constant in a formula

  • Thread starter Arithmetic functions with embedded text
  • Start date
A

Arithmetic functions with embedded text

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?
 
P

PCLIVE

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"
 
A

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
 
P

PCLIVE

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