View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FSPH FSPH is offline
external usenet poster
 
Posts: 12
Default Copying a formula while leaving one cell fixed

Hi there,

I forgot how to leave one cell fixed while copying a formula down a column.

For example,
"=RC[-3]*R[-45]C[-5]"
should read
"=RC[-3]*R[-46]C[-5]"

I recall using a Dollar sign ("$") to hardwire a cell in a formula. My
formula should then read "=RC[-3]*$R9$C3"

However, this doesn't seem to work.

Thank you for your help.