Best Microsoft Excel Bloggers

Monday, May 10, 2010

A new use for F9

I hope you all had a great weekend.  My Mother's Day was excellent- in case you were wondering. Too cold to play golf so my daughter and I shopped. Fun either way.

Most people know that the F9 key allows you to recalculate your spreadsheet and can be quite useful if you have turned off automatic recalculation due to the size and/or complexity of your worksheets. If you are not familiar with it, F9 recalculates the entire file whereas Shift +F9 recalculates the current sheet.

However, this weekend I learned a new use for it from a fellow Linked-In member that I thought you might be interested in it.

If you highlight a formula or function in the formula bar and press F9, Excel will substitute that element within the formula with the result. For example, assume the sum of A1 through A10 is a value of 20. If you created the formula =SUM(A1.A10)+1 and highlighted =SUM(A1.A10) in the formula bar and then pressed F9, Excel would display 20 on the formula bar. Press F9 again, and it will revert to the calculation.
You need to select the formula name =SUM, not just the cell references.

This is a bit quicker than going to the Formula Auditing group on the Data Ribbon and selecting Evaluate Formulas.

Have a great Monday.

1 comment:

Ms. Excel- Resident Excel Geek