Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Relative" Absolute Cell References in Excel 2007
I have a worksheet that has a formula which uses absolute cell
references ($D$2:$F$2). If I insert a new column to the left of Column D the "absolute" references change to ($E$2:$G$2). What I want is to add data to the new column and have the formula calculate on the original ($D$2:$F$2) range. Rather than changing the formula every time I do this (and copying it down several hundred rows) is there a way to get around this 'feature' and have the absolute reference stay absolute? Thanks for any insight, Theoden |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying formulas, relative and absolute cell references | Excel Discussion (Misc queries) | |||
Relative (vs. Absolute) Cell References with macros | Excel Discussion (Misc queries) | |||
A "relative" absolute cell reference? | Excel Discussion (Misc queries) | |||
cell references increase by 3 per row "=I1" then "=I4" | Excel Discussion (Misc queries) | |||
F4 key does not toggle relative/absolute cell references. | Excel Worksheet Functions |