R
ranswert
How do I assign a name to a cell that has the same name in another worksheet?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
reitanospa1
A workbook can only use a named range once, not once per worksheet.
Use Insert/Name/Define to see your list of names and you'll notice
that the Refers to: field includes the sheet name.
Use Insert/Name/Define to see your list of names and you'll notice
that the Refers to: field includes the sheet name.
T
T. Valko
If it's the same cell on both sheets:
Insert>Name>Define
Name: Start
Refers to: !$A$1
If you're on sheet1 then Start refers to Sheet1 A1, if you're on sheet10
then Start refers to Sheet10 A1.
Insert>Name>Define
Name: Start
Refers to: !$A$1
If you're on sheet1 then Start refers to Sheet1 A1, if you're on sheet10
then Start refers to Sheet10 A1.
T
Tyro
Excel 2007 names have scope: workbook or worksheet. Thus you can use the
same name over and over to name a cell or range on different worksheets and
once at the workbook level. You can use the name on the sheet where it is
defined without qualification. You can also use the name to refer to other
sheets that have the same name if you qualify it with the appropriate sheet
name. If the same name is defined at the workbook level and you use it on a
sheet that has the same name defined, you can qualify it with the book name.
If you use the name on a sheet that does not have the same name defined, you
get the workbook level name unless you qualify it a sheet name to get the
name as defined on that sheet.
Tyro
same name over and over to name a cell or range on different worksheets and
once at the workbook level. You can use the name on the sheet where it is
defined without qualification. You can also use the name to refer to other
sheets that have the same name if you qualify it with the appropriate sheet
name. If the same name is defined at the workbook level and you use it on a
sheet that has the same name defined, you can qualify it with the book name.
If you use the name on a sheet that does not have the same name defined, you
get the workbook level name unless you qualify it a sheet name to get the
name as defined on that sheet.
Tyro
G
Gord Dibben
Just a note:
The name "start" won't show up in the namebox or in Go To dialog.
Must be typed into either of those.
Gord Dibben MS Excel MVP
The name "start" won't show up in the namebox or in Go To dialog.
Must be typed into either of those.
Gord Dibben MS Excel MVP
D
Dave Peterson
And from what I've read (maybe Charles Williams???), this type of name can cause
calculation problems.
I wonder if just using a sheet level name would be sufficient.
If you're on Sheet 999:
Insert|Name|Define
Names in Workbook box: 'Sheet 999'!rangenamehere
And put the range in the Refers to box.
calculation problems.
I wonder if just using a sheet level name would be sufficient.
If you're on Sheet 999:
Insert|Name|Define
Names in Workbook box: 'Sheet 999'!rangenamehere
And put the range in the Refers to box.
W
Waleed
Hello
How can I rearrange names in Name Box of a sheet. I can not find any help
about this in help system
How can I rearrange names in Name Box of a sheet. I can not find any help
about this in help system
T
T. Valko
If you mean the name box that's directly above the column A header, as far
as I know there is no way to "sort" or rearrange the listed names. Excel
lists them in alphabetical order.
as I know there is no way to "sort" or rearrange the listed names. Excel
lists them in alphabetical order.