Edit a named range to include more cells?

Results 1 to 10 of 10

Thread: Edit a named range to include more cells?

  1. #1
    New Member
    Join Date
    Aug 2003
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Edit a named range to include more cells?

     
    A formula uses a named a range but it needs to be expanded. I have tried highlighting the range and renaming it but that does not work. Any ideas? Thanks

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Edit a named range to include more cells?

    Hi, welcome to the board.

    You have to do that from the define name window.

    Press Ctrl F3 (Or go to Insert | Names, Define...), select the named range that you want to modify, and change the "RefersTo" box.

    After, press the Add button to make sure that it gets "saved"
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    New Member
    Join Date
    Aug 2013
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Edit a named range to include more cells?

    As the OP never thanked you for your help I will.

    I know it's 10 years later but it's helped me out even now, so, Thank You

  4. #4
    Board Regular
    Join Date
    Nov 2009
    Location
    North Shore
    Posts
    165
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Edit a named range to include more cells?

    12yo and still useful - thank you
    Excel 2010

  5. #5
    New Member
    Join Date
    Mar 2016
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Edit a named range to include more cells?

    13 years and going strong. Many thanks.

  6. #6
    New Member
    Join Date
    Jul 2015
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Edit a named range to include more cells?

    12 years 11 months 25 days. Thank you Juan Pablo Gonzalez.

  7. #7
    New Member
    Join Date
    Sep 2016
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Edit a named range to include more cells?

    Thanks!!
    Help me today

  8. #8
    New Member
    Join Date
    Sep 2017
    Location
    UK
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Edit a named range to include more cells?

    September 2017 and this is still helping - THANKS

    Please note: if all the options are greyed out (un-selectable) when you open the 'Name Manager' on the Formulas tab, or use Ctrl+F3, it is because the sheet is protected. Once you un-protect the sheet you can proceed to make your changes as described above. HTH.

  9. #9
    New Member
    Join Date
    Feb 2006
    Location
    London
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Edit a named range to include more cells?

    Helped two people in one day!

  10. #10
    New Member
    Join Date
    Nov 2016
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Edit a named range to include more cells?

      
    Quote Originally Posted by Achilles2k View Post
    September 2017 and this is still helping - THANKS

    Please note: if all the options are greyed out (un-selectable) when you open the 'Name Manager' on the Formulas tab, or use Ctrl+F3, it is because the sheet is protected. Once you un-protect the sheet you can proceed to make your changes as described above. HTH.
    Well, the details have changed in this thread in the past 15 years but it is still helping! It's the formula's tab now after all. Thank you.

User Tag List

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
  •  

 

 
DMCA.com