[OVERLINE]Keyboard Shortcuts for Microsoft Excel[/OVERLINE]
Ctrl + O Open existing fileCtrl + N Create new workbook Ctrl + S Save current workbook Ctrl + F4 Close current workbook Ctrl + Z Undo last action Ctrl + Y Redo last action Ctrl + C Copy selection Ctrl + X Cut selection Ctrl + V Paste selction Ctrl + P Print (displays print menu and options) Ctrl + S Save fileF12Save file as Enter Complete cell data entry and move to cell below.Ctrl + Shift + EnterEnter/create array formula Alt + Enter Start new line in the same cell. Ctrl + Enter Fill selected cell range with current entry. Shift + Enter Complete cell data entry and move to cell directly above current cell. TabComplete cell data entry and move to the cell to the right. Shift + Tab Complete cell data entry and move to the cell to the left. EscCancel a cell entry and go back to what was there before. Arrow Keys Move one cell left, right, up, or down. HomeMove to the first column (A). F4 / Ctrl + Y Repeat last action. Ctrl + Shift + F3 Create names for row and column labels. Ctrl + D Fill down. Ctrl + R Fill to the right. Ctrl + F3 Define a name for a cell or range of cells. Ctrl + K Insert a hyperlink. Enter (after insertion of hyperlink) Activate a hyperlink. Ctrl + ;Enter the current date. Ctrl + Shift + :Enter the current time. Alt + Down Arrow Display a drop-down list of the values in the current column of a list. Ctrl + Z Undo the last action. Alt + F8 Displays macro dialog box. Alt + F11 Displays the visual basic editor. Ctrl + F11 Inserts an Excel 4.0 macro sheet.
F2 Edit highlighted cell - cursor is at the end of cell contents. Alt + Enter Start a new line in the same cell. BackspaceWhen cell is highlighted, deletes cells contents. DeleteDeletes cells contents if cell is highlighted. Ctrl + Delete Deletes text to the end of the line. F7Runs spell-check.Shift + F2 Inserts and edits comments.EnterCompletes cell entry and moves to cell below. Ctrl + Z Undo last action. EscCancel a cell entry, previous contents are restored. Ctrl + Shift + Z When the autocorrect smart tags is displayed, undo or redo the last automatic correction. Ctrl + C + Ctrl + C Displays the clipboard (where copied items are). Ctrl + - Removes/deletes selected cells from the sheet. Ctrl + Shift + "+" Inserts blank cells.
Alt + 'Display style dialog box. Ctrl + 1 Display format cells dialog box. Shift + SpacebarHighlight rowCtrl + SpacebarHighlight columnCtrl + Shift + ~Apply the 'general number' format to selected cells. Ctrl + Shift + $ Apply the 'currency number' format with two decimal places and negative numbers showing in parentheses to selected cells. Ctrl + Shift + % Apply the 'percentage' format with no decimal places to selected cells. Ctrl + Shift + ^Apply the 'exponential number' format with two decimal places to selected cells. Ctrl + Shift + # Apply the 'date' format with the day, month, and year to selected cells. Ctrl + Shift + @ Apply the 'time' format with the hour, minute, and AM or PM to selected cells. Ctrl + Shift +!Apply the 'number' format with two decimal places, thousands seperator, and minus sign for negative numbers to selected cells. Ctrl + B Apply/remove bold format to selected cells. Ctrl + I Apply/remove italic format to selected cells. Ctrl + U Apply/remove underline to selected cells. Ctrl + 5 Apply or remove 'strikethrough' to selected cells. Ctrl + 8 Displays or hides the outline of symbols. Ctrl + 9 Hide row. Ctrl + Shift + 9Unhide row.Ctrl + Shift + ( Unhide any hidden rows within the selection. Ctrl + 0 Hide the selected columns. Ctrl + Shift + ) Unhide any columns within the selection. Ctrl + Shift + & Apply the 'border outline' to selcted cells. Ctrl + Shift + _ Remove the 'border outline' from selected cells. Alt + Shift + Right Arrow Groups selected rows or columns. Alt + Shift + Left Arrow Ungroups selected rows or columns.
Alt + F8 Displays macro dialog box. Alt + F11 Displays the visual basic editor. Ctrl + F11 Inserts an Excel 4.0 macro sheet.