If you mean the name box that's directly above the column A header, as far
as I know there is no way to "sort" or rearrange the listed names. Excel
lists them in alphabetical order.

--
Biff
Microsoft Excel MVP


"Waleed" wrote in message
...
Hello
How can I rearrange names in Name Box of a sheet. I can not find any help
about this in help system

"T. Valko" wrote:

If it's the same cell on both sheets:

InsertNameDefine
Name: Start
Refers to: !$A$1

If you're on sheet1 then Start refers to Sheet1 A1, if you're on sheet10
then Start refers to Sheet10 A1.

--
Biff
Microsoft Excel MVP


"ranswert" wrote in message
...
How do I assign a name to a cell that has the same name in another
worksheet?