Absolute and Drag

G

Guest

I can't get the formula to drag over and change the last value when using an
absolute reference. I'm linking data from another worksheet and then
changing the cell in the formula bar to D$3 and it still treats it like its
all absolute. Help!
 
C

Chip Pearson

If you drag a cell, Excel doesn't change the reference,
regardless of whether the reference is relative or absolute.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

absolute reference in linked files 3
Change a cell reference from relative to absolute 2
Absolute Reference 4
Excel How to code in excel vba 2007 using absolute refernce for cells 1
Absolute and Relative Cell References 1
Change relative to absolute references in a block of cells 3
Absolute Cell refernce Not working 9
Absolute referencing 3

Top