how do I name a range in Excel 2000?
I'm trying to import names and e-mail addresses from an Excel file into Contacts. I did get the "contacts" structure and copy/paste the info into appropriate columns, but it asks for a "range."
I'm trying to import names and e-mail addresses from an Excel file into Contacts. I did get the "contacts" structure and copy/paste the info into appropriate columns, but it asks for a "range."
Raj
Favorite Answer
To name a range in Excel do the following:-
Select the cells containing data i.e. select the range of cells and then
1. click in the name box which is located at the extreme left on the formula bar where cell adress is normally displayed. Then type the name for the range and enter. The name is assigned.
OR
2. Click at Menu bar on Insert -> Name-> Define
Type the name for thr range and specify the range address in the Refer to Box and click OK.
Anonymous
I didn't get you well, but I think this is the answer
First save your excel file as csv file and impurt it into "contacts"
XLMan