Discover Range Names and Coordinates

User avatar
BobH
UraniumLounger
Posts: 9262
Joined: 13 Feb 2010, 01:27
Location: Deep in the Heart of Texas

Discover Range Names and Coordinates

Post by BobH »

The rusty brain is lost once again. :hairout:

I have a faint recollection of being able to discover what named ranges (and their names and coordinates) exist in a spreadsheet. I have not used Excel much at all since the ribbon menus came out.

Is it possible to examine a spreadsheet and discover what ranges it has defined? :scratch:
Bob's yer Uncle
(1/2)(1+√5)
Dell Intel Core i5 Laptop, 3570K,1.60 GHz, 8 GB RAM, Windows 11 64-bit, LibreOffice,and other bits and bobs
Top
User avatar
HansV
Administrator
Posts: 78378
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Discover Range Names and Coordinates

Post by HansV »

Activate the Formulas tab of the ribbon.
Click Name Manager in the Defined Names group.
Best wishes,
Hans
Top
User avatar
BobH
UraniumLounger
Posts: 9262
Joined: 13 Feb 2010, 01:27
Location: Deep in the Heart of Texas

Re: Discover Range Names and Coordinates

Post by BobH »

Thank you, Sir!

I saw DEFINE NAME but missed NAME MANAGER. Not even close to being the sharpest knife in the drawer these days.
Bob's yer Uncle
(1/2)(1+√5)
Dell Intel Core i5 Laptop, 3570K,1.60 GHz, 8 GB RAM, Windows 11 64-bit, LibreOffice,and other bits and bobs
Top
LisaGreen
5StarLounger
Posts: 964
Joined: 08 Nov 2012, 17:54

Re: Discover Range Names and Coordinates

Post by LisaGreen »

There's a wonderful name manager add in for excel on Jan Karels' site...

https://www.jkp-ads.com/OfficeMarketPla ... ce=mrexcel

Lisa
Top

Return to “Excel and other spreadsheet applications”