Excel 2010 Using Absoloute reference [Closed]

Report
-
Posts
2691
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 14, 2021
-
Hello,

Hello,

I would really appreciate if you could help me out, I'm trying to copy a forumula using the $ absolute referencing. My column is as follows:
Jan =$c46
Feb =$D46
Mar =$E46
etc
I've tried the $ in different positions, to try to keep the columns to change and the rows to remain the same, no luck. any suggestions. I know this should be really easy!

Thank you so much for your time and effort!



1 reply

Posts
2691
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 14, 2021
454
Hi Mary,

The $ symbol makes it absolute, which means no change will be made when dragging a cell.

You want the row to remain the same, so put the $ symbol in front of the row number: = C$46.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!