Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Absolute and Drag
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Absolute and Drag
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 "vmagal1" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set one cell as a constant so I can drag the formula | Excel Discussion (Misc queries) | |||
How do i drag formulas down | Excel Discussion (Misc queries) | |||
Absolute Reference | New Users to Excel | |||
How can I copy from 1 cell to 30 others | Excel Discussion (Misc queries) | |||
Conditional Formatting for dates | Excel Worksheet Functions |