Excel 2010 Using Absoloute reference [Closed]

Question

Excel 2010 Using Absoloute reference [Closed]

Report

Mary - Jan 11, 2012 at 04:01 PM
TrowaD

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

- 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!

Excel 2010 Using Absoloute reference
Spell number in excel 2010 indian rupees download ✓ - Forum - Office Software
How to get formula bar in excel 2010 - How-To - Excel
Convert in Indian Rupees. ✓ - Forum - Programming
Spell number in India Rupee - Forum - Office Software
Excel 2010/VB- Loop until no result is found - How-To - Download software

1 reply

Ask a question

TrowaD · Answer 1 · 2012-01-19T10:13:27-0500

Answer 1 / 1

TrowaD

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

454
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

Excel 2010 Using Absoloute reference [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!