Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jun 2004
    Location
    Itasca, Illinois, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Absolute to relative references (Excel 2003)

    Is there a way to change cell references from absolute to relative (or vice versa) on multiple cells at once. As an oversimplified example, I would like to be able to highlight a series of cells and hit the F4 key. I want to avoid having to go into each formula individually to make the change. All of the formulas are referencing external workbooks.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Absolute to relative references (Excel 2003)

    See <post#=173133>post 173133</post#> for some code

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    199
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Absolute to relative references (Excel 2003)

    Hi,

    ASAP Utilities is a free addin and does this as well as a heap of other stuff, check it out at:

    www.asap-utilities.com

    Good Luck!

    Peter Moran

  4. #4
    New Lounger
    Join Date
    Jun 2004
    Location
    Itasca, Illinois, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Absolute to relative references (Excel 2003)

    The ASAP Utility is amazing. It works perfectly changing a block of cell formulas from relative to absolute (including multiple references within a formula). I am looking forward to checking out the other features.

    Thanks Peter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •