ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Explode Button to review a Formula (https://www.excelbanter.com/setting-up-configuration-excel/165986-explode-button-review-formula.html)

Pavel

Explode Button to review a Formula
 
I want to quickly review a formula written by others; in particular, the
cells it has refered to. I have seen "Explode" button in other's computer
which reveals a mini-window detailing each of the reference cells, its value
and location.

I cannot find that button in my computer. I am using excel 2003.

What can be the solution, please?

Gord Dibben

Explode Button to review a Formula
 
ToolsFormula AuditingEvaluate Formula


Gord Dibben MS Excel MVP

On Wed, 14 Nov 2007 05:01:01 -0800, Pavel
wrote:

I want to quickly review a formula written by others; in particular, the
cells it has refered to. I have seen "Explode" button in other's computer
which reveals a mini-window detailing each of the reference cells, its value
and location.

I cannot find that button in my computer. I am using excel 2003.

What can be the solution, please?




All times are GMT +1. The time now is 10:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com