Basic shortcuts in excel

To repeat the last action F4
To calculate the worksheet in all open workbook Ctrl+Alt+F9
To rechecks dependent formula Ctrl+Alt+Shift+F9
To define the name Ctrl+F3
To create the names in row and column Ctrl+Shift+F3
Sum Function Alt+=
To display formula Ctrl+`
To insert the argument names into formula Ctrl+Shift+A
To copy the formula from cell above Ctrl+’
To paste the name into formula F3
To evaluate the part of formula F9
To paste function into formula Shift+F3
To go to last position Ctrl+Shift+F2
To step out Ctrl+Shift+F8
To clear all breakpoints Ctrl+Shift+F9
To Enter the Formula as an Array formula Ctrl+Shift+Enter
Toggle Expand or Collapse formula bar Ctrl+Shift+U

Priyansh Minocha

Priyansh Minocha is C.E.O and Director at Amonest India Private Limited and Founder at Casolutionsglobal

Leave a Reply