how do I name ranges in an Excel worksheet

[becca122121]

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

 

[Bob Phillips]

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)

 

[Dave R.]

Select your cells then Insert>name>define


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

 

[Carla Bradley]

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

Carla

 

[Don Guillett]

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