Results 1 to 4 of 4

Thread: Change all cells to Absolute $?$
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Apr 2003
    Location
    UK
    Posts
    522
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Change all cells to Absolute $?$

    Hello
    Is there a way where you can change all the cells to absolute references?

    I want to select A1:OO100 and change all the formula to $?$ what is the short cut to do this?
    im using a Mac.

    Thank you
    Last edited by j4ymf; Jul 15th, 2019 at 02:24 PM.

  2. #2
    Moderator mole999's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    9,855
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Change all cells to Absolute $?$

    not sure about Mac, F4 cycles it, or maybe ASAP utilities is available for Mac
    • Yes I know there are better ways to do it. I just wish I knew them. - 97, 2003, 2007, 2010, 2013, 2016 & 2019
    • I wear my ignorance openly, excel is not my chosen career, its a means to an ends
    • Posting Guidelines Want to post well laid out questions and answers Translate Excel Versions
      Code:
      [CODE ]Put Your Code[/ CODE]
    • Settings > General Settings (on the left) scroll to the bottom, > Miscellaneous Options > Use ENHANCED
    • X-Posting Guidelines Rule 13 > CHART STUFF

  3. #3
    Board Regular
    Join Date
    Apr 2003
    Location
    UK
    Posts
    522
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Change all cells to Absolute $?$

    Thank you

  4. #4
    Board Regular
    Join Date
    May 2009
    Location
    Perth, Australia
    Posts
    1,663
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Change all cells to Absolute $?$

    I would use vba code in he weblink below
    https://www.ozgrid.com/VBA/formula-ref-change.htm

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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