| Shortcut | Command | How useful |
CTRL combination shortcut keys
Microsoft Excel 2007 | ||
| CTRL+SHFT+( | Unhides any hidden rows within the selection. | + – |
| CTRL+SHFT+) | Unhides any hidden columns within the selection. | + – |
| CTRL+SHFT+& | Applies the outline border to the selected cells. | + – |
| CTRL+SHFT_ | Removes the outline border from the selected cells. | + – |
| CTRL SHFT ~ | Applies the General number format in Microsoft Excel. | + – |
| CTRL+SHFT+$ | Applies the Currency format with two decimal places (negative numbers in parentheses). | + – |
| CTRL+SHFT+% | Applies the Percentage format with no decimal places. | + – |
| CTRL+SHFT+^ | Applies the Exponential number format with two decimal places. | + – |
| CTRL+SHFT+# | Applies the Date format with the day, month, and year. | + – |
| CTRL+SHFT+@ | Applies the Time format with the hour and minute, and AM or PM. | + – |
| CTRL+SHFT+! | Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. | + – |
| CTRL+SHFT+* | Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable, it selects the entire PivotTable report. | + – |
| CTRL+SHFT+: | Enters the current time. | + – |
| CTRL+SHFT+ | Copies the value from the cell above the active cell into the cell or the Formula Bar. | + – |
| CTRL SHFT Plus ( ) | Displays the Insert dialog box to insert blank cells in Microsoft Excel. | + – |
| CTRL+Minus (-) | Displays the Delete dialog box to delete the selected cells. | + – |
| CTRL+; | Enters the current date. | + – |
| CTRL+` | Alternates between displaying cell values and displaying formulas in the worksheet. | + – |
| CTRL+' | Copies a formula from the cell above the active cell into the cell or the Formula Bar. | + – |
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response.
0 Responses
