Results 1 to 10 of 10
  1. #1
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Editing named ranges

    Hi,

    This is a nuisance issue rather than any big problem.

    I have a lot of named ranges- some of them cover 5 or 6 different areas on the worksheet.

    When I want to change the cells in the range (Insert, Name, Define, select the range, and click on the "refers to"), I have trouble using the keyboard to edit the bits which extend beyond the end of the box. When I use arrow keys, they change values in the range rather than moving the cursor. It sometimes takes a number of aborted attempts to get it right.

    Is there a way to edit more easily?
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Editing named ranges

    Ken,

    The "Refers To" box is in the "Define Name" Dialog Box. Pressing F2 does nothing.

    Actually, this probably goes beyond just this one function. I often find the built-in dialogs restrictive, in that you cannot resize.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Editing named ranges

    Ken,

    OK, I see.

    I didn't see anything happening- I expected something like when you press "F2" on a cell. And I don't normally have my status bar displayed. But when I press on the arrow keys after I press on F2, the move around as I expect. That will be a great time-saver- thanks.

    BTW, I did something rather bad.

    For the record- "Excel 2000 SR1".
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Editing named ranges

    F2 switches between Enter and Edit modes for me in Excel 2000.
    Legare Coleman

  5. #5
    Lounger
    Join Date
    Jan 2001
    Location
    Tallinn, Harjumaa, Estonia
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Editing named ranges

    Thanks,

    It's really useful hint to press F2. It helps entering ranges in other dialogs too!!!

    Anu

  6. #6
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Sault Ste. Marie, Michigan, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Editing named ranges

    Hi again,

    Strange, what you say. After I click on the refers to box in the Define Name Dialog box, my status bar shows that F2 toggles between "Enter" and "Edit". In the Edit mode I have no problem editing in the Refers To box.

    [img]/w3timages/icons/smile.gif[/img]

  7. #7
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Sault Ste. Marie, Michigan, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Editing named ranges

    Geoff,
    When you click in the Refers to box are you in Edit Mode?
    Check the status bar. If not, press F2.

    Hope this is helpful.
    Ken

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Editing named ranges

    Hey, thank fro me too. This was bugging me. I was copying what I had in the box, pasting it somewhere, editing it, and pasting it back.

  9. #9
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    eastern Connecticut, Connecticut, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Editing named ranges

    I've run into this several times -- the 'Refers to' argument extends well past the box and I need to add more at the end. The only way I've gotten around this is to use the mouse to put the cursor somewhere in the visible part of the reference and then do a 'highlight/drag' to the right. The reference will scroll to the end. I then position the insert bar at the end (to remove the highlighting from the other parts of the reference) and enter a comma and either type the additional range or use the mouse to highlight it on the worksheet. It's a bit of a nuisance but it works. (Excel97 SR2)

  10. #10
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Editing named ranges

    Gene,

    kjktoo's solution (pressing F2) worked well- I can use arrows in the normal way- I just didn't realise at first that when I pressed F2, something happened (F2 in ewxplorer or Excel in a cell gives a much more positive feedback).
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

Posting Permissions

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