1. Anaplan User Experience
  2. Use apps and pages in the User Experience
  3. Worksheets
  4. Grid overview
  5. Drill down in a grid
  6. Drill down a single level in a grid

You can drill down a single level into any cell that displays a value calculated by reference to other cells. This enables you to view the formula that calculates the cell's value as well as and the values of any cell the calculation references. 

You may only need to drill down a single level. However, if any value the calculation references also contains a formula or summary, you can also drill down multiple levels

You can only drill down into cells that contain a formula or a summary.  If the cell only contains a value, there's nothing to drill down into.

Drill down is available on boards and primary grids on a worksheet. You can also use drill down on a grid from the Additional insights panel if you expand the grid card.

To drill down in a grid:

  1. Right-click the cell into which you wish to drill down.
    A context menu displays.
  2. Select Drill down from the menu.
    The Drill down panel opens on the right.


  1. Select the cell into which you wish to drill down.
  2. Press F8.
    The Drill down panel opens on the right.

If you change cell selection while the panel is open, the data that displays updates to reflect the new selection.

To close the Drill down panel, click the cross in the top-right corner of the panel.


We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.