Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Drill-down to Cell or Row Details

Explains how to drill-down to source of the data in cells and rows.

When you are connected to Adaptive Insights, you can drill-down to the data behind the value in cells or rows. 

Find  Formulas

Italicized text indicates that the value was entered with a formula. You can see the formula behind the value: 

  1. Verify that you are connected to Adaptive Insights and that the cell has a calculated value (the text should be italics).  
  2. If the Planning pane is not visible, click the Planning tab and click the checkbox next to Show Planning Pane, even if it's already selected. 
  3. From the Planning pane, click the Information tab. If the cell has an Adaptive Insights formula it appears under Cell info. 

Cells with bold text or light blue backgrounds, although calculated, don't have formulas because the formulas were not manually entered by another user. Bold text cells are automatic totals, and cells with blue backgrounds are rollup values. Use Cell Explorer to understand the origins of the value.

Use Cell Explorer

You can explore the details of a cell with Cell Explorer, even when its value wasn't calculated. 

Verify that you are connected to Adaptive Insights. Then, right-click on a cell and click Adaptive > Explore Cell. Details about the cell opens in your browser with information about the cell and links to even deeper information. 

Use Row Details

For modeled sheets (learn how to identify sheet types), you can explore either the cell or the row. 

Verify that you are connected to Adaptive Insights. Then, right-click on any cell in the row. Click Adaptive > Row Details. Details about the row opens in your browser with information about the row and links to deeper information. 

  • Was this article helpful?