View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] ridermark@gmail.com is offline
external usenet poster
 
Posts: 2
Default "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