Add One Place to Visit

In this video, you will search for specific locations in the area you chose, and add one to your spreadsheet.

If you're creating a guide for an area you are unfamiliar with, or if you need some ideas for locations to include in your guide, you can search the internet.

In your search, include the name of the area and terms that are relevant to your audience or the type of location you are looking for such as "tourism" or "cultural landmarks".

Find several attractions, points of interest, or activities you can include in your guide.

Once you have found several locations, type the name of the first location in the first column in your spreadsheet.

Next, look up the location's address in Google Maps.

Open a new tab or window.

Then, type maps.google.com Then, type the name of the location in the search box.

The map provides the address for this place.

Copy the address.

Then, return to your area guide and paste the address into the address column.

You can also use the keyboard shortcuts Control-V or Command-V to paste content more efficiently.

Next, add a category for the location to help group the locations in your guide.

Some categories you might use are... restaurant, park, hotel, museum, lake Categories should be general so that they can work for several locations in your guide.

For example, if your guide focuses on stores, the categories might include shoes, hardware, sporting goods, and clothing.

For a guide to restaurants, the categories might be types of food.

Choose a category that works best for the first place in your area guide.

Next, type a brief description to give your users a little more information about this location.

You can also wrap text, so that it fits within the cell.

Wrapping text keeps all the text visible within a cell, rather than being cut off or flowing into the next cell.

Select a cell, row, or column and then wrap the text.

If you would like, select multiple columns and wrap the text in all of them at once.

Then, resize your columns to make it easier to read your text.

Next, align text to move it around in the cell.

Select a cell, column, or row with text that you want to align.

Then, select horizontal alignment, and choose left, right, or center.

You can also align the text vertically.

Select top, bottom, or middle.

Aligning text in your cells can help make your spreadsheet appear more organized.

Now, it's your turn: Add the first location to your guide, look up the location in Google Maps and copy the address to your spreadsheet, add a description and a category for the place, and wrap and align the text to make the information easier to read.