vlookup naming a range in excel 07

S

Steven

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!
 
V

vezerid

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, Insert>Name>Define...

HTH
Kostis Vezerides
 

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

Need Help with a VBA subroutine 0
Pasting a cell into bookmarked table from excel vba 1
VLOOKUP & Data Validation 0
How do I have a cell value define a dynamic named range? 15
why do print range erase in Excel when import data from access 1
VLOOKUP 1
Merging from an Excel file with graphics 1
Linked Named Ranges 2

Top