Mighty F9 for formula auditing

Formula auditing tool like trace precedent/dependent are very helpful in tracing cell links in a big excel file. 

There is one more trick which can make your formula auditing little easier and that is F9 key.

In a formula press F2 to to show the cell links, then select the particular cell address and press F9.

It will show you the value of the cell

Image

 

If you select the formula within the formula of cell it will show its result.

go play….

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s