LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
mulkdog
 
Posts: n/a
Default Unmovable absolute reference

Hi, I'd like to be able to refer to a true, completely unmovable / static
absolute reference. My example:

I have a 2x6 range (six months in right-to-left, with a figure for each)
that is the source data for a simple bar graph. The current reference is
A1:B6. Each month I'd like to insert a new first column but keep the
reference A1:B6.

Currently Excel automatically changes the reference to A2:B7 when I insert
the column - even if I use $A$1:$B$6 to refer to the range. (Excel's help
files acknowledge that inserting a row will modify even absolute ranges.) Is
there any way to have a TRUE absolute range?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 2 April 30th 23 07:42 PM
absolute reference Dano Excel Discussion (Misc queries) 2 May 13th 05 03:33 PM
changing multiple cells from relative to absolute reference Mike Excel Discussion (Misc queries) 4 March 10th 05 02:11 PM
absolute reference Dano Excel Discussion (Misc queries) 1 February 25th 05 09:28 PM
Absolute Reference DME Excel Worksheet Functions 3 November 12th 04 03:16 PM


All times are GMT +1. The time now is 01:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"