Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
TheHumbleOne
Lv 7
TheHumbleOne asked in Computers & InternetSoftware · 2 decades ago

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."

2 Answers

Relevance
  • Raj
    2 decades ago
    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
    2 decades ago

    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

Still have questions? Get your answers by asking now.