I'm used to using Alt-F9 to calculate a range of cells in Excel 2003 in the manual calculation mode. This doesn't seem to work in Excel 2007. Am I missing something? Is there a way to do this in 2007?
Thanks
I'm used to using Alt-F9 to calculate a range of cells in Excel 2003 in the manual calculation mode. This doesn't seem to work in Excel 2007. Am I missing something? Is there a way to do this in 2007?
Thanks
Hmmmmmmm....Originally Posted by josh42
Isn't it just F9?
From Help:
F9 Calculate all worksheets in all open workbooks. When a portion of a formula is selected, calculate the selected portion. You can then press ENTER or CTRL+SHIFT+ENTER (for array formulas) to replace the selected portion with the calculated value.
SHIFT+F9 Calculate the active worksheet.
CTRL+ALT+F9 Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
CTRL+ALT+SHIFT+F9 Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks