Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Location
    Harrogate, Yorkshire, England
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Range names in formulas (2000)

    Hi anyone that can help! I remember vaguely a tip that enables you to view Range Names from the drop down Name box when creating a formula..i.e once you enter the = sign, the name box just gives you Functions, but I'm sure there's a way of displaying the range names so you can just select from the list to add in to your formula.

    TIA

  2. #2
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Missouri, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Range names in formulas (2000)

    Press F3.

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Range names in formulas (2000)

    If you press F5 (or Ctrl-G) while entereing a formula, you will be presented with a list of range names from which you can make a selection.

    Andrew C

  4. #4
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Missouri, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Range names in formulas (2000)

    Not sure, but F5 gives the Go To command, whereas F3 provides Paste Name box.

  5. #5
    Star Lounger
    Join Date
    Mar 2003
    Location
    Harrogate, Yorkshire, England
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Range names in formulas (2000)

    Once again the lounge bales me out! Thanks Shades ;-)

  6. #6
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    Paragould, Arkansas, USA
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Range names in formulas (2000)

    <big>(</big>You're both right, you know!<big>)</big>

    To clarify,

    F-5/Ctrl-G allows you to select a range in a Go To dialog. (There's also a drop-down list of range names in the Name box on the left end of the formula bar. These are Go-To things)

    F-3 opens a list to select from in building formulas. Works wherever formulas are being written/edited.

    Errol

Posting Permissions

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