Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW TO ASIGN SAME NAME TO TWO DIFFERENT RANGES IN SEPARAT SHEETS
I would like to assign same name to two different ranges in in two different
sheets of same workbook. When we make a copy of sheet, EXCEL create such names. But if we try to create from the menu, " InsertNameCreate " name will refer to only one sheet. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW TO ASIGN SAME NAME TO TWO DIFFERENT RANGES IN SEPARAT SHEETS
Names can be either workbook-level or sheet-level.
When you create the sheet-level name (either in the Name box on the formula bar or using Insert/Name/Define), prefix the name with the name of the sheet, e.g.: Sheet1!MyName Sheet2!MyName Note that if you use the name box, you'll need to delete the workbook-level name first. In article , Satyapal Kaushal <Satyapal wrote: I would like to assign same name to two different ranges in in two different sheets of same workbook. When we make a copy of sheet, EXCEL create such names. But if we try to create from the menu, " InsertNameCreate " name will refer to only one sheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move rows of data seperated in a sheet to a sheet with no separat | Excel Worksheet Functions | |||
Combine 2 ranges in different sheets using Pivot Table | Excel Discussion (Misc queries) | |||
selecting different cell ranges across sheets, to display on summary page | Excel Discussion (Misc queries) | |||
in charting, how do i select data ranges from multiple sheets, sa. | Charts and Charting in Excel | |||
How can I asign a number value to a text line in Excel? | Charts and Charting in Excel |