View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fusterated
 
Posts: n/a
Default How do I copy an absolute column and relative row to the right?

I have 75 items in 1 column. The values for the 10 rows to the right are the
same column but different rows each 1 higher than the last.

For instance, C10, C11, C12, C13, etc...

I want to keep C as a constant but have the numbers increase.

Even when I mare the column as a constant and the row as an absolute $C10 it
won't update. It still say $C10 when I copy it.