4. CTRL Combinations in Excel 2007 |
| ctrl+shift+( | Unhides any hidden rows within the selection. |
| ctrl+shift+) | Unhides any hidden columns within the selection. |
| ctrl+shift+& | Applies the outline border to the selected cells. |
| ctrl+shift+_ | Removes the outline border from the selected cells. |
| ctrl+shift+~ | Applies the General number format. |
| ctrl+shift+$ | Applies the Currency format with two decimal places (negative numbers in parentheses). |
| ctrl+shift+% | Applies the Percentage format with no decimal places. |
| ctrl+shift+^ | Applies the Exponential number format with two decimal places. |
| ctrl+shift+# | Applies the Date format with the day, month, and year. |
| ctrl+shift+@ | Applies the Time format with the hour and minute, and AM or PM. |
| ctrl+shift+! | Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. |
| ctrl+shift+* | 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+shift+: | Enters the current time. |
| ctrl+shift+" | Copies the value from the cell above the active cell into the cell or the Formula Bar. |
| ctrl+shift++ | Displays the Insert dialog box to insert blank cells. |
| ctrl+- | 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. |
| ctrl+5 | Applies or removes strikethrough. |
| ctrl+6 | Alternates between hiding objects, displaying objects, and displaying placeholders for objects. |
| ctrl+8 | Displays or hides the outline symbols. |
| ctrl+9 | Hides the selected rows. |
| ctrl+0 | Hides the selected columns. |
| ctrl+a | Selects the entire worksheet. If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its summary rows. Pressing CTRL+A a third time selects the entire worksheet. |
| ctrl+shift+a | Inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula. |
| ctrl+b | Applies or removes bold formatting. |
| ctrl+c | Copies the selected cells. |
| ctrl+c | Followed by another CTRL+C displays the Clipboard. |
| ctrl+d | Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below. |
| ctrl+f | Displays the Find and Replace dialog box, with the Find tab selected. |
| ctrl+shift+f | Opens the Format Cells dialog box with the Font tab selected. |
| ctrl+g | Displays the Go To dialog box. |
| ctrl+h | Displays the Find and Replace dialog box, with the Replace tab selected. |
| ctrl+i | Applies or removes italic formatting. |
| ctrl+k | Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks. |
| ctrl+n | Creates a new, blank workbook. |
| ctrl+o | Displays the Open dialog box to open or find a file. |
| ctrl+shift+o | Selects all cells that contain comments. |
| ctrl+p | Displays the Print dialog box. |
| ctrl+shift+p | Opens the Format Cells dialog box with the Font tab selected. |
| ctrl+r | Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right. |
| ctrl+s | Saves the active file with its current file name, location, and file format. |
| ctrl+t | Displays the Create Table dialog box. |
| ctrl+u | Applies or removes underlining. |
| ctrl+shift+u | Switches between expanding and collapsing of the formula bar. |
| ctrl+v | Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents. |
| ctrl+alt+v | Displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. |
| ctrl+w | Closes the selected workbook window. |
| ctrl+x | Cuts the selected cells. |
| ctrl+y | Repeats the last command or action, if possible. |
| ctrl+z | Uses the Undo command to reverse the last command or to delete the last entry that you typed. |
| ctrl+shift+z | Uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed. |