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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Relative" Absolute Cell References in Excel 2007
Hi Theoden,
In some cell (let's say A1), put this text: D2:F2 Now use this formula (example is SUM): =SUM(INDIRECT(A1)) -- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message ... |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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Relative" Absolute Cell References in Excel 2007
Try:
=SUM(INDIRECT("D2:F2")) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Relative" Absolute Cell References in Excel 2007
=SUM(INDIRECT("D2:F2")) Thank you for the help. Amazing how easy it is when you know how! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Relative" Absolute Cell References in Excel 2007
Thanks for the feed-back.
-- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- wrote in message ... =SUM(INDIRECT("D2:F2")) Thank you for the help. Amazing how easy it is when you know how! |
Reply |
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 |