Thread: Copy the formula by dragging but down but calculate by going left
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
F.G. F.G. is offline
external usenet poster
  
Posts: 28
Default Copy the formula by dragging but down but calculate by going left
Hi,

If I enter the formula:
=$C$1-E75 and copy down by dragging the column will remain E and the rows will change to 76,77,78 etc.

I need the opposite so when I drag down the row remains 75 but the column changes to F, G, H ...

I hope that my request was clear.

If that is possible please let me know.

Thank you in advance.

Regards,
Frank Gashi
CUNY
Reply With QuoteReply With Quote