Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Name Box in Excel 2007
Hello
How can I rearrange names in Name Box of a sheet. I can not find any help about this in help system |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Name Box in Excel 2007
As far as I know this is not possible. Excel lists the names alphabetically.
-- 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Name Box in Excel 2007
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 "T. Valko" wrote: As far as I know this is not possible. Excel lists the names alphabetically. -- 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Name Box in Excel 2007
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. -- Thanks, Shane Devenshire "Waleed" wrote: Hello How can I rearrange names in Name Box of a sheet. I can not find any help about this in help system |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Name Box in Excel 2007
If you want to change names, far better to get hold of Jan Karel Pieterse's
NameManager utility, http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp -- __________________________________ HTH Bob "Billy Liddel" wrote in message ... 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 "T. Valko" wrote: As far as I know this is not possible. Excel lists the names alphabetically. -- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Labels: Unable to import all records Excel 2007 to Word 2007 Mailm | Excel Discussion (Misc queries) | |||
Pasting a chart from Excel 2007 to Word 2007 trouble | Charts and Charting in Excel | |||
Import an MS Money 2007 file into MS Excel 2007 worksheet | Excel Discussion (Misc queries) | |||
Paste EXCEL 2007 sheet into WORD 2007 - objects move around | Excel Discussion (Misc queries) | |||
Chart Selection - Excel 2007 copy to Powerpoint 2007 | Charts and Charting in Excel |