spredsheets?

G

Guest

I want to create a spreadsheet with colunms for names addresses & zipcodes
that I can use with streets & trips?
 
G

Gord Dibben

neil

Do you mean to have these names, addresses, zips located as pushpins on
Streets and Trips?

Create a new workbook.

On Sheet1 in Row 1 enter in Columns some titles.

A1.......Name
B1.......Address
C1.......City
D1.......State
E1.......Zip

Now enter the name, address, city, state and zip of each designate.

Save the workbook.

Open Streets and Trips.

Data>Import Data Wizard.

Find your workbook and double-click to open.

Check the data and Finish.

Push pins will be placed on a map.

To show information, select a push pin and "Show Information"


Gord Dibben Excel MVP
 

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

Top