Bayt.com

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"?

Accounting Computer Science Microsoft Office Computer Skills IT
user-image
Question added by danish shafiq , Accountant , Anayat Fan
Date Posted: 2016/06/14
Upvote (1) Views (0) Followers (2) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
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). :)

Write Your Answer
More Questions Like This