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/.

Manage maps

Float and anchor maps

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.

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.

Floating map in

To work with floating maps, use the following options:

  • To move a floating map to another area or to another monitor, click the map's title bar and drag the map to the desired location.
  • To hide a floating map, click the Minimize map button (Minimize map button) in the map's title bar.
  • To display the map using the full extent of your display, click the Maximize map button (Maximize map button).
  • To delete a map from your spreadsheet, click the Remove map button (Remove map button) in the map's title bar.

Anchored maps

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.

Anchored map in

To work with anchored maps, use the following options:

  • To minimize the footprint of an anchored map, click the Collapse button (Collapse button) in the map's title bar.
  • To view a collapsed map, click the Show Map button (Show Map button).
  • To return an anchored map to a floating state, click the Float map button (Float map button).
  • To move an anchored map, click the map's title bar and drag the map to the desired location.

Arrange maps

To view all floating maps, do the following:

  1. From the ArcGIS Maps ribbon, click Arrange Maps.

    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.

Find maps

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:

  1. From the ArcGIS Maps ribbon, click Go to Map.

    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.

    Go to Map window

  2. Click the map you want to display.

    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.

Resize a map

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.