how do I name ranges in an Excel worksheet
 

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 InsertNameDefine... and add the name and the range it refers to.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"becca122121" wrote in message
...
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

Select your cells then Insertnamedefine


In the future you can press F1, type in some terms, and you'd be done.


"becca122121" wrote in message
...
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

Click on Insert, then Name, then Define. This should show all your names.

Carla

"becca122121" wrote:

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

another way is to select the range and name in the NAME box to the left of
the formula box

--
Don Guillett
SalesAid Software

"becca122121" wrote in message
...
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