#Shortcut Key for Microsoft Excel 1...

Shortcut Key for Microsoft Excel 1

COMMANDFUNCTION
CTRL+(   Unhides any hidden rows within the selection.

CTRL+)  Unhides any hidden columns within the selection.

CTRL+&  Applies the outline border to the selected cells.

CTRL+_   Removes the outline border from the selected cells.

CTRL+~  Applies the General number format.

CTRL+$   Applies the Currency format with two decimal places (negative numbers in parentheses).

CTRL+%  Applies the Percentage format with no decimal places.

CTRL+^  Applies the Exponential number format with two decimal places.

CTRL+#  Applies the Date format with the day, month, and year.

CTRL+@   Applies the Time format with the hour and minute, and AM or PM.

CTRL+! V Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

CTRL+-  Displays the Delete dialog box to delete the selected cells.

CTRL+*  Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).

CTRL+:   Enters the current time.

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+"   Copies the value from the cell above the active cell into the cell or the Formula Bar.

CTRL++   Displays the Insert dialog box to insert blank cells.

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+7. Displays or hides the Standard toolbar.

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.

CTRL+B. Applies or removes bold formatting.

CTRL+C.  Copies the selected cells.

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 dialog box.

CTRL+G.  Displays the Go To dialog box.

CTRL+H. Displays the Find and Replace dialog box.

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+L. Displays the Create List dialog box.

CTRL+N. Creates a new, blank file.

CTRL+O. Displays the Open dialog box to open or find a file.

CTRL+P. Displays the Print dialog box.

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+U. Applies or removes underlining.

CTRL+V. Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you cut or copied an object, text, or cell contents.

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. Undo-command to reverse the last command or to delete the last entry you typed.

CTRL+SHIFT+Z.  Undo or Redo-command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.