| Shortcut | Function |
| End | Moves the cursor to the last cell of row |
| Shift+End/Home | Select till last/first cell |
| Ctrl+Pageup/Pagedown | Move the cursor to first/last cell |
| Ctrl+Right/Left arrow key | Move the cursor to last/first cell in a row |
| Ctrl+Shift+Arrow | Select till end row/colm |
| Ctrl+/ | Select the matrix formula |
| Ctrl+ + | Insert cells(row/colm) |
| Ctrl+ - | Delete the cell(Row/colm) |
| Enter | Moving cursor to next cell |
| Ctrl+` | Show/Hide the formula |
| F2 | Rename the cell |
| Ctrl+F1 | Select the colm that is applied in formula |
| Ctrl+F2 | Open function wizard |
| F4 | Freez the cell(Convert the cell into Absolute) |
| F5 | Show/Hide navigator |
| Shift+F5 | Traces dependents |
| Shift+F7 | Traces precedents |
| F7 | Spelling & Grammar |
| Ctrl+f7 | Thesaurusus |
| Ctrl+F9 | Update Select chart |
| F11 | Formating |
| F12 | Groups the selected data range |
| Ctrl+1 | Open formate cells |
|
Comments
Post a Comment