Sunday, October 23, 2011

How to Create a Map in Excel


1. 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.
2. 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.
3. Click the 'Format' menu and choose the 'Column' submenu. Select the 'Width' command. A pop-up window will appear.
4. Type the number '2.0' into the column width field and press the 'OK' button.
5. Select the 'Format' menu again. Choose the 'Sheet' submenu. Click on the 'Background' command. A pop-up window will appear.
6. 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.
7. Click on the 'Tools' menu. Select the 'Options' command. A pop-up window will appear.
8. Click the 'View' tab of the pop-up window.
9. 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.

Blogger news