View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tonefbr tonefbr is offline
external usenet poster
 
Posts: 5
Default 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