click below
click below
Normal Size Small Size show me how
Excel 2010 Shortcuts
Term | Definition |
---|---|
Arrow Keys | Move one cell up, down, left or right in a worksheet |
Page Down/ Page Up | Move one screen to the right/to the left in a worksheet |
Alt+Page Down/Alt+Page Up | Move one screen to the right / to the left in a worksheet |
Tab/Shift+Tab | Move one cell to the right / to the left in a worksheet |
Ctrl+Arrow Keys | Move to the edge of next data region (cells that contains data) |
Home | Move to the beginning of a row in a worksheet |
Ctrl+Home | Move to the beginning of a worksheet |
Ctrl+End | Move to the last cell with content on a worksheet |
Ctrl+f | Display the Find and Replace dialog box (with Find selected) |
Ctrl+h | Display the Find and Replace dialog box (with Replace selected) |
Shift+F4 | Repeat last find |
Ctrl+g (or f5) | Display the 'Go To' dialog box |
Ctrl+Arrow Left/Ctr l+Arrow Right | Inside a cell: Move one word to the left / to the right. |
Home/End | Inside a cell: Move to the beginning / to the end of a cell entry. |
Alt+Arrow Down | Display the AutoComplete list e.g. in cell with dropdowns or autofilter |
End | "Turn 'End' mode on. In End mode, press arrow keys to move to the next nonblank cell in the same column or row as the active cell." |
Shift+Space | Select the entire row |
Ctrl+Space | Select the entire column |
Ctrl+Shift+* (asterisk) | Select the current region around the active cell |
Ctrl+a (or ctrl+Shift +spacebar) | "Select the entire worksheet or the data-containing area. Pressing ctrl+a a second time then selects entire worksheet." |
Ctrl+Shift+Page Up | Select the current and previous sheet in a workbook |
Ctrl+Shift+o | Select all cells with comments. |
Shift+Arrow Keys | Extend the selection by one cell |
Ctrl+Shift+Arrow Key | Extend the selection to the last cell with content in row or column |
Shift+Page Down/Shift+Page Up | Extend the selection down one screen /up one screen. |
Shift+Home | Extend the selection to the beginning of the row. |
Ctrl+Shift+Home | Extend the selection to the beginning of the worksheet. |
F8 | Turn on extension of selection with arrow keys without having to keep pressing shift. |
Shift+F8 | "Add another (adjacent or non-adjacent) range of cells to the selection. Use arrow keys and shift+arrow keys to add to selection." |
Shift+Backspace | Select only the active cell when multiple cells are selected. |
Ctrl+Backspace | Show active cell within selection. |
Ctrl+. (period) | Move clockwise to the next corner of the selection. |
Enter/Shift+Enter | Move active cell down / up in a selection. |
Tab/Shift+Tab | Move active cell right / left in a selection |
"Ctrl+Alt+Arrow Right/Ctrl+Alt+Arro w Left" | Move to the right / to the left between non-adjacent selections (with multiple ranges selected). |
Esc | Cancel Selection. |
Shift+Arrow Left/Shift+Arrow Right | Select or unselect one character to the left / to the right |
"Ctrl+Shift+Arrow Left/Ctrl+Shift+Arr ow Right" | Select or unselect one word to the left / to the right. |
Shift+Home/Shift+End | Select from the insertion point to the beginning / to the end of the cell |
Ctrl+z | Undo last action (multiple levels). |
Ctrl+y | Redo last action (multiple levels). |
Ctrl+c | Copy contents of selected cells |
Ctrl+x | Cut contents of selected cells |
Ctrl+v | Paste content from clipboard into selected cell |
Ctrl+Alt+v | If data exists in clipboard: Display the Paste Special dialog box |
Ctrl+Shift+[[]+[[] | If data exists in clipboard: Display the Insert dialog box to insert blank cells |
F2 | Edit the active cell with cursor at end of the line. |
Alt+Enter | Start a new line in the same cell |
Enter | Complete a cell entry and move down in the selection. With multiple cells selected: fill cell range with current cell |
Shift+Enter | Complete a cell entry and move up in the selection |
Tab/Shift+Tab | Complete a cell entry and move to the right / to the left in the selection |
Esc | Cancel a cell entry |
Backspace | Delete the character to the left of the insertion point, or delete the selection |
Delete | Delete the character to the right of the insertion point, or delete the selection |
Ctrl+Delete | Delete text to the end of the line |
Ctrl+; (semicolon) | Insert current date |
Ctrl+Shift+: (colon) | Insert current time |
Ctrl+d | Fill complete cell down (Copy above cell). |
Ctrl+r | Fill complete cell to the right (Copy cell from the left). |
Ctrl+" | Fill cell values down and edit (Copy above cell values). |
Ctrl+' (apostrophe) | Fill cell formulas down and edit (Copy above cell formulas). |
Ctrl+l | Insert a table (display Create Table dialog box). |
Ctrl+- | Delete Cell/Row/Column Menu |
Ctrl+- with row / column selected | Delete row / delete column |
Ctrl+Shift++ | Insert Cell/Row/Column Menu |
Ctrl+Shift++ with row / column selected | Insert row/ insert column |
Shift+F2 | Insert / Edit a cell comment |
Shift+f10, then m | Delete comment |
Alt+F1 | Create and insert chart with data in current range as embedded Chart Object |
F11 | Create and insert chart with data in current range in a separate Chart sheet |
Ctrl+k | Insert a hyperlink |
Ctrl+9 | Hide the selected rows |
Ctrl+Shift+9 | Unhide any hidden rows within the selection |
Ctrl+0 (zero) | Hide the selected columns |
Ctrl+Shift+0 (zero) | Unhide any hidden columns within the selection*. |
Ctrl+` (grave accent) | Alternate between displaying cell values and displaying cell formulas. Accent grave /not a quotation mark. |
Alt+Shift+Arrow Right | Group rows or columns |
Alt+Shift+Arrow Left | Ungroup rows or columns |
Ctrl+6 | Alternate between hiding and displaying objects |
Ctrl+8 | Display or hides the outline symbols. |
Ctrl+6 | Alternate between hiding objects, displaying objects, and displaying placeholders for objects. |
Ctrl+1 | Format cells dialog. |
Ctrl+b (or ctrl+2) | Apply or remove bold formatting |
Ctrl+u (or ctrl+4) | Apply or remove an underline |
Ctrl+5 | Apply or remove strikethrough formatting |
Ctrl+Shift+f | Display the Format Cells with Fonts Tab active. Press tab 3x to get to font-size. Used to be ctrl+shift+p, but that seems just get to the Font Tab in 2010. |
Alt+' (apostrophe / single quote) | Display the Style dialog box. |
Ctrl+Shift+$ | Apply the Currency format with two decimal places |
Ctrl+Shift+~ | Apply the General number format |
Ctrl+Shift+% | Apply the Percentage format with no decimal places |
Ctrl+Shift+# | Apply the Date format with the day, month, and year. |
Ctrl+Shift+@ | Apply the Time format with the hour and minute, and indicate A.M. or P.M. |
Ctrl+Shift+! | Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values |
Ctrl+Shift+^ | Apply the Scientific number format with two decimal places. |
F4 | Repeat last formatting action: Apply previously applied Cell Formatting to a different Cell |
Ctrl+Shift+& | Apply outline border from cell or selection |
Ctrl+Shift+_(underscore) | Remove outline borders from cell or selection |
Ctrl+1, then Ctrl+Arrow Right/Arrow Left | Access border menu in 'Format Cell' dialog. Once border was selected, it will show up directly on the next Ctrl+1 |
Alt+t* | Set top border |
Alt+b* | Set bottom Border |
Alt+l* | Set left Border |
Alt+r* | Set right Border |
Alt+d* | Set diagonal and down border |
Alt+u* | Set diagonal and up border |
'= | Start a formula |
Alt+= | Insert the AutoSum formula |
Shift+F3 | Display the Insert Function dialog box |
Ctrl+a | Display Formula Window after typing formula name |
Ctrl+Shift+a | Insert Arguments in formula after typing formula name. |
Shift+F3 | Insert a function into a formula |
Ctrl+Shift+Enter | Enter a formula as an array formula |
F4 | After typing cell reference (e.g. =E3) makes reference absolute (=$E$4) |
F9 | Calculate all worksheets in all open workbooks |
Shift+F9 | Calculate the active worksheet. |
Ctrl+Alt+F9 | Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation |
Ctrl+Alt+Shift+F9 | Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated |
Ctrl+Shift+u | Toggle expand or collapse formula bar. |
Ctrl+` | Toggle Show formula in cell instead of values |
Ctrl+F3 | Define a name or dialog |
Ctrl+Shift+F3 | Create names from row and column labels |
F3 | Paste a defined name into a formula |
Shift+F11/Alt+Shift+F1 | Insert a new worksheet in current workbook |
Ctrl+Page Down/Ctrl+Page Up | Move to the next / previous worksheet in current workbook. |
Alt+o then h r | Rename current worksheet (format, sheet, rename) |
Alt+e then l | Delete current worksheet (Edit, delete) |
Alt+e then m | Move current worksheet (Edit, move) |
F6/Shift+F6 | Move to the next pane / previous pane in a workbook that has been split |
Ctrl+F4 | Close the selected workbook window |
Ctrl+n | Create a new blank workbook (Excel File) |
Ctrl+Tab/Ctrl+Shift+Tab | Move to next / previous workbook window. |
Alt+Space | Display the Control menu for Main Excel window |
Ctrl+F9 | Minimize current workbook window to an icon. Also restores ('un-maximizes') all workbook windows |
Ctrl+F10 | Maximize or restores the selected workbook window. |
Ctrl+F7 | Move Workbook Windows which are not maximized |
Ctrl+F8 | Perform size command for workbook windows which are not maximzed. |
Alt+F4 | Close Excel. |
Ctrl+o | Open File. |
Ctrl+s | Save the active file with its current file name, location, and file format. |
F12 | Display the Save As dialog box. |
f10 (or alt) | Turn key tips on or off. |
Ctrl+p | Print File (Opens print menu). |
F1 | Display the Excel Help task pane |
F7 | Display the Spelling dialog box |
Shift+F7 | Display the Thesaurus dialog box. |
Alt+F8 | Display the Macro dialog box |
Alt+F11 | Open the Visual Basic Editor to create Macros |
Ctrl+F1 | Minimize or restore the Ribbon.s |
Shift+F10 | Display the shortcut menu for the selected command. |
Ctrl+Page Down | Move to a new record |
Ctrl+Page Up | Move to the first record |
Alt+c | Move the selected field into the Column area. |
Alt+d | Move the selected field into the Data area. |
Alt+l | Display the PivotTable Field dialog box. |
Alt+p | Move the selected field into the Page area |
Alt+r | Move the selected field into the Row area. |
Ctrl+o | Open File |
Ctrl+s | Save the active file with its current file name, location, and file format. |
F12 | Display the Save As dialog box |
F7 | Display the Spelling dialog box. |
Shift+F7 | Display the Thesaurus dialog box |
Alt+F8 | Display the Macro dialog box |
Alt+F11 | Open the Visual Basic Editor to create Macros |
Ctrl+F1 | Minimize or restore the Ribbon.s |
Shift+F10 | Display the shortcut menu for the selected command. |
Alt+Arrow Down | On the field with column head, display the AutoFilterlist for the current column . |