Previous Topic Next Topic

Excel 2010 Using Absoloute reference

Closed
Mary - 11 Jan 2012 à 16:01
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 19 Jan 2012 à 10:13
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!



Related:

1 response

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
19 Jan 2012 à 10:13
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

Similar discussions

Product Key for Publisher 2010
SeriDahari -
jack4rall -

1 response