how do I name ranges in an Excel worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel worksheet that I am trying to convert into my outlook
contacts but everytime I do it tells me I have to name ranges in excel first.
and I dont know how to do that
 
Go to Insert>Name>Define... and add the name and the range it refers to.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Select your cells then Insert>name>define


In the future you can press F1, type in some terms, and you'd be done.
 
Click on Insert, then Name, then Define. This should show all your names.

Carla
 
another way is to select the range and name in the NAME box to the left of
the formula box
 
You must log in or register to reply here.

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

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How do i name a range of data in excel 1
Excel Limit to Named Ranges 1
Go To a Named Range (2nd posting) 4
Excel VBA - Problem with Closing Print Preview 0
Auto worksheet name? 1
Conditional formatting on a dynamic range - workaround 1
Excel VBA - counting cells by colors and names to it in two different rows. 0

Back
Top