Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing Named Ranges
Hi All, I've done some searches and can't find what I'm looking for - not sure if it's possible or not? I have a worksheet with anywhere between 50 - 80 different defined named ranges on it. I need to update the sheet occassionally by inserting new details (with a corresponding new range name), as well as deleting or editing existing ranges. What I'd like to know is: Is there a way I can view the sheet so that it shows the different ranges that have names - similar to using the "View Formulas" check in the Excel Options, but to view ranges instead? Am I pushing my luck here?! ; ) Cheers, Rob. -- Rob Moyle ------------------------------------------------------------------------ Rob Moyle's Profile: http://www.excelforum.com/member.php...o&userid=30432 View this thread: http://www.excelforum.com/showthread...hreadid=549797 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing Named Ranges
Hi Rob
Download a free copy of Bastien Mensink's excellent Add in ASAP Utilities http://www.asap-utilities.com/ This has a feature in the Information section to List all Named ranges on a separate sheet along with their definitions (along with numerous other useful utilities) -- Regards Roger Govier "Rob Moyle" wrote in message ... Hi All, I've done some searches and can't find what I'm looking for - not sure if it's possible or not? I have a worksheet with anywhere between 50 - 80 different defined named ranges on it. I need to update the sheet occassionally by inserting new details (with a corresponding new range name), as well as deleting or editing existing ranges. What I'd like to know is: Is there a way I can view the sheet so that it shows the different ranges that have names - similar to using the "View Formulas" check in the Excel Options, but to view ranges instead? Am I pushing my luck here?! ; ) Cheers, Rob. -- Rob Moyle ------------------------------------------------------------------------ Rob Moyle's Profile: http://www.excelforum.com/member.php...o&userid=30432 View this thread: http://www.excelforum.com/showthread...hreadid=549797 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing Named Ranges
Hi Rob,
As you are working extensively with named ranges, you should download Jan Karel Pieterse's invaluable Name Manager addin, which can be downloaded, free of charge, at: http://www.jkp-ads.com/Download.asp --- Regards, Norman "Rob Moyle" wrote in message ... Hi All, I've done some searches and can't find what I'm looking for - not sure if it's possible or not? I have a worksheet with anywhere between 50 - 80 different defined named ranges on it. I need to update the sheet occassionally by inserting new details (with a corresponding new range name), as well as deleting or editing existing ranges. What I'd like to know is: Is there a way I can view the sheet so that it shows the different ranges that have names - similar to using the "View Formulas" check in the Excel Options, but to view ranges instead? Am I pushing my luck here?! ; ) Cheers, Rob. -- Rob Moyle ------------------------------------------------------------------------ Rob Moyle's Profile: http://www.excelforum.com/member.php...o&userid=30432 View this thread: http://www.excelforum.com/showthread...hreadid=549797 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing Named Ranges
Hi Rob
As a quick and dirty method, you can reduce the zoom on the worksheet to 39% and below and then the named ranges will be delineated and visible. Hope this helps! Best regards Richard |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing Named Ranges
Hit F5 and see if this serves your purpose.
"Rob Moyle" wrote: Hi All, I've done some searches and can't find what I'm looking for - not sure if it's possible or not? I have a worksheet with anywhere between 50 - 80 different defined named ranges on it. I need to update the sheet occassionally by inserting new details (with a corresponding new range name), as well as deleting or editing existing ranges. What I'd like to know is: Is there a way I can view the sheet so that it shows the different ranges that have names - similar to using the "View Formulas" check in the Excel Options, but to view ranges instead? Am I pushing my luck here?! ; ) Cheers, Rob. -- Rob Moyle ------------------------------------------------------------------------ Rob Moyle's Profile: http://www.excelforum.com/member.php...o&userid=30432 View this thread: http://www.excelforum.com/showthread...hreadid=549797 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named Ranges | Excel Worksheet Functions | |||
dynamically building references to named ranges | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Viewing List of Named Ranges | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |