Name Box in Excel 2007

  • Thread starter Thread starter Waleed
  • Start date Start date
W

Waleed

Hello
How can I rearrange names in Name Box of a sheet. I can not find any help
about this in help system
 
Biff is right. However, with a bit of work you can change to suite.

Change the range names by adding the suffix a,b,c...z to each name. Select
the first name add A in front and click Add, then delete the old name. Repeat
until finished.

Next use Replace in the Edit menu to replace the old names with the new and
this will replace any formulas that include the range names.

Regards
Peter Atherton
 
Hi,

why do you want it in a different order? If you want to pick quickly from
the list type the first letter(s) in the Name Box and THEN open the drop
down. Excel will have selected the first item with that letter(s). If you
open the Name Box and then type the letter Excel will not pick a matching
entry.

You can also press F5 click on any name and type.
 
Back
Top