Kick off the new school year with lessons from our Back to School 2022 collection to help students express themselves, build relationships, and stay organized.

4. Add a Link To Your Custom Map

Playback Speed:

In this video, you will add a link from your custom map to your area guide so your users can access it.

To do this, you will merge cells in your spreadsheet and add instructions about your map.

Then, you will link the text to your map’s URL.

First, create a space for the map link in your area guide.

Unfreeze the header row and insert a row underneath it.

Next, merge several cells in this row to make a large space for your map link.

Highlight the 3 cells under Location name, Address, and Description.

Select Format and Merge Cells.

Type text in the merged cells to tell your users to check out the map.

Use whatever text you’d like.

Change the format of the text and the cell so it is very noticeable.

Then, freeze the top 2 rows.

Next, link this text to the URL for your map.

In your Google My Map, click Share.

Then, copy the link.

Click back to your area guide.

Select the merged cell you created.

Click Insert and Link.

Then, paste in the link.

Check it out.

Click somewhere else in the spreadsheet.

Then, click the linked text and the URL.

Your map opens in a new window. Terrific!

Now your users can use your area guide and your map as they explore the area you chose!


  1. Unfreeze the top row of your area guide.
  2. Insert another row underneath the headers and merge several cells.
  3. Add text to instruct your users to click on the cell.
  4. Format the cell so it is noticeable
  5. Link the text to your custom map.
  6. Freeze the top two rows.
  • "Happy Alley by Kevin MacLeod" by ( -- Licensed under Creative Commons: By Attribution 3.0 License (