Excel 2007 Keyboard Shortcuts Category Where used Shortcut 1 KeyTips --- --- 2 KeyTips Workbook Office Button KeyTip shortcuts 3 KeyTips Ribbons Ribbon KeyTip shortcuts 4 Alpha --- --- 5 Alpha Cells / Worksheet Ctrl+A 6 Alpha Text Ctrl+B 7 Alpha Cell(s) / Objects Ctrl+C 8 Alpha Cells Ctrl+D 9 Alpha Worksheet Ctrl+F 10 Alpha Worksheet Ctrl+G 11 Alpha Worksheet Ctrl+H 12 Alpha Text Ctrl+I 13 Alpha Cells Ctrl+K 14 Alpha Workbook Ctrl+N 15 Alpha Workbook Ctrl+O 16 Alpha Worksheet Ctrl+P 17 Alpha Cells Ctrl+R 18 Alpha Workbook Ctrl+S 19 Alpha Cells Ctrl+T 20 Alpha Text Ctrl+U 21 Alpha Cells Ctrl+V 22 Alpha Workbook Ctrl+W 23 Alpha Cell(s) / Objects Ctrl+X 24 Alpha Workbook Ctrl+Y 25 Alpha Workbook Ctrl+Z 26 Alpha Worksheet Ctrl+Shift+O 27 Number --- --- 28 Number Worksheet Ctrl+1 29 Number Text Ctrl+2 30 Number Text Ctrl+3 31 Number Text Ctrl+4 32 Number Text Ctrl+5 33 Number Worksheet Ctrl+6 34 Number Rows / Columns Ctrl+8 35 Number Rows Ctrl+9 36 Number Columns Ctrl+0 37 Punctuation --- Explanation of Punctuation Shortcuts 38 Punctuation Columns Ctrl+Shift+0 equivalent to Ctrl+) 39 Punctuation Cells Ctrl+Shift+1 equivalent to Ctrl+! 40 Punctuation Cells Ctrl+Shift+2 equivalent to Ctrl+@ 41 Punctuation Cells Ctrl+Shift+3 equivalent to Ctrl+# 42 Punctuation Cells Ctrl+Shift+4 equivalent to Ctrl+$ 43 Punctuation Cells Ctrl+Shift+5 equivalent to Ctrl+% 44 Punctuation Cells Ctrl+Shift+6 equivalent to Ctrl+^ 45 Punctuation Cells Ctrl+Shift+7 equivalent to Ctrl+& 46 Punctuation Cells Ctrl+Shift+8 equivalent to Ctrl+* 47 PivotTable PivotTable Ctrl+Shift+8 equivalent to Ctrl+* 48 Punctuation Rows Ctrl+Shift+9 equivalent to Ctrl+( 49 Punctuation Cells Ctrl+Shift+- (Minus sign) equivalent to Ctrl+_ 50 Punctuation Cells Ctrl+Shift+' (Back single quote) equivalent to Ctrl+~ 51 Punctuation Cells Ctrl+Shift+; (Semi colon) equivalent to Ctrl+: 52 Punctuation Cells Ctrl+Shift+' (Single quote) equivalent to Ctrl+" 53 Punctuation Cells Ctrl+Shift+= equivalent to Ctrl++ (Plus) 54 Punctuation Cells Ctrl+- (Minus) 55 Punctuation Cells Ctrl+; (Semi colon) 56 Punctuation Cells Ctrl+` (Single back quote) 57 Punctuation Cells Ctrl+' (Single quote) 58 Function keys --- --- 59 Function keys Worksheet F1 60 Function keys Worksheet Ctrl+F1 61 Function keys Cells F2 62 Function keys Worksheet Ctrl+F2 63 Function keys Cells Shift+F2 64 Function keys Worksheet F3 65 Function keys Cells Shift+F3 66 Function keys Formula F4 67 Function keys Worksheet F5 68 Function keys Split window F6 69 Function keys Cells F7 70 Function keys Worksheet F7 71 Function keys Cells F8 72 Function keys Worksheet Alt+F8 73 Function keys Worksheet Shift+F8 74 Function keys Worksheet F9 75 Function keys Worksheet Ctrl+F9 76 Function keys Worksheet Shift+F9 77 Function keys Worksheet F10 78 Function keys Cell(s) / Objects Shift+F10 79 Function keys Table / database F11 80 Function keys Worksheet Alt+F11 81 Function keys Worksheet Shift+F11 82 Function keys Worksheet F12 83 Command keys Various Command key shortcuts 84 Command keys Everywhere Esc 85 Command keys Cells Enter 86 Command keys Cells Alt+Enter 87 Command keys Many places Arrow keys 88 Command keys Cells Ctrl+Arrow key 89 Command keys Cells Shift+Arrow key 90 Command keys Cells Ctrl+Shift+Arrow key 91 Command keys Cells / Worksheet Home 92 Command keys Cells / Worksheet Ctrl+Home 93 Command keys Cells / Worksheet Shift+Home 94 Command keys Cells / Worksheet Ctrl+Shift+Home 95 Command keys Cells / Worksheet End 96 Command keys Cells / Worksheet Ctrl+End 97 Command keys Cells / Worksheet Shift+End 98 Command keys Cells / Worksheet Ctrl+Shift+End 99 Command keys Cells / Worksheet Delete 100 Command keys Cells Backspace 101 Command keys Worksheet Ctrl+Backspace 102 Command keys Worksheet Page Up 103 Command keys Worksheet Page Down 104 Command keys Workbook Ctrl+Page Up 105 Command keys Workbook Ctrl+Page Down 106 Command keys Worksheet Shift+Page Up 107 Command keys Worksheet Shift+Page Down 108 Command keys Worksheet Alt+Page Up 109 Command keys Worksheet Alt+Page Down 110 Command keys Workbook Ctrl+Shift+Page Up 111 Command keys Workbook Ctrl+Shift+Page Down 112 Command keys Cells Tab 113 Command keys Cells Shift+Tab 114 Command keys Workbook Ctrl+Tab 115 Command keys Computer Alt+Tab 116 Command keys Worksheet Print Screen 117 Command keys Window Alt+Print Screen 118 Dialogue box Dialogue box Dialogue box shortcuts 119 Help window Help window Help window shortcuts 120 Help window Worksheet F1 121 Help window Help window Alt+F4 122 Tables Tables Table shortcuts 123 Task Panes Task panes Task pane shortcuts 124 Excel 2003 2003 Menu Shortcuts Excel 2003 menu shortcuts – Explanation 125 Excel 2003 File Menu Alt+F_A 126 Excel 2003 File Menu Alt+F_C 127 Excel 2003 File Menu Alt+F_D 128 Excel 2003 File Menu Alt+F_N 129 Excel 2003 File Menu Alt+F_O 130 Excel 2003 File Menu Alt+F_P 131 Excel 2003 File Menu Alt+F_S 132 Excel 2003 Edit Menu Alt+E_B 133 Excel 2003 Edit Menu Alt+E_C 134 Excel 2003 Edit Menu Alt+E_F 135 Excel 2003 Edit Menu Alt+E_G 136 Excel 2003 Edit Menu Alt+E_P 137 Excel 2003 Edit Menu Alt+E_S 138 Excel 2003 Edit Menu Alt+E_S_C 139 Excel 2003 Edit Menu Alt+E_S_N 140 Excel 2003 Edit Menu Alt+E_S_V 141 Excel 2003 Edit Menu Alt+E_S_W 142 Excel 2003 Edit Menu Alt+E_T 143 Excel 2003 Edit Menu Alt+E_U 144 Excel 2003 View Menu Alt+V_F 145 Excel 2003 View Menu Alt+V_N 146 Excel 2003 View Menu Alt+V_P 147 Excel 2003 Insert Menu Alt+I_B 148 Excel 2003 Insert Menu Alt+I_E 149 Excel 2003 Insert Menu Alt+I_I 150 Excel 2003 Insert Menu Alt+I_R 151 Excel 2003 Insert Menu Alt+I_S 152 Excel 2003 Insert Menu Alt+I_W 153 Excel 2003 Format Menu Alt+O_D 154 Excel 2003 Format Menu Alt+O_E 155 Excel 2003 Tools Menu Alt+T_A 156 Excel 2003 Tools Menu Alt+T_O 157 Excel 2003 Tools Menu Alt+T_S 158 Excel 2003 Data Menu Alt+D_F_F 159 Excel 2003 Data Menu Alt+D_L 160 Excel 2003 Data Menu Alt+D_O 161 Excel 2003 Data Menu Alt+D_S 162 Excel 2003 Window Menu Alt+W_A 163 Excel 2003 Window Menu Alt+W_N 164 165 Dealing with complexity is an inefficient and unnecessary waste of time, attention and mental energy. There is never any justification for things being complex when they could be simple. (Edward deBono) There are a few notes about this worksheet in column G. Scroll right to see them. What the Keyboard Shortcut does … KeyTips are shown on the Office Button drop-down or Ribbon when Alt or F10 is pressed. Office Button KeyTip shortcuts are explained on the Keyboard worksheet in Training File b of the JP Excel 2007 Training Files. Ribbon KeyTip shortcuts are explained on the Keyboard worksheet in Training File b of the JP Excel Training Files. Alpha shortcuts use Ctrl or Ctrl+Shift plus an alphabetical key Selects a block of contiguous cells or an entire worksheet. This shortcut is explained on the Keyboard worksheet. The hyperlink at left will take you there. Applies or removes bold formatting. Ctrl+2 does the same thing. Copies the selected cell(s) or object(s) to the Clipboard. Pressing Ctrl+C twice displays the Clipboard (but only if that option is selected in the Options drop-down at the bottom of the Clipboard task pane). Equivalent to the Fill Down command. Copies the contents and format of the top cell of a selected range into the cells below. Beware … if any of the cells in the range are non-blank, they will be overwritten with what's in the cell being filled down. Display the Find and Replace dialogue box, with the Find tab selected. Display the Go To dialogue box. F5 does the same thing. Display the Find and Replace dialogue box, with the Replace tab selected. Applies or removes italic formatting. Ctrl+3 does the same thing. Display the Insert Hyperlink dialogue box. If there is already a hyperlink in the cell, displays the Edit Hyperlink dialogue box. Opens a new workbook. Display the file Open dialogue box to select and open an Excel file. Display the Print dialogue box. Equivalent to the Fill Right command. Copies the contents and format of the left most cell of a selected range into the cells to the right. Beware … if any of the cells in the range are non-blank, they will be overwritten with what's in the cell being filled right. Saves the active workbook. Display the Create Table dialogue box to create an Excel Table . Applies or removes underline formatting. Ctrl+4 does the same thing. Paste the last copied item to (or into) the selected cell. Close the active workbook. Eqivalent to clicking on the X (close window) button at top right of workbook. If changes have been made since the file was opened, or since the last File Save command, a dialogue box asking if you want to save the changes will be displayed. Cuts the selected cell(s) or objects so they can be pasted elsewhere. Repeat the last command or action (if possible). Undo the last command or action (if possible). Selects all cells that contain comments. This is equivalent to Go To Special_Comments which can be accessed via Home(Editing)_Find & Select. Number shortcuts use Ctrl plus an alphabetical key Display the Format Cells dialogue box. Applies or removes bold formatting. Ctrl+B does the same thing. Applies or removes italic formatting. Ctrl+I does the same thing. Applies or removes underline formatting. Ctrl+U does the same thing. Applies or removes strikethrough formatting. Toggles between hiding / displaying objects and displaying placeholders for objects. Display or hide the outline symbols. Refers to outlines that have been applied to rows and / or columns via Data(Outline)_Group . Hides selected rows. Hides selected columns. Listed below are keyboard shortcuts that use Ctrl+ a punctuation character. However, many of the punctuation characters are in upper case on the keyboard, so Shift must be pressed to access them. Therefore, in Column D, shortcuts are shown in the format Ctrl+Shift+key where key is the nominal (lower case) character, e.g. a number, and the equivalent, i.e. Ctrl+(punctuation character) is shown in grey font. Unhides any hidden columns within a selection of cells or columns that includes hidden columns. Applies the Number format with two decimal places, thousands separator and minus sign (-) for negative values. Applies the Time format hh:mm with suffix AM or PM. Applies the Date format dd-mmm-yy to a cell containing a date or number that Excel can interpret as a date. Applies the Currency format with two decimal places and negative numbers in (brackets). Applies the Percentage format with no decimal places. Applies the Exponential number format with two decimal places. Puts a default outline border around selected cell(s). Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). Selects the entire PivotTable report . Unhides any hidden rows within a selection of cells in a column or selection of rows that includes hidden rows. Removes an outline border from selected cell(s). Applies the General number format , which is the default format for cells, so this shortcut is only of use in a cell or cells that have been formatted differently. Enters the current time (as set on the computer) in format hh:mm with suffix AM or PM. Copies the displayed value from the cell above the active cell into the active cell. Note: If the cell above the active cell contains a formula, it is the value that will be copied, not the formula iteself. Also see Ctrl+' Display the Insert Cells dialogue box. Display the Delete Cells dialogue box. Enters the current date (as set on the computer) in the format dd/mm/yyyy or mm/dd/yyyy. Toggles between showing formulae or their calculated results in cells that contain formulae. When formulae are displayed, cells may increase in width until Ctrl+` is pressed again. Copies a formula from the cell above the active cell into the active cell. If the cell above the active contains text instead of a formula, the text will be copied. Also see Ctrl+Shift+" Function key shortcuts can be a sigle keystroke or a function key used in combination with the Alt, Ctrl or Shift keys. Display the Help window. Does the same as double clicking a Ribbon tab, shows or hides the Ribbon. When the active cell is in Ready mode or Enter mode, puts active cell into Edit mode. Puts a worksheet into Print Preview. If there is no comment in the active cell, inserts a comment and puts the comment into edit mode. If there is a comment already in the cell, puts the comment into edit mode. Displays the Paste Name dialogue box. See further details on the Keyboard worksheet. Displays the Insert Function dialogue box. Selecting a cell or range reference in a formula and pressing F4 cycles the reference type from relative to absolute to mixed (a) to mixed (b) then back to relative … etc. Click on the hyperlink at left to see a demonstration. Displays the Go To dialogue box. F6 can only be used when a window has been split via View(Window)_Split and pressing F6 moves from one split section to the next. When a cell is in Enter or Edit mode, F7 launches a spelling check on the text in the cell. When active cell is in Ready mode, F7 launches a spelling check on the whole worksheet. Only works when a cell is in Ready mode and turns Extend Selection on or off. Displays the Macro dialogue box. Allows selecting non-adjacent cells when a worksheet is in Extend Selection mode. F9 is the calculate now key, causes all formulae on all worksheets in open Excel files to calculate. Only necessary when calculation is set to Manual in Excel Options. Minimises a workbook to an icon on the Task Bar. Calculates the active worksheet. Turns KeyTips on or off. For details on KeyTips click on the hyperlink at left. Does the same as right clicking a cell or object, displays a shortcut or pop-up menu. When the active cell is in a suitable table or database, pressing F11 creates a chart. Opens the Visual Basic Editor. Inserts and selects a new worksheet. Displays the Save As dialogue box. These keys command Excel to do something other than put a character into a cell. Command keys are explained on the Keyboard worksheet. Hyperlinks in Column D below will take you to the relevant section on that worksheet. Esc (Escape) is the "get out" key. Completes an editing process. Moves to the next cell. Starts a new line of text in a cell. Arrow keys and their shortcuts can do many things. See Keyboard worksheet. Moves to the edge of a data region. Selects cells. Selects from active cell to edge of region. Moves to home position of cell or row in cell or on worksheet. Moves to home position of cell or worksheet. Moves to home position of cell or row in cell or on worksheet, selecting characters or cells as it goes. Moves to home position of cell or worksheet, selecting characters or cells as it goes. Moves to end position of cell or row in cell. Moves to end position of cell or worksheet. Moves to end position of cell or row in cell or on worksheet, selecting characters or cells as it goes. Moves to end position of cell or worksheet, selecting characters or cells as it goes. Deletes selected character to right of insertion point, cell, range or object. Delete character to left of insertion point. Returns to active cell after scrolling workheet using scroll bars or mouse wheel. Moves up one page on the active worksheet. Moves down one page on the active worksheet. Moves to previous worksheet in a workbook. Moves to next worksheet in a workbook. Selects from active cell to one page up. Selects from active cell to one page down. Scrolls active worksheet one page to the left. Scrolls active worksheet one page to the right. Selects (groups) active worksheet and previous worksheet. Selects (groups) active worksheet and next worksheet. Moves active cell one cell to the right. Moves between unprotected cells on a protected worksheet. Moves active cell one cell to the left. Cycles through open workbooks. Cycles through open applications on the computer. Copies picture of Excel screen to the Clipboard. Copies active window or dialogue box to the Clipboard. To see a list of shortcuts that can be used in Dialogue boxes, display the Help window and type "Ribbon, Help," into the search field, then select the topic Ribbon, Help, and other Microsoft Office keyboard shortcuts. To see a list of shortcuts that can be used in the Help window, display the Help window and type "Ribbon, Help," into the search field, then select the topic Ribbon, Help, and other Microsoft Office keyboard shortcuts. Display the Help window. Close Help window. To see a list of shortcuts that can be used in Tables, display the Help window and type "Ribbon, Help," into the search field, then select the topic Ribbon, Help, and other Microsoft Office keyboard shortcuts. To see a list of shortcuts that can be used in Task panes, display the Help window and type "Ribbon, Help," into the search field, then select the topic Ribbon, Help, and other Microsoft Office keyboard shortcuts. Listed below are some of the Excel 2003 menu shortcuts that work in Excel 2007. If the Alt+F shortcuts are used, the Office Button drop-down (showing KeyTips) will be displayed. If Alt+W shortcuts are used, the View Ribbon (showing KeyTips) will be displayed. Most (but not all) KeyTips are the same as the accelerator keys that were shown in Excel 2003 menus. Display the file Save As dialogue box. Close the active workbook. If changes have been made since the file was opened, or since the last File Save command, a dialogue box asking if you want to save the changes will be displayed. In Excel 2007 this shortcut displays a two item menu on the right side of the Office Button drop- down. This allows selecting E for email or X for Internet fax service. In Excel 2003 it displayed a sub-menu with several options. Open a new Excel workbook. Ctrl+N does the same thing. Display file Open dialogue box. Ctrl+O does the same thing. Display the Print dialogue box. Ctrl+P does the same thing. Save the active workbook. Ctrl+S does the same thing. Display the Office Clipboard. Copy. Ctrl+C does the same thing. Display the Find and Replace dialogue box with the Find tab selected. Ctrl+F does the same thing. Display the Go To dialogue box. Ctrl+G does the same thing. Paste. Ctrl+V does the same thing. Display the Paste Special dialogue box. Pressing an accelerator key from the dialogue box will perform that action. See a few examples in Column D (they start with Alt+E_S ). Paste Special_Comments . Used after copying a cell containing a comment, to paste just the comment into the destination cell without affecting anything else that is in the cell. Paste Special_Data Validation . Used after copying a validated cell, to paste the same data validation into the destination cell without affecting anything else that is in the cell. Paste Special_Values. Used after copying a formula to paste the calculated value into the same cell, i.e. replace the formula with a value. Paste Special_Columns widths. Used after copying column(s) to paste the same column widths in other columns. Cut. Ctrl+X does the same thing. Undo, but only if something has been done that can be undone, e.g. something was deleted. Ctrl+Z does the same thing. Hide / show the Formula Bar. Display the active worksheet in Normal view. Display the active worksheet in Page Break Preview view. Insert Page Break above and to the left of the active cell. Alt+I_B again in the same cell removes the page break. Display the Insert Cells dialogue box. Display the Insert Hyperlink dialogue box. If there is already a hyperlink in the cell, displays the Edit Hyperlink dialogue box. Ctrl+K does the same thing. Insert a row above the row of the active cell. Display the Insert Symbol dialogue box. Symbols are characters from other character sets, e.g. Wingdings symbols ... Insert a worksheet. An easier way to do this in Excel 2007 is to click on the Insert Worksheet button at the right of the worksheet tabs. In Excel 2003 this shortcut displayed the Conditional Formatting dialogue box, but in Excel 2007 it displays the Conditional Formatting Rules Manager dialogue box. Display the Format Cells dialogue box. Ctrl+1 does the same thing. Display the AutoCorrect dialogue box. In Excel 2003 this shortcut displayed the Options dialogue box. In Excel 2007 this shortcut displays the quite different looking Excel Options window (that still has most of the same options on it). Perform a spelling check within a cell that is in Enter or Edit mode or for an entire worksheet when the active cell is in Ready mode . F7 does the same thing. Toggle AutoFilter on or off in a database (the second F in the shortcut is because Alt+D_F in Excel 2003 displayed a sub-menu on which the accelerator key F was AutoFilter). Display the Data Validation dialogue box. Display a data entry form with fields for the column headings in a database. Display the (custom) Sort dialogue box. Display the Arrange Windows dialogue box, which allows displaying two or more worksheet windows (from the same or different workbooks) on screen at the same time. Open a new window (used when two windows of the same workbook are to be arranged on the screen). Knowing some keyboard shortcuts (if you are a proficient keyboard user) is often helpful and saves mouse clicks … but trying to remember too many is an unnecessary waste of time. My advice is to learn a few that you will use often and don't worry about the others. (JP). Some notes about this worksheet To read these notes, the database at left must be sorted smallest to largest on Column A (so row heights will match the text) and the active cell must be at the top of the worksheet. . This worksheet contains some (but not all) of the keyboard shortcuts that can be used in Microsoft Office Excel 2007 (others can be found in Excel Help). It can be filtered or sorted on any column(s) from B to D and returned to the original order by sorting Column A from smallest to largest. The Categories in Column B are not Microsoft or Excel categories, they are simply categories that were assigned to group similar shortcuts on this worksheet. Entries in Column C (Where Used ) are where a listed shortcut can be used to do what is shown in Column E. However, there may an identical shortcut that can be used to do something different (or perhaps the same) in another place, e.g. in the Help window. The easiest keyboard shortcuts to remember are the Office Button and Ribbon shortcuts, because as soon as the Alt key or F10 is pressed, the KeyTips appear to guide you, so it is not really necessary to remember any of the KeyTip shortcuts. There are some shortcuts in the list at left that you may find very useful. It is therefore suggested that you browse through the shortcuts on this worksheet and make a note of any that you may find useful. Many of the shortcuts that I find useful to remember are listed on the Keyboard worksheet, and most of those have a hyperlink in Column D on this worksheet. It is therefore possible to filter for those shortcuts by filtering Column D for colour blue. The top few keyboard shortcuts that might be useful to remember are … Ctrl+X … Cut Ctrl+C … Copy Ctrl+V … Paste Alt+E_S_V … Paste Special_Values (used after copying a cell containing a formula) Ctrl+Arrow and some of the other Command Key shortcuts … filter for Command Keys in Column B at left or see the Keyboard worksheet for details. Ctrl+F … Display the Find and Replace dialogue box. Ctrl+` … Show / hide formulae F1 … Display the Help window F2 … When the active cell is in Enter or Ready mode , puts the cell into Edit mode. F4 … Change the cell reference type in a formula or function dialogue box. There is, of course, nothing stopping you from doing a Try it now … on any of the listed shortcuts – and if you don't want to use keyboard shortcuts at all, that's OK, because the mouse can be used to most things that can be done by shortcuts – and one of the easiest ways to access shortcuts using the mouse, is to right click on a cell, a range or an object. …ooo000ooo… www.jpexceltraining.com Note: There are other free Excel files that can be downloaded from the above web site.
Pages to are hidden for
"Shortcuts - JP Excel Training Files"Please download to view full document