This is an archive related to a previous version of ArcGIS Maps for Office. If you need the current version go to http://doc.arcgis.com/en/maps-for-office/.
ArcGIS Maps for Office lets you decide how to work with the maps that you add to your spreadsheet. You can have floating maps that open in a separate window, or anchored maps that are embedded in your spreadsheet. You can also define maps differently and have both anchored and floating maps.
By default, ArcGIS Maps for Office adds maps to a spreadsheet as floating maps. Floating maps are windows outside of your Excelspreadsheet. With floating maps, you can scroll through your spreadsheet data without losing sight of your map. You can move a floating map to another monitor, maximize it to fill the extents of your display, or minimize the map to get it out of the way when you don't need to see it. A floating map has a dark green title bar.
To work with floating maps, use the following options:
To delete a map from your spreadsheet, click the Remove map button () in the map's title bar.
If you prefer to have a map embedded in a specific location in a spreadsheet, you can anchor a floating map using the down arrow in the upper left corner of the map. Anchored maps can be useful when creating dashboards that have a structured layout within a worksheet. An anchored map has a light green title bar to indicate it is no longer floating.
To work with anchored maps, use the following options:
To view all floating maps, do the following:
All your floating maps are positioned alongside your Excel window. By default, the windows are tiled. Occasionally, when there are several maps and not much screen space, the windows will cascade in the desktop area beside the spreadsheet.
When your spreadsheet includes multiple maps (a workbook can contain up to five maps), the Go to Map tool helps you quickly find and display the map you want.
To find a map, do the following:
The Go to Map window opens, showing thumbnail images of all the maps in your spreadsheet. The name of the map and, if the map is anchored, the name of the worksheet in which the map is anchored is listed below each thumbnail.
The Go to Map window closes and the chosen map is selected. A selected map has a yellow boarder. If the map was minimized or collapsed, ArcGIS Maps for Office expands it.
To resize a floating or anchored map, place the mouse pointer over the map window's border to display the resize icons and click to resize the window.