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:
- Right-click the cell into which you wish to drill down.
A context menu displays. - Select Drill down from the menu.
The Drill down panel opens on the right.
Alternatively:
- Select the cell into which you wish to drill down.
- 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.
