naming cells

  • Thread starter Thread starter ranswert
  • Start date Start date
R

ranswert

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.
 
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.
 
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
 
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
 
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.
 
Hello
How can I rearrange names in Name Box of a sheet. I can not find any help
about this in help system
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

names in different worksheets 2
Excel VBA 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Reference the same cell based on tab name 1
Excel Highlighting duplicates 0
vba code help for multiple string searching 0
How do I have a cell value define a dynamic named range? 15
Display Worksheet title in cell 4

Back
Top