Shortcut keys useful in Microsoft excel

 

For formula tab

(File➪ Options➪ Formulas or Alt+FTF)

are divided into Calculation Options, Working with Formulas, Error Checking, and Error Checking Rules.

open a file

Press Ctrl+O to open a file for editing and the Save As screen.

save a new workbook.    

 When you press Ctrl+S or select the Save button on the Quick Access toolbar to save a new workbook.

Calculate Now (F9).

Calculate Sheet (Shift+F9).

Close the excel file

Close it right away by pressing Ctrl+W, 

choosing File➪ Close, or pressing Alt+FC

Save the file

Click the Save button on the Quick Access toolbar (the one with the disk icon), or choose

 File➪ Save  

from the File menu button, or press Ctrl+S