When I make a row absolute, but column relative, the column stays.
I am trying to copy a formula using the fill option. When i set the column
in the range to relative and the row to absolute, the columns and rows in the
range saty the same. I thought that the dollar sign was supposed to allow
the range to change in sequential order
|