Excel 2010 Keyboard Shortcuts
| Ctrl combination shortcut keys Key | Description | Key | Description |
| CTRL+PgUp | Switches between worksheet tabs, from left-to-right. | CTRL+SHIFT+Plus (+) | Displays Insert dialog box to insert blank cells. |
| CTRL+PgDn | Switches between worksheet tabs, from right-to-left. | CTRL+Minus (-) | Displays Delete dialog box to delete selected cells. |
| CTRL+SHIFT+( | Unhides hidden rows within the selection. | CTRL+; | Enters current date. |
| CTRL+SHIFT+& | Applies outline border to selected cells. | CTRL+' | Copies a formula from the cell above the active cell into the cell or the Formula Bar. |
| CTRL+SHIFT_ | Removes outline border from selected cells. | CTRL+1 | Displays Format Cells dialog box. |
| CTRL+SHIFT+~ | Applies General number format. | CTRL+2 | Applies or removes bold formatting. |
| CTRL+SHIFT+$ | Applies Currency format with two decimal places (negative numbers in parentheses). | CTRL+3 | Applies or removes italic formatting. |
| CTRL+SHIFT+% | Applies Percentage format with no decimal places. | CTRL+4 | Applies or removes underlining. |
| CTRL+SHIFT+^ | Applies Scientific number format with two decimal places. | CTRL+5 | Applies or removes strikethrough. |
| CTRL+SHIFT+# | Applies Date format with day, month, and year. | CTRL+6 | Alternates between hiding and displaying objects. |
| CTRL+SHIFT+@ | Applies Time format with the hour and minute, and AM or PM. | CTRL+8 | Displays or hides the outline symbols. |
| CTRL+SHIFT+! | Applies Number format with two decimal places, thousands separator, and minus sign (-) for negative values. | CTRL+9 | Hides selected rows. |
| CTRL+SHIFT+* | Selects current region around active cells. In PivotTables, it selects entire PivotTable reports. | CTRL+0 | Hides the selected columns. |
| CTRL+SHIFT+: | Enters the current time. | CTRL+A | Selects entire worksheet. |
| CTRL+` | Alternates between displaying cell values and displaying formulas. | CTRL+SHIFT+A | Inserts argument names and parentheses when insertion point is to the right of function names in formulas. |
| CTRL+SHIFT+" | Copies value from cell above an active cell into the cell or the Formula Bar. | CTRL+B | Applies or removes bold formatting. |
0 comments:
Post a Comment