Where to edit range name

bknight
BronzeLounger
Posts: 1402
Joined: 08 Jul 2016, 18:53

Where to edit range name

Post by bknight »

I'm looking for where to edit range names. I found where you can define names, use in formulas and create from selection. But I have several, and I want to edit where they encompass the data I wish, so where are they edited?

User avatar
HansV
Administrator
Posts: 78568
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Where to edit range name

Post by HansV »

On the Formulas tab of the ribbon, in the Defined Names group, click Name Manager.
Best wishes,
Hans

bknight
BronzeLounger
Posts: 1402
Joined: 08 Jul 2016, 18:53

Re: Where to edit range name

Post by bknight »

Right there and missed it