How to Create a Map in Excel

Microsoft Excel is a versatile program that offers many popular spreadsheet functions. However, the software also contains features for the construction and manipulation of graphics. The program can create customized maps out of simple existing images. These maps can suit a wide range of applications. Thematic maps quantify different measurements in different locations by displaying varied colors. Interactive maps allow users to build detailed views of a standard map to isolate certain locations or events. Once a map is created in Excel, the possibilities are limited only by your creativity.

Young businesswoman eating lunch at desk
credit: Siri Stafford/Digital Vision/Getty Images

Step

Download or scan a starter map image. Many free maps are available for download at www.enchantedlearning.com/USA/states. Right-click any map and choose the "Save As" command to place the map on your computer.

Step

Launch Excel. Select the entire worksheet by clicking in the selection box located between the column A and row 1 labels in the upper left of the spreadsheet.

Step

Click the "Format" menu and choose the "Column" submenu. Select the "Width" command. A pop-up window will appear.

Step

Type the number "2.0" into the column width field and press the "OK" button.

Step

Select the "Format" menu again. Choose the "Sheet" submenu. Click on the "Background" command. A pop-up window will appear.

Step

Browse to the location of the saved map image you downloaded or scanned. Click on the name of the map image file and press the "Insert" button.

Step

Click on the "Tools" menu. Select the "Options" command. A pop-up window will appear.

Step

Click the "View" tab of the pop-up window.

Step

Uncheck the following boxes: "Row & column headers," "Vertical scroll bar," "Horizontal scroll bar" "and "Gridlines." This will ensure that the map image appears clean without interference from the spreadsheet grid.