Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?


share|improve this question
up vote 2 down vote accepted

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.

share|improve this answer
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 '10 at 15:22
@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 '10 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 '10 at 21:03

You must log in to answer this question.

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