Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Naming Areas on Worksheet (Excel 2002)
We have a workbook containing several sheets. Each sheet will eventually
have many named cells. When we name a cell and then hit GO TO these named cells for ALL the worksheets show up in the list. Is there a setting we can change so that ONLY the named cells in that particular worksheet show? If not, then I am afraid that the only way to accomplish this is to break out each sheet into a separate workbook, then make a master workbook that contains links to each worksheet. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Naming Areas on Worksheet (Excel 2002)
Abby
When entering the names make them local to the sheet. Select a range to name. InsertNameDefine In the "Names in Workbook" enter a name as such............. Sheetname!MyRange MyRange will only show in the Go To when Sheet1 is active. Or download and use Jan Karel Pieterse's Name Manager Add-in which allows you to change the names to local after the fact. Can be downloaded from Stephen Bullen's site. http://www.oaltd.co.uk/MVP/Default.htm Gord Dibben MS Excel MVP On Sat, 14 Oct 2006 09:47:02 -0700, Abby wrote: We have a workbook containing several sheets. Each sheet will eventually have many named cells. When we name a cell and then hit GO TO these named cells for ALL the worksheets show up in the list. Is there a setting we can change so that ONLY the named cells in that particular worksheet show? If not, then I am afraid that the only way to accomplish this is to break out each sheet into a separate workbook, then make a master workbook that contains links to each worksheet. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Naming Areas on Worksheet (Excel 2002)
Gord~
In DEFINE, refers to looks like this : ='Acme Corrugated Box'!$K$15 but I still see it when I go to another worksheet Isn't 'Acme Corrugated Box'! referring to my worksheet? If not, what do I need to change? thanks! ~Abby "Gord Dibben" wrote: Abby When entering the names make them local to the sheet. Select a range to name. InsertNameDefine In the "Names in Workbook" enter a name as such............. Sheetname!MyRange MyRange will only show in the Go To when Sheet1 is active. Or download and use Jan Karel Pieterse's Name Manager Add-in which allows you to change the names to local after the fact. Can be downloaded from Stephen Bullen's site. http://www.oaltd.co.uk/MVP/Default.htm Gord Dibben MS Excel MVP On Sat, 14 Oct 2006 09:47:02 -0700, Abby wrote: We have a workbook containing several sheets. Each sheet will eventually have many named cells. When we name a cell and then hit GO TO these named cells for ALL the worksheets show up in the list. Is there a setting we can change so that ONLY the named cells in that particular worksheet show? If not, then I am afraid that the only way to accomplish this is to break out each sheet into a separate workbook, then make a master workbook that contains links to each worksheet. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Naming Areas on Worksheet (Excel 2002)
Gord~
Thanks but in DEFINE the refers to already says: ='Acme Corrugated Box'!$K$15 (Acme Corrugated Box is the name of my worksheet) and it is still showing in my other worksheets. What do I need to change? ~Abby "Gord Dibben" wrote: Abby When entering the names make them local to the sheet. Select a range to name. InsertNameDefine In the "Names in Workbook" enter a name as such............. Sheetname!MyRange MyRange will only show in the Go To when Sheet1 is active. Or download and use Jan Karel Pieterse's Name Manager Add-in which allows you to change the names to local after the fact. Can be downloaded from Stephen Bullen's site. http://www.oaltd.co.uk/MVP/Default.htm Gord Dibben MS Excel MVP On Sat, 14 Oct 2006 09:47:02 -0700, Abby wrote: We have a workbook containing several sheets. Each sheet will eventually have many named cells. When we name a cell and then hit GO TO these named cells for ALL the worksheets show up in the list. Is there a setting we can change so that ONLY the named cells in that particular worksheet show? If not, then I am afraid that the only way to accomplish this is to break out each sheet into a separate workbook, then make a master workbook that contains links to each worksheet. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Naming Areas on Worksheet (Excel 2002)
Include the name of the worksheet in the "Names in Workbook" box:
'Acme corrugated box'!yournamehere (That's what was in Gord's original response, too.) Abby wrote: Gord~ Thanks but in DEFINE the refers to already says: ='Acme Corrugated Box'!$K$15 (Acme Corrugated Box is the name of my worksheet) and it is still showing in my other worksheets. What do I need to change? ~Abby "Gord Dibben" wrote: Abby When entering the names make them local to the sheet. Select a range to name. InsertNameDefine In the "Names in Workbook" enter a name as such............. Sheetname!MyRange MyRange will only show in the Go To when Sheet1 is active. Or download and use Jan Karel Pieterse's Name Manager Add-in which allows you to change the names to local after the fact. Can be downloaded from Stephen Bullen's site. http://www.oaltd.co.uk/MVP/Default.htm Gord Dibben MS Excel MVP On Sat, 14 Oct 2006 09:47:02 -0700, Abby wrote: We have a workbook containing several sheets. Each sheet will eventually have many named cells. When we name a cell and then hit GO TO these named cells for ALL the worksheets show up in the list. Is there a setting we can change so that ONLY the named cells in that particular worksheet show? If not, then I am afraid that the only way to accomplish this is to break out each sheet into a separate workbook, then make a master workbook that contains links to each worksheet. -- Dave Peterson |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Naming Areas on Worksheet (Excel 2002)
See Dave's response for your answer.
Gord On Sat, 14 Oct 2006 11:00:01 -0700, Abby wrote: Gord~ In DEFINE, refers to looks like this : ='Acme Corrugated Box'!$K$15 but I still see it when I go to another worksheet Isn't 'Acme Corrugated Box'! referring to my worksheet? If not, what do I need to change? thanks! ~Abby "Gord Dibben" wrote: Abby When entering the names make them local to the sheet. Select a range to name. InsertNameDefine In the "Names in Workbook" enter a name as such............. Sheetname!MyRange MyRange will only show in the Go To when Sheet1 is active. Or download and use Jan Karel Pieterse's Name Manager Add-in which allows you to change the names to local after the fact. Can be downloaded from Stephen Bullen's site. http://www.oaltd.co.uk/MVP/Default.htm Gord Dibben MS Excel MVP On Sat, 14 Oct 2006 09:47:02 -0700, Abby wrote: We have a workbook containing several sheets. Each sheet will eventually have many named cells. When we name a cell and then hit GO TO these named cells for ALL the worksheets show up in the list. Is there a setting we can change so that ONLY the named cells in that particular worksheet show? If not, then I am afraid that the only way to accomplish this is to break out each sheet into a separate workbook, then make a master workbook that contains links to each worksheet. Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Feedback and Suggestion on MS Excel 2007 (Beta 2) Worksheet Functi | Excel Worksheet Functions | |||
Excel 2002; copy formulas to one workbook to another diff data | Excel Worksheet Functions | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel |