Excel 2010 Using Absoloute reference

Closed
Mary - Jan 11, 2012 at 04:01 PM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Jan 19, 2012 at 10:13 AM
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

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
Jan 19, 2012 at 10:13 AM
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
0