Page 1 of 3 123 LastLast
Results 1 to 15 of 32
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi,

    Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active cell. I want to select multiple formulas and have all the refs in the formula convert to absolute.

    Any help will be appreciated.

    TX
    Regards,
    Rudi

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi,

    Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active cell. I want to select multiple formulas and have all the refs in the formula convert to absolute.

    Any help will be appreciated.

    TX
    Regards,
    Rudi

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi,

    Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active cell. I want to select multiple formulas and have all the refs in the formula convert to absolute.

    Any help will be appreciated.

    TX
    Regards,
    Rudi

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi,

    Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active cell. I want to select multiple formulas and have all the refs in the formula convert to absolute.

    Any help will be appreciated.

    TX
    Regards,
    Rudi

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi,

    Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active cell. I want to select multiple formulas and have all the refs in the formula convert to absolute.

    Any help will be appreciated.

    TX
    Regards,
    Rudi

  6. #6
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi,

    Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active cell. I want to select multiple formulas and have all the refs in the formula convert to absolute.

    Any help will be appreciated.

    TX
    Regards,
    Rudi

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi,

    Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active cell. I want to select multiple formulas and have all the refs in the formula convert to absolute.

    Any help will be appreciated.

    TX
    Regards,
    Rudi

  8. #8
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi,

    Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active cell. I want to select multiple formulas and have all the refs in the formula convert to absolute.

    Any help will be appreciated.

    TX
    Regards,
    Rudi

  9. #9
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Doorn, Netherlands
    Posts
    311
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Rudi,

    Get yourself the free ASAP Utilities (http://www.asap-utilities.com/downlo...-utilities.php). Under Formulas there is the utility to change the reference mode for a selected number of cells containing formulas.

    Regards, Teunis

  10. #10
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Doorn, Netherlands
    Posts
    311
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Rudi,

    Get yourself the free ASAP Utilities (http://www.asap-utilities.com/downlo...-utilities.php). Under Formulas there is the utility to change the reference mode for a selected number of cells containing formulas.

    Regards, Teunis

  11. #11
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Doorn, Netherlands
    Posts
    311
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Rudi,

    Get yourself the free ASAP Utilities (http://www.asap-utilities.com/downlo...-utilities.php). Under Formulas there is the utility to change the reference mode for a selected number of cells containing formulas.

    Regards, Teunis

  12. #12
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Doorn, Netherlands
    Posts
    311
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Rudi,

    Get yourself the free ASAP Utilities (http://www.asap-utilities.com/downlo...-utilities.php). Under Formulas there is the utility to change the reference mode for a selected number of cells containing formulas.

    Regards, Teunis

  13. #13
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Doorn, Netherlands
    Posts
    311
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Rudi,

    Get yourself the free ASAP Utilities (http://www.asap-utilities.com/downlo...-utilities.php). Under Formulas there is the utility to change the reference mode for a selected number of cells containing formulas.

    Regards, Teunis

  14. #14
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Doorn, Netherlands
    Posts
    311
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Rudi,

    Get yourself the free ASAP Utilities (http://www.asap-utilities.com/downlo...-utilities.php). Under Formulas there is the utility to change the reference mode for a selected number of cells containing formulas.

    Regards, Teunis

  15. #15
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Doorn, Netherlands
    Posts
    311
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Rudi,

    Get yourself the free ASAP Utilities (http://www.asap-utilities.com/downlo...-utilities.php). Under Formulas there is the utility to change the reference mode for a selected number of cells containing formulas.

    Regards, Teunis

Page 1 of 3 123 LastLast

Posting Permissions

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