Re: Need to Edit the name Box definitions

2019-03-22 Thread WA.TWORSX via AOL
I do wish, however, that there was a "More" or "Continue" button available, rather than needing to go back to step one. I had to change the Named Ranges for 13 columns that were shifted in the spreadsheet. That's easy, and there is no need for an extra button: just repeat steps two, thre

Re: Need to Edit the name Box definitions

2019-03-21 Thread Brian Barker
At 17:17 21/03/2019 -0400, Vince Bonly wrote: On 3/19/2019 10:00 PM, Brian Barker wrote: To modify the definition of a name: o Go to Insert | Names > | Define... . o Select the existing name. o Drag across the new range. o Modify. o OK. Just to let you know that your suggestions / instructions

Re: Need to Edit the name Box definitions

2019-03-21 Thread David Robley
For future reference, you can cut  and paste a named range and the name will move with the range. On 22/3/19 7:47 am, WA.TWORSX via AOL wrote: On 3/19/2019 10:00 PM, Brian Barker wrote: At 20:48 19/03/2019 -0400, Vince Bonly wrote: I have an AOO-Calc spreadsheet that has several "name box" d

Re: Need to Edit the name Box definitions

2019-03-21 Thread WA.TWORSX via AOL
On 3/19/2019 10:00 PM, Brian Barker wrote: At 20:48 19/03/2019 -0400, Vince Bonly wrote: I have an AOO-Calc spreadsheet that has several "name box" definitions, which I must revise or redefine the defined range. I have forgotten how to define and / or edit the contents of the name box defini

Re: Need to Edit the name Box definitions

2019-03-20 Thread WA.TWORSX via AOL
TNX a bunch Brian.  I will give that a try as I am about to update my BVL Bowling Tournament spreadsheet for this year's competition. On 3/19/2019 10:00 PM, Brian Barker wrote: At 20:48 19/03/2019 -0400, Vince Bonly wrote: I have an AOO-Calc spreadsheet that has several "name box" definitions

Re: Need to Edit the name Box definitions

2019-03-19 Thread Brian Barker
At 20:48 19/03/2019 -0400, Vince Bonly wrote: I have an AOO-Calc spreadsheet that has several "name box" definitions, which I must revise or redefine the defined range. I have forgotten how to define and / or edit the contents of the name box definitions. And, I could not find info about "name

Need to Edit the name Box definitions

2019-03-19 Thread WA.TWORSX via AOL
AOO415m1(Build:9789) -  Rev. 1817496 2017-12-11 17:25 Windows 10-x64 Home, DELL desktop. _ I have an AOO-Calc spreadsheet that has several "name box" definitions, which I must revise or redefine the defined range.  I have forgotten how to define and /