All the users, involved in the calculation with Excel, prefer to work conveniently and if some shortcuts are available, they welcome these rather warmly. 41 shortcuts, placed below, are selected from the hundreds of the keyboard shortcuts for the Excel 2010 available. These shortcuts are specifically designed by Microsoft inserted into the Excel to facilitate:
1 Calculation
2 Data Manipulation
3 Insertion of Formulas
4 Calculation with the help of formulas
5 Calculation of whole the worksheet, simultaneously
Users willing to work on Excel may find them very useful.
| 1 | Enter | It would complete a cell entry and would select the next cell |
| 2 | Alt+Enter | To start a new line in the same cell, apply this |
| 3 | Ctrl+Enter | It would fill the entire selected cell range with the current entry |
| 4 | Shift+Enter | It would complete a cell entry but would select the next cell above |
| 5 | Tab | To complete a cell entry and to select the next cell to the right, apply this |
| 6 | Shift+Tab | To complete a cell entry and but to select the previous cell to the left |
| 7 | Esc | Apply this to cancel a cell entry |
| 8 | Arrow keys | These keys are applied to move one character up, down, left or right |
| 9 | Home | To move cursor to the start of the line |
| 10 | F4 or Ctrl+Y | To repeat the last action, apply this |
| 11 | Ctrl+Shift+F3 | It is used to create names from row and column labels |
| 12 | Ctrl+D | It fill down |
| 13 | Ctrl+R | IT is used to fill to the right |
| 14 | Ctrl+F3 | It helps to define a name |
| 15 | Ctrl+K | Use this to insert a hyperlink |
| 16 | Ctrl+; (semicolon) | Apply this to enter the date |
| 17 | Ctrl+Shift+: (colon) | Apply this to enter the time |
| 18 | Alt+down arrow | To display a drop-down list of the values, entered in the current column of a range |
| 19 | Ctrl+Z | Apply to undo the last action |
| 20 | = (equal sign) | Users use this Start a formula |
| 21 | Backspace | To delete one character to the left in formula bar |
| 22 | Enter | Press this to complete an entry in cell or formula bar |
| 23 | Ctrl+Shift+ Enter | May enter a formula as an array formula |
| 24 | Esc | It would cancel an entry in the cell or formula bar |
| 25 | Shift+F3 | It would display the Insert Function dialog box in formula bar |
| 26 | Ctrl+A | It would display Function Argument dialog box at the insertion point to the right of a function name in a formula |
| 27 | Ctrl+Shift+A | To enter the argument names at the insertion point to the right of a function name in a formula |
| 28 | F3 | It would paste a defined name into a formula |
| 29 | Alt+= (equal sign) | To insert an AutoSum formula with the SUM function, apply it |
| 30 | Ctrl+Shift+” (quotation mark) | To copy the value from the cell, above the active cell into the cell or the formula bar |
| 31 | Ctrl+’ (apostrophe) | To copy a formula from the cell, above the active cell into the cell or formula bar |
| 32 | Ctrl+` (backtick) | This is an alternate between displayed cell values & displayed formulas. |
| 33 | F9 | It would calculate all entries in all open workbooks |
| 34 | Enter or Ctrl+Shift+Enter (for array formulas) | With selected formula, calculate the selected portion and apply to replace the selected portion with the calculated value |
| 35 | Shift+F9 | It would calculate the active worksheet |
| 36 | Ctrl+Alt+F9 | It would calculate all worksheets in all open workbooks |
| 37 | Ctrl+Alt+Shift+F9 | Recheck and calculate all dependent formulas in all open workbooks |
| 38 | F2 | It would edit the active cell and position the insertion point at the end of the cell contents |
| 39 | Shift+F2 | It may help to edit a cell comment |
| 40 | Ctrl+Shift+Z | It undo or redo when AutoCorrect smart tag is displayed |
| 41 | Ctrl+- (hyphen) | It would delete the selected cells |
| 42 | Ctrl+Shift++ (plus sign) | It would insert blank cells. |
| 43 | Alt+’ (apostrophe) | To display Style dialog box, apply this shortcut |
| 44 | Ctrl+1 | It would display format Cells dialog box |
| 45 | Ctrl+Shift+~ | It may apply the General number format |
| 46 | Ctrl+Shift+$ | To apply currency format with two decimal places |
| 47 | Ctrl+Shift+% | It would add Percentage format with no decimal places |
| 48 | Ctrl+Shift+^ | Apply the Exponential number format with two decimal places |
| 49 | Ctrl+Shift+# | Apply the Date format with the day, month, and year |
| 50 | Ctrl+Shift+@ | Apply the Time format with the hour and minute and AM or PM. |
| 51 | Ctrl+Shift+! | Apply the Number format with two decimal places (thousands separator and minus sign (-) for negative values |
| 55 | Ctrl+5 | It is used to apply or remove strikethrough |
| 56 | Ctrl+9 | It would hide the selected rows |
| 57 | Ctrl+Shift+(opening parenthesis) | It would unhide any hidden rows within the selection |
| 58 | Ctrl+0 (zero) | It can hide the selected columns |
| 59 | Ctrl+Shift+)(closing parenthesis) | Would unhide any columns, hidden columns |
| 60 | Ctrl+Shift+& | You may apply outline border to the selected cells with this comand |
| 61 | Ctrl+Shift+_(underscore) | Remove the outline border from the selected rage |