Manage maps

You can manage maps in your Excel workbook by floating, anchoring, or arranging them.

Float and anchor maps

With ArcGIS for Office, 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

ArcGIS for Office adds maps to a spreadsheet as floating maps by default. Floating maps are windows outside of your Excel spreadsheet. 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 it when you don't need to see it. A floating map has a dark-green title bar.

Floating map in Excel

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 in the map's title bar.
  • To display the map using the full extent of your display, click the Maximize map button Maximize map.
  • To delete a map from your worksheet, click the Delete map button Delete map from worksheet 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 Anchor map button Anchor map in the upper left corner of the map. Anchored maps can be useful when creating dashboards that have a structured layout in a worksheet. An anchored map has a light-green title bar to indicate it is no longer floating.

Anchored map in Excel

To work with anchored maps, use the following options:

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

Rename a map

ArcGIS for Office assigns a numbered name to each new map (Map 1, Map 2, and so on) by default. To change the name of a map, click the map name in the map title bar to activate the text field, type a new name, and press Enter.

Arrange maps

To view all floating maps, click Arrange Maps Arrange maps on the ArcGIS ribbon.

All your floating maps are positioned alongside your Excel window. The windows are tiled by default. Occasionally, when there are several maps and not much screen space, the windows will cascade in the desktop area next to the spreadsheet.

Find maps

When your spreadsheet includes multiple maps (a workbook can contain two maps), the Go to Map tool helps you quickly find and display the map you want.

To find a map, do the following:

  1. On the ArcGIS ribbon, click Go to Map.

    The Go to Map window appears, 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.

  2. Click the map you want to display.

    The Go to Map window closes and the map is selected. A selected map has a yellow border. If the map was minimized or collapsed, ArcGIS for Office expands it.

Resize a map

To resize a floating or anchored map, hover the mouse pointer over the map window's border to display the resize controls, and click to resize the window.

Note:

To provide optimal performance and usability, the map size is restricted to a minimum of 684 pixels wide by 369 pixels high.