Skip to content

6. Include More Places to Explore

Playback Speed:

In this video, you will add additional locations to your spreadsheet until you have at least ten locations in your guide.

Then, you will use fill colors, alternating colors, and other formatting tools to make your area guide more easy to use.

Search the internet for additional locations in the area you chose.

Use different search terms and phrases to get different results.

Add a name, address, description, and category to your spreadsheet for each location.

Add at least ten locations.

Then, add additional formatting to your spreadsheet.

Add colors or borders to cells, columns, or rows, to make your guide easier to read.

For example, you could add a border to the first row so that your headings stand out even more.

Or, use alternating colors to make it easier to tell the rows apart.

Select the range of cells whose colors you want to alternate.

Choose “Format” and “Alternating colors.”

Then, select from a variety of color styles, or create your own.

Now, the colors you chose will alternate in the spreadsheet rows.

Update other formatting options to match.

Make sure your spreadsheet is easy to read.

Then, move on to the next video to wrap up this activity.

Now, it’s your turn: Add nine more locations to your area guide spreadsheet so you have a total of at least ten.

Experiment with formatting options like fill colors, borders, or alternating colors to make your spreadsheet lively and easy to read.

Then, move on to the next video.


  1. Perform a search for more locations for your Area Guide.
  2. Add at least ten new places to visit.
  3. Explore Google Sheets tools and features to format and organize data.
  • "Happy Alley by Kevin MacLeod" by ( -- Licensed under Creative Commons: By Attribution 3.0 License (