2

In VBA this can be easily done using the range.calculate command. Once somebody showed me how to do it in Excel with a keyboard shortcut but I do not remember it any more. I have been searching the internet Unsuccessfully to find the shortcut.

Does anybody know the keyboard shortcut to calculate a pre-selected range in Excel?

George

1 Answer 1

3

You should specify your version. In Excel 2003 the closest you can come is to calculate your active sheet using shift+F9 (Just F9 will calculate the whole book).

You can create a macro though that activates Range.Calculate and give that macro a hotkey. You can place that macro in your personal workbook so that it will work no matter what workbooks you have open.

3
  • I am using Excel 2003 and I believe that there is an Excel build-in keyboard shortcut to calculate a preselected range. My apologies if such functionality does not exist but I remember seeing it once in the past...
    – George
    Aug 26, 2010 at 15:22
  • 1
    @George: This is a comprehensive list of all excel 2003 shortcuts. There is no hotkey in excel 2003 to do what you want, but you can make a new hotkey to do this if you wish.
    – Jarvin
    Aug 26, 2010 at 15:34
  • Thank you Dan, you are right, your original answer was the actual answer to the question. Thank you very much for looking into this. George
    – George
    Aug 26, 2010 at 21:03

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .