Excel 2010 Using Absoloute reference

[Closed]
Report
-
Posts
2807
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 21, 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
2807
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 21, 2021
483
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