How do I assign a name to a cell that has the same name in another worksheet?

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.

On Jan 16, 5:29 pm, ranswert
wrote:
How do I assign a name to a cell that has the same name in another worksheet?

If it's the same cell on both sheets:

InsertNameDefine
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.

--
Biff
Microsoft Excel MVP


"ranswert" wrote in message
...
How do I assign a name to a cell that has the same name in another
worksheet?

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

"ranswert" wrote in message
...
How do I assign a name to a cell that has the same name in another
worksheet?

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

On Wed, 16 Jan 2008 18:10:04 -0500, "T. Valko" wrote:

If it's the same cell on both sheets:

InsertNameDefine
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.

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.

"T. Valko" wrote:

If it's the same cell on both sheets:

InsertNameDefine
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.

--
Biff
Microsoft Excel MVP

"ranswert" wrote in message
...
How do I assign a name to a cell that has the same name in another
worksheet?

--

Dave Peterson

Hello
How can I rearrange names in Name Box of a sheet. I can not find any help
about this in help system

"T. Valko" wrote:

If it's the same cell on both sheets:

InsertNameDefine
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.

--
Biff
Microsoft Excel MVP


"ranswert" wrote in message
...
How do I assign a name to a cell that has the same name in another
worksheet?

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.

--
Biff
Microsoft Excel MVP


"Waleed" wrote in message
...
Hello
How can I rearrange names in Name Box of a sheet. I can not find any help
about this in help system

"T. Valko" wrote:

If it's the same cell on both sheets:

InsertNameDefine
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.

--
Biff
Microsoft Excel MVP


"ranswert" wrote in message
...
How do I assign a name to a cell that has the same name in another
worksheet?