| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup naming a range in excel 07
How do I name a range of cells in a worksheet to be used to grab data from
another worksheet? All this highlighting cells time and time again is a pain in the bum! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup naming a range in excel 07
Easiest way:
Identify the Name Box, to the left of the formula bar (the one always showing the address of the selected cell). Select your range of data. Click in the name box and enter the name you want to give your range. For more, InsertNameDefine... HTH Kostis Vezerides On Jun 27, 5:49 pm, "Steven" wrote: How do I name a range of cells in a worksheet to be used to grab data from another worksheet? All this highlighting cells time and time again is a pain in the bum! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem naming range | Excel Worksheet Functions | |||
| Range Naming, dimensioning | New Users to Excel | |||
| Naming a range | Excel Discussion (Misc queries) | |||
| Range naming | Excel Discussion (Misc queries) | |||
| Naming a range | Excel Discussion (Misc queries) | |||
Hybrid Mode
