Expand Named Range To Include More Cells

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    I have a named range (A1:d50), named "DATA"


    Now I want to expand the "DATA" range to (A1:F75)


    When I click on the named range "DATA" it pulls up the range A1:D50) but I don't know how to expand the range to (A1:F75) without creating a new named range or delete the old "DATA) range and redefining.

    Re: Expand Named Range To Include More Cells


    John


    If you want to do this manually just goto Insert>Name...Define, select the range, enter the expanded range in the refers to box, click Add and then OK.


    If that isn't what you are looking to do perhaps you should be looking into dynamic named ranges.

    Boo!:yikes:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login