Hello team,
I have named ranges for the tables I have created, although their scope is workbook, when I press F3, some of the name ranges are not being shown in F3 dialog box.
Regards,
Any tips?
BittenApple
Name ranges and their scope
-
- Administrator
- Posts: 78474
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Name ranges and their scope
Can you attach a sample workbook demonstrating the problem?
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Name ranges and their scope
Hello Hans,
I don't have it.
Can we see the name of a table in name ranges If we convert a range to a table and give that table a name?
Tables are a little bit strange in office 365.
Regards,
Bita
I don't have it.
Can we see the name of a table in name ranges If we convert a range to a table and give that table a name?
Tables are a little bit strange in office 365.
Regards,
Bita
-
- 3StarLounger
- Posts: 254
- Joined: 15 Aug 2016, 11:23
Re: Name ranges and their scope
Did you tried? you will see.
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Name ranges and their scope
Hello,
What did I try?
Thanks
bittenapple
What did I try?
Thanks
bittenapple
-
- Administrator
- Posts: 78474
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Name ranges and their scope
BittenApple, you wrote "Can we see the name of a table in name ranges If we convert a range to a table and give that table a name?"
So try converting a range to a table and naming it. Then see if the table name is listed when you press F3.
(The answer will be "no")
So try converting a range to a table and naming it. Then see if the table name is listed when you press F3.
(The answer will be "no")
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Name ranges and their scope
Hans,
Thanks for response.
Do we need to give our range a name and then convert it to a table?
Regards,
BittenApple
Thanks for response.
Do we need to give our range a name and then convert it to a table?
Regards,
BittenApple
-
- Administrator
- Posts: 78474
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Name ranges and their scope
As a general question, that makes no sense.
There are many situations in which naming a range is useful.
And there are many situations in which converting a range to a table is useful.
But the sequence "name a range, then convert it to a table" has no particular meaning.
There are many situations in which naming a range is useful.
And there are many situations in which converting a range to a table is useful.
But the sequence "name a range, then convert it to a table" has no particular meaning.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Name ranges and their scope
Hello Hans,
How do we name a range which is converted to a table? Is there a way to see that table name by F3?
Thanks,
BittenApple
How do we name a range which is converted to a table? Is there a way to see that table name by F3?
Thanks,
BittenApple
-
- Administrator
- Posts: 78474
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Name ranges and their scope
You can assign a name to the table range or to a part of the table range the usual way. Select the range, then either type the name in the name box on the left hand side of the formula bar and press Enter, or click Define Name on the Formulas tab of the ribbon.
A name that you assign this way will appear in the Paste Name dialog (F3). The name of the table itself won't be listed, as you have found.
P.S. in many formulas, you can use both the table name and the range name, with the same result:
A name that you assign this way will appear in the Paste Name dialog (F3). The name of the table itself won't be listed, as you have found.
P.S. in many formulas, you can use both the table name and the range name, with the same result:
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Name ranges and their scope
Hello Hans,
"The name of the table itself won't be listed"
Can you please explain about this? If I insert a table on a range and then name it, this name will appear when we press F3.
Then what wouldn't be shown when we press F3?
Many, many thanks,
BittenApple
"The name of the table itself won't be listed"
Can you please explain about this? If I insert a table on a range and then name it, this name will appear when we press F3.
Then what wouldn't be shown when we press F3?
Many, many thanks,
BittenApple
-
- Administrator
- Posts: 78474
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Name ranges and their scope
The name of the table won't be displayed in the Paste Name dialog. Only range names.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Name ranges and their scope
Thanks for all explanation.
Bittenapple
Bittenapple