
Ms Excel Shortcut Keys
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. |
+ ����� – |
CTRL+1 |
Displays the Format Cells dialog box. |
+ ����� – |
CTRL+2 |
Applies or removes bold formatting. |
+ ����� – |
CTRL+3 |
Applies or removes italic formatting. |
+ ����� – |
CTRL 4 |
Applies or removes underlining in Microsoft Excel. |
+ ����� – |
CTRL+5 |
Others

