Excel Pragma

April 18, 2005

F9 formula in the formula bar

Filed under: General — Admin @ 7:37 am

A great tip from the Spy Journal : Using the F9 key in the formula bar in Excel

If you have a long formula in the formula bar and you want a quick way to see the results of part of the formula then you can use the F9 key. WARNING! Be careful how you use this because this will actually change the formula if you save the changes.

2 Comments

  1. Hi.

    For yet another way to view formulas, including the use of F9 for partial evaluation, check out my audxl add-in, available from my website.

    Cheers,
    Rob

    Comment by Rob van Gelder — April 18, 2005 @ 10:09 am

  2. Thanks for linking me

    Comment by spyjournal — May 2, 2005 @ 3:33 am

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.

Powered by WordPress