vlookup naming a range in excel 07

  • Thread starter Thread starter Steven
  • Start date Start date
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!
 
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
 
Back
Top