Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the function of "Calculate Now" in Microsoft Excel and what is the shortcut key of "Calculate Now"?

user-image
Question added by danish shafiq , Accountant , Anayat Fan
Date Posted: 2016/06/14
Deleted user
by Deleted user

 

F9 calculation. Calculates all worksheets in all open workbooks.

 

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.

 

CTRL+F9 minimizes a workbook window to an icon.

 

SHIFT+F9 calculates the active worksheet.

CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last

More Questions Like This