Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete unnecessary Named Ranges
I have a spreadsheet that has an incredibly long list of named ranges in the
Insert/Name/Define dialog that don't show in the Name Box. I don't know how they got there and they refer to cells on spreadsheets on other people's hard drives and network drives I don't have access to. I know how to delete them, one by one, in the dialog, but is there a way to delete them as a group? Thanks, Bernie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete unnecessary Named Ranges
The perfect tool is the Name Manager addin, this will allow you to verify
names are not used before deleting them (and much more) http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp http://www.decisionmodels.com/downloads.htm Regards, Peter T "berniean" wrote in message ... I have a spreadsheet that has an incredibly long list of named ranges in the Insert/Name/Define dialog that don't show in the Name Box. I don't know how they got there and they refer to cells on spreadsheets on other people's hard drives and network drives I don't have access to. I know how to delete them, one by one, in the dialog, but is there a way to delete them as a group? Thanks, Bernie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Unnecessary Rows | Excel Discussion (Misc queries) | |||
duplicate named ranges- how to detect, delete? | Excel Discussion (Misc queries) | |||
macro to delete all named ranges in a workbook en masse? | Excel Discussion (Misc queries) | |||
delete or edit named dell ranges | Excel Discussion (Misc queries) | |||
How do I delete all named ranges in a sheet at one time? | Excel Worksheet Functions |