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
Muhammad Farooq
by Muhammad Farooq , Assistant HR , Mossassa-tu-Mariam

Its helpful in adding date and time.

Current date   Select a cell and press CTRL+;

Current time   Select a cell and press CTRL+SHIFT+;

 

Current date and time   Select a cell and press CTRL+; then SPACE then CTRL+SHIFT+;

Joel Thomas
by Joel Thomas , Auditor , DME HoldingGroup

Its manually recalculate all open worksheets, including data tables, and update all open chart sheets, on the Formulas Tab, in the Calculation group,  click the Calculate Now button. (Ctrl+shift+Alt+F9). :)

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.