Thread: Keeping the column constant in a formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Arithmetic functions with embedded text[_2_] Arithmetic functions with embedded text[_2_] is offline
external usenet poster
  
Posts: 2
Default 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?




Reply With QuoteReply With Quote