Excel 2007 Shortcuts

Type what shortcut you are looking for:

- or - Learn shortcuts just-in-time and never search again!


 
ShortcutDescriptionExclusive
Ctrl+Alt+[Trace Precedents
Alt+Arrow-RightIncrease Indent
Ctrl+Shift+WWrap Text
Ctrl+Shift+7Border – Outline
Ctrl+Alt+Shift+Arrow-RightBorder – Right
Ctrl+Shift+GDecrease Font Size
Ctrl+Shift+-Border – None
Ctrl+Alt+Shift+Arrow-DownBorder – Bottom
Ctrl+Alt+Shift+Arrow-LeftBorder – Left
Ctrl+,Increase Decimal
Ctrl+Alt+Shift+Arrow-UpBorder – Top
Ctrl+.Decrease Decimal
Alt+Arrow-LeftDecrease Indent
Ctrl+Alt+]Trace Dependents
Ctrl+Alt+GGridlines Toggle
Ctrl+Alt+Arrow-LeftHide Detail
Ctrl+Alt+\Clear Arrows
Shift+F11Insert Sheet
Ctrl+Shift+FIncrease Font Size
Ctrl+Alt+Arrow-RightShow Detail
Alt+Shift+Arrow-DownSort Ascending
Alt+Shift+Arrow-UpSort Descending
Ctrl+Shift+F11Delete Sheet
Ctrl+Shift+F2Rename Sheet
Alt+Shift+LClear Filter
Alt, Y, XIndent - Team > Tree > Indent
Alt, Y, WOpen in Web Access. - Team > Work Items > Open in Web Access
Alt, Y, UOutdent - Team > Tree > Outdent
Alt, Y, TTeam Foundation Help - Team > Help > Team Foundation Help
Alt, Y, PPublish - Team > Work Items > Publish
Alt, Y, LLinks and Attachments - Team > Work Items > Links and Attachments
Alt, Y, ONew Report - Team > Reports > New Report
Alt, Y, RRefresh - Team > Work Items > Refresh
Alt, Y, NNew List - Team > Work Items > New List
Alt, Y, J, HDesign - Header & Footer Tools > Design
Alt, Y, ITeam Project Process Guidance. - Team > Help > Team Project Process Guidance
Alt, Y, JTeam Project Portal - Team > Help > Team Project Portal
Alt, Y, CChoose Columns
Alt, Y, HAdd Child - Team > Tree > Add Child
Alt, W, Z, ZZoom - View > Zoom
Alt, Y, FConfigure - Team > Work Items > Configure
Alt, Y, EEdit Areas and Iterations. - Team > Work Items > Edit Areas and Iterations
Alt, W, UUnhide - View > Window > Unhide
Alt, W, W, 11 Book1
Alt, W, V, FFormula Bar - View > Show/Hide > Formula Bar
Alt, Y, GGet Work Items - Team > Work Items > Get Work Items
Alt, W, V, SSynchronous Scrolling - View > Window > Synchronous Scrolling
Alt, W, WSwitch Windows - View > Window > Switch Windows
Alt, W, V, GGridlines - View > Show/Hide > Gridlines
Alt, W, V, HHeadings - View > Show/Hide > Headings
Alt, W, F, RFreeze Top Row
Alt, W, TReset Window Position - View > Window > Reset Window Position
Alt, W, RRuler - View > Show/Hide > Ruler
Alt, W, SSplit - View > Window > Split
Alt, W, QZoom - View > Zoom
Alt, W, PPage Layout - View > Workbook Views > Page Layout
Alt, W, M, UUse Relative References
Alt, W, M, RRecord Macro
Alt, W, KSave Workspace - View > Window > Save Workspace
Alt, W, LNormal - View > Workbook Views > Normal
Alt, W, J100% - View > Zoom > 100%
Alt, W, HHide - View > Window > Hide
Alt, W, IPage Break Preview - View > Workbook Views > Page Break Preview
Alt, W, NNew Window - View > Window > New Window
Alt, W, GZoom to Selection - View > Zoom > Zoom to Selection
Alt, W, CCustom Views - View > Workbook Views > Custom Views
Alt, W, F, FFreeze Panes
Alt, W, F, CFreeze First Column
Alt, W, DMessage Bar - View > Show/Hide > Message Bar
Alt, W, EFull Screen - View > Workbook Views > Full Screen
Alt, W, BView Side by Side. - View > Window > View Side by Side
Alt, R, P, WProtect Workbook - Review > Changes > Protect Workbook
Alt, Y, AAdd Tree Level - Team > Tree > Add Tree Level
Alt, R, WShare Workbook - Review > Changes > Share Workbook
Alt, W, AArrange All - View > Window > Arrange All
Alt, R, UAllow Users to Edit Ranges. - Review > Changes > Allow Users to Edit Ranges
Alt, R, VPrevious - Review > Comments > Previous
Alt, P, M, ACustom Margins
Alt, R, P, SProtect Sheet - Review > Changes > Protect Sheet
Alt, R, G, HHighlight Changes
Alt, R, NNext - Review > Comments > Next
Alt, R, LTranslate - Review > Proofing > Translate
Alt, R, IShow Ink - Review > Comments > Show Ink
Alt, R, G, CAccept/Reject Changes
Alt, P, Y, V, GView - Page Layout > Sheet Options > Gridlines > View
Alt, P, S, PPage Setup
Alt, R, DDelete - Review > Comments > Delete
Alt, R, EThesaurus - Review > Proofing > Thesaurus
Alt, P, Y, V, HView - Page Layout > Sheet Options > Headings > View
Alt, R, AShow All Comments - Review > Comments > Show All Comments
Alt, R, HShow/Hide Comment - Review > Comments > Show/Hide Comment
Alt, P, Y, P, HPrint - Page Layout > Sheet Options > Headings > Print
Alt, P, T, H, ASave Current Theme
Alt, P, XScale - Page Layout > Scale to Fit > Scale
Alt, P, WWidth - Page Layout > Scale to Fit > Width
Alt, P, T, H, BBrowse for Themes
Alt, P, T, H, OMore Themes on Microsoft Office Online.
Alt, P, T, F, CCreate New Theme Fonts.
Alt, P, S, ZSize - Page Layout > Page Setup > Size
Alt, P, Y, P, GPrint - Page Layout > Sheet Options > Gridlines > Print
Alt, P, T, EEffects - Page Layout > Themes > Effects
Alt, P, T, FFonts - Page Layout > Themes > Fonts
Alt, P, T, CColors - Page Layout > Themes > Colors
Alt, P, T, C, CCreate New Theme Colors.
Alt, P, S, OSheet Options - Page Layout > Sheet Options
Alt, P, A, A, TAlign Top
Alt, P, IPrint Titles - Page Layout > Page Setup > Print Titles
Alt, P, R, CClear Print Area
Alt, P, R, SSet Print Area
Alt, P, OOrientation - Page Layout > Page Setup > Orientation
Alt, P, HHeight - Page Layout > Scale to Fit > Height
Alt, P, A, YRotate - Page Layout > Arrange > Rotate
Alt, R, OProtect and Share Workbook. - Review > Changes > Protect and Share Workbook
Alt, P, B, RRemove Page Break
Alt, P, GBackground - Page Layout > Page Setup > Background
Alt, P, B, AReset All Page Breaks.
Alt, P, B, IInsert Page Break
Alt, P, A, A, CAlign Center
Alt, P, MMargins - Page Layout > Page Setup > Margins
Alt, P, A, A, RAlign Right
Alt, P, A, A, SSnap to Shape
Alt, P, A, FBring to Front - Page Layout > Arrange > Bring to Front
Alt, P, A, A, VDistribute Vertically
Alt, P, A, ESend to Back - Page Layout > Arrange > Send to Back
Alt, P, A, A, GView Gridlines
Alt, P, A, A, HDistribute Horizontally
Alt, P, A, PSelection Pane - Page Layout > Arrange > Selection Pane
Alt, P, A, GGroup - Page Layout > Arrange > Group
Alt, P, A, A, MAlign Middle
Alt, P, A, A, LAlign Left
Alt, P, A, A, PSnap to Grid
Alt, H, V, SPaste Special
Alt, P, A, A, BAlign Bottom
Alt, N, XText Box - Insert > Text > Text Box
Alt, N, V, TPivotTable
Alt, N, V, CPivotChart
Alt, N, USymbol - Insert > Text > Symbol
Alt, N, WWordArt - Insert > Text > WordArt
Alt, N, S, HShapes - Insert > Illustrations > Shapes
Alt, N, O, AAll Chart Types
Alt, N, N, AAll Chart Types
Alt, N, NLine - Insert > Charts > Line
Alt, N, PPicture - Insert > Illustrations > Picture
Alt, N, MSmartArt - Insert > Illustrations > SmartArt
Alt, N, KAll Chart Types - Insert > Charts > All Chart Types
Alt, N, JObject - Insert > Text > Object
Alt, N, HHeader & Footer - Insert > Text > Header & Footer
Alt, N, GSignature Line - Insert > Text > Signature Line
Alt, N, FClip Art - Insert > Illustrations > Clip Art
Alt, N, E, AAll Chart Types
Alt, N, EPie - Insert > Charts > Pie
Alt, N, D, AAll Chart Types
Alt, N, C, AAll Chart Types
Alt, N, DScatter - Insert > Charts > Scatter
Alt, N, CColumn - Insert > Charts > Column
Alt, N, BBar - Insert > Charts > Bar
Alt, N, B, AAll Chart Types
Alt, N, OOther Charts - Insert > Charts > Other Charts
Alt, N, A, AAll Chart Types
Alt, M, X, MManual
Alt, M, X, AAutomatic
Alt, M, WWatch Window - Formulas > Formula Auditing > Watch Window
Alt, M, VEvaluate Formula - Formulas > Formula Auditing > Evaluate Formula
Alt, M, X, EAutomatic Except for Data Tables.
Alt, M, U, MMax
Alt, M, U, FMore Functions
Alt, M, U, AAverage
Alt, M, TText - Formulas > Function Library > Text
Alt, M, U, IMin
Alt, M, SUse in Formula - Formulas > Defined Names > Use in Formula
Alt, M, RRecently Used - Formulas > Function Library > Recently Used
Alt, M, Q, SStatistical
Alt, M, Q, IInformation
Alt, M, Q, EEngineering
Alt, M, Q, CCube
Alt, N, AArea - Insert > Charts > Area
Alt, M, PTrace Precedents - Formulas > Formula Auditing > Trace Precedents
Alt, M, OLookup & Reference - Formulas > Function Library > Lookup & Reference
Alt, M, M, DDefine Name
Alt, M, LLogical - Formulas > Function Library > Logical
Alt, M, M, AApply Names
Alt, M, KError Checking - Formulas > Formula Auditing > Error Checking
Alt, M, GMath & Trig - Formulas > Function Library > Math & Trig
Alt, M, IFinancial - Formulas > Function Library > Financial
Alt, M, EDate & Time - Formulas > Function Library > Date & Time
Alt, M, DTrace Dependents - Formulas > Formula Auditing > Trace Dependents
Alt, J, H, VDifferent Odd & Even Pages. - Design > Options > Different Odd & Even Pages
Alt, M, ARemove Arrows - Formulas > Formula Auditing > Remove Arrows
Alt, J, H, UNumber of Pages - Design > Header & Footer Elements > Number of Pages
Alt, J, H, TFile Path - Design > Header & Footer Elements > File Path
Alt, J, H, RCurrent Time - Design > Header & Footer Elements > Current Time
Alt, J, H, PPage Number - Design > Header & Footer Elements > Page Number
Alt, J, H, NFile Name - Design > Header & Footer Elements > File Name
Alt, J, H, OFooter - Design > Header & Footer > Footer
Alt, J, H, LAlign with Page Margins. - Design > Options > Align with Page Margins
Alt, J, H, HHeader - Design > Header & Footer > Header
Alt, J, H, IPicture - Design > Header & Footer Elements > Picture
Alt, J, H, SSheet Name - Design > Header & Footer Elements > Sheet Name
Alt, J, H, GGo to Footer - Design > Navigation > Go to Footer
Alt, H, WWrap Text - Home > Alignment > Wrap Text
Alt, J, H, EGo to Header - Design > Navigation > Go to Header
Alt, J, H, DCurrent Date - Design > Header & Footer Elements > Current Date
Alt, J, H, AScale with Document - Design > Options > Scale with Document
Alt, J, H, CFormat Picture - Design > Header & Footer Elements > Format Picture
Alt, H, V, VPaste Values
Alt, H, V, FFormulas
Alt, J, H, FDifferent First Page - Design > Options > Different First Page
Alt, H, F, KDecrease Font Size - Home > Font > Decrease Font Size
Alt, H, V, TTranspose
Alt, H, V, HPaste as Hyperlink
Alt, H, V, NPaste Link
Alt, H, V, BNo Borders
Alt, H, V, A, UPaste as Picture
Alt, H, V, A, CCopy as Picture
Alt, H, V, A, IPaste Picture Link
Alt, H, UAutoSum - Home > Editing > AutoSum
Alt, H, TFormat as Table - Home > Styles > Format as Table
Alt, H, OFormat - Home > Cells > Format
Alt, H, NNumber Format - Home > Number > Number Format
Alt, H, M, MMerge Cells
Alt, H, M, UUnmerge Cells
Alt, H, M, CMerge & Center
Alt, H, LConditional Formatting - Home > Styles > Conditional Formatting
Alt, H, M, AMerge Across
Alt, H, SSort & Filter - Home > Editing > Sort & Filter
Alt, H, KComma Style - Home > Number > Comma Style
Alt, H, F, Q, OAngle Counterclockwise
Alt, H, H, MMore Colors
Alt, H, F, SFont Size - Home > Font > Font Size
Alt, H, F, Q, URotate Text Up
Alt, H, F, Q, VVertical Text
Alt, H, F, Q, MFormat Cell Alignment
Alt, H, F, MFormat Cell Number - Home > Number > Format Cell Number
Ctrl+,Copies a formula from the cell above the active cell into the cell or the Formula Bar.
Alt, H, F, Q, DRotate Text Down
Alt, H, F, Q, LAngle Clockwise
Alt, H, F, OOffice Clipboard - Home > Clipboard > Office Clipboard
Alt, H, F, PFormat Painter - Home > Clipboard > Format Painter
F7Displays the Spelling dialog box to check spelling in the active worksheet or selected range.
Alt, H, IInsert - Home > Cells > Insert
Alt, H, F, GIncrease Font Size - Home > Font > Increase Font Size
Alt, H, F, DFind & Select - Home > Editing > Find & Select
Alt, H, F, C, MMore Colors
Alt, H, F, CFont Color - Home > Font > Font Color
Alt, H, F, FFont - Home > Font
Alt, H, F, AFormat Cell Alignment - Home > Alignment > Format Cell Alignment
Alt, H, DDelete - Home > Cells > Delete
Alt, H, B, WDraw Border
Alt, H, B, UTop and Double Bottom Border.
Alt, H, EClear - Home > Editing > Clear
Alt, H, B, TThick Box Border
Alt, H, B, RRight Border
Alt, H, B, PTop Border
Alt, H, B, OBottom Border
Alt, H, B, NNo Border
Alt, H, B, MMore Borders
Alt, H, B, LLeft Border
Alt, H, B, ILine Color
Alt, H, B, HThick Bottom Border
Alt, H, B, EErase Border
Alt, H, B, GDraw Border Grid
Alt, H, B, DTop and Bottom Border.
Alt, H, B, BBottom Double Border
Alt, H, B, CTop and Thick Bottom Border.
Alt, H, B, YLine Style
Alt, H, B, AAll Borders
Alt, H, A, N, MMore Accounting Formats
Alt, H, A, MMiddle Align - Home > Alignment > Middle Align
Alt, H, A, BBottom Align - Home > Alignment > Bottom Align
Alt, H, 3, DDouble Underline
Alt, H, A, NAccounting Number Format - Home > Number > Accounting Number Format
Alt, H, 3Double Underline
Alt, F, WPreview and Print
Alt, F, PPrint
Alt, F, NNew
Alt, F, XExit Excel
Alt, F, IExcel Options
Alt, F, FSave As Other Format.
Shift+Ctrl+Down-ArrowExtends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.
Alt, F, DSend
Alt, F, CClose
Alt, F, ASave As
Alt, H, A, TTop Align - Home > Alignment > Top Align
Alt, A, XExisting Connections - Data > Get External Data > Existing Connections
Alt, A, W, TData Table
Alt, A, W, SScenario Manager
Alt, A, VData Validation - Data > Data Tools > Data Validation
Alt, A, W, GGoal Seek
Alt, A, UUngroup - Data > Outline > Ungroup
Alt, A, RRefresh All - Data > Connections > Refresh All
Alt, A, SSort - Data > Sort & Filter > Sort
Alt, A, QAdvanced - Data > Sort & Filter > Advanced
Alt, F, EPrepare
Shift+SpacebarSelects an entire row in a worksheet.
Alt, A, NConsolidate - Data > Data Tools > Consolidate
Alt, A, MRemove Duplicates - Data > Data Tools > Remove Duplicates
Alt, A, LGroup and Outline Settings. - Data > Outline > Group and Outline Settings
Alt, A, KEdit Links - Data > Connections > Edit Links
Alt, A, JShow Detail - Data > Outline > Show Detail
Alt, A, GGroup - Data > Outline > Group
Alt, A, HHide Detail - Data > Outline > Hide Detail
Alt, A, F, WFrom Web - Data > Get External Data > From Web
Alt, A, F, OFrom Other Sources - Data > Get External Data > From Other Sources
Alt, A, F, TFrom Text - Data > Get External Data > From Text
Alt, A, F, AFrom Access - Data > Get External Data > From Access
Alt, A, OConnections - Data > Connections
Ctrl+Shift+4Applies the Currency format with two decimal places (negative numbers in parentheses).
Alt, A, DSort Z to A. - Data > Sort & Filter > Sort Z to A
Alt, A, CClear - Data > Sort & Filter > Clear
Alt, A, BSubtotal - Data > Outline > Subtotal
Alt, A, ASort A to Z. - Data > Sort & Filter > Sort A to Z
Ctrl+Shift+SpacebarSelects the entire worksheet. If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. Pressing CTRL+SHIFT+SPACEBAR a second time selects the current region and its summary rows. Pressing CTRL+SHIFT+SPACEBAR a third time selects the entire worksheet. When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet.
Ctrl+Shift+TabSwitches to the previous tab in a dialog box.
Shift+TabMoves to the previous cell in a worksheet or the previous option in a dialog box.
Ctrl+TabSwitches to the next tab in dialog box.
TabMoves to the next option or option group in a dialog box. Moves one cell to the right in a worksheet. Moves between unlocked cells in a protected worksheet.
Alt, A, EText to Columns - Data > Data Tools > Text to Columns
Alt+SpacebarDisplays the Control menu for the Microsoft Office Excel window.
HomeMoves to the beginning of a row in a worksheet. Moves to the cell in the upper-left corner of the window when SCROLL LOCK is turned on. Selects the first command on the menu when a menu or submenu is visible.
Ctrl+SpacebarSelects an entire column in a worksheet.
Ctrl+Shift+Page-UpSelects the current and previous sheet in a workbook.
SpacebarIn a dialog box, performs the action for the selected button, or selects or clears a check box.
Ctrl+Page-UpMoves to the previous sheet in a workbook.
Alt+Page-UpMoves one screen to the left in a worksheet.
Ctrl+Shift+Page-DownSelects the current and next sheet in a workbook.
Ctrl+Page-DownMoves to the next sheet in a workbook.
Page-DownMoves one screen down in a worksheet.
Alt+Page-DownMoves one screen to the right in a worksheet.
Ctrl+Shift+HomeExtends the selection of cells to the beginning of the worksheet.
Alt, A, PProperties - Data > Connections > Properties
Ctrl+HomeMoves to the beginning of a worksheet.
Page-UpMoves one screen up in a worksheet.
EscCancels an entry in the cell or Formula Bar. Closes an open menu or submenu, dialog box, or message window. It also closes full screen mode when this mode has been applied, and returns to normal screen mode to display the Ribbon and status bar again.
Ctrl+EndMoves to the last cell on a worksheet, in the lowest used row of the rightmost used column. If the cursor is in the formula bar, CTRL+END moves the cursor to the end of the text.
Ctrl+EnterFills the selected cell range with the current entry.
Alt+EnterStarts a new line in the same cell.
Ctrl+Shift+EndExtends the selection of cells to the last used cell on the worksheet (lower-right corner). If the cursor is in the formula bar, CTRL+SHIFT+END selects all text in the formula bar from the cursor position to the endthis does not affect the height of the formula bar.
EnterCompletes a cell entry from the cell or the Formula Bar, and selects the cell below (by default). In a data form, it moves to the first field in the next record. Opens a selected menu (press F10 to activate the menu bar) or performs the action for a selected command. In a dialog box, it performs the action for the default command button in the dialog box (the button with the bold outline, often the OK button).
EndMoves to the cell in the lower-right corner of the window when SCROLL LOCK is turned on. Also selects the last command on the menu when a menu or submenu is visible.
Shift+Ctrl+Left-ArrowExtends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.
Shift+EnterCompletes a cell entry and selects the cell above.
BackspaceDeletes one character to the left in the Formula Bar. Also clears the content of the active cell. In cell editing mode, it deletes the character to the left of the insertion point. Clears the content of the active cell.
DeleteRemoves the cell contents (data and formulas) from selected cells without affecting cell formats or comments. In cell editing mode, it deletes the character to the right of the insertion point.
Shift+Ctrl+Right-ArrowExtends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.
Alt+Down-ArrowOpens a selected drop-down list.
Alt, F, UPublish
Down-ArrowMove one cell up, down, left, or right in a worksheet. DOWN ARROW or UP ARROW selects the next or previous command when a menu or submenu is open. When a Ribbon tab is selected, these keys navigate up or down the tab group. In a dialog box, arrow keys move between options in an open drop-down list, or between options in a group of options. Opens a selected drop-down list.
Shift+Left-ArrowExtends the selection of cells by one cell.
Shift+Right-ArrowExtends the selection of cells by one cell.
Shift+Down-ArrowExtends the selection of cells by one cell.
Shift+Up-ArrowExtends the selection of cells by one cell.
Ctrl+Left-ArrowMoves to the edge of the current data region in a worksheet.
Ctrl+Down-ArrowMoves to the edge of the current data region in a worksheet.
Right-ArrowMove one cell up, down, left, or right in a worksheet. LEFT ARROW or RIGHT ARROW selects the tab to the left or right when the Ribbon is selected. When a submenu is open or selected, these arrow keys switch between the main menu and the submenu. When a Ribbon tab is selected, these keys navigate the tab buttons.
Ctrl+Up-ArrowMoves to the edge of the current data region in a worksheet.
Left-ArrowMove one cell up, down, left, or right in a worksheet. LEFT ARROW or RIGHT ARROW selects the tab to the left or right when the Ribbon is selected. When a submenu is open or selected, these arrow keys switch between the main menu and the submenu. When a Ribbon tab is selected, these keys navigate the tab buttons.
Up-ArrowMove one cell up, down, left, or right in a worksheet. DOWN ARROW or UP ARROW selects the next or previous command when a menu or submenu is open. When a Ribbon tab is selected, these keys navigate up or down the tab group. In a dialog box, arrow keys move between options in an open drop-down list, or between options in a group of options.
Alt, H, F, IFill - Home > Editing > Fill
Ctrl+Right-ArrowMoves to the edge of the current data region in a worksheet.
Alt+F2Displays the Save As dialog box.
Alt+Shift+F10Displays the menu or message for a smart tag. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message.
Alt+F11Opens the Microsoft Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA).
Shift+F11Inserts a new worksheet
Ctrl+F10Maximizes or restores the selected workbook window.
F11Creates a chart of the data in the current range (on a new worksheet).
Shift+F10Displays the shortcut / context menu for a selected item.
Shift+F9Calculates the active worksheet.
F12Displays the Save As dialog box.
Ctrl+F9Minimizes a workbook window to an icon.
F10Turns shortcut / key tips on or off.
Ctrl+Alt+F9Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
Ctrl+Alt+Shift+F9Rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
F9Calculates all worksheets in all open workbooks.
Alt+F8Displays the Macro dialog box to create, run, edit, or delete a macro.
Shift+F8Enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.
Ctrl+F8Performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.
F8Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection.
Ctrl+F7Performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press ENTER, or ESC to cancel.
Ctrl+F6Switches to the next workbook window when more than one workbook window is open.
Shift+F6Switches between the worksheet, Zoom controls, task pane, and Ribbon.
Ctrl+F5Restores the window size of the selected workbook window (if it is minimzed to an icon)
F6Switches between the worksheet, Ribbon, task pane, and Zoom controls. In a worksheet that has been split (View menu, Manage This Window, Freeze Panes, Split Window command), F6 includes the split panes when switching between panes and the Ribbon area.
Ctrl+F4Closes the selected workbook window.
Ctrl+Shift+F3Displays the Create Name from Selection dialog box.
F4Repeats the last command or action, if possible.
Alt, M, U, CCount Numbers
Ctrl+F3Displays the Name Manager dialog box.
Alt+F1Creates a chart of the data in the current range (on the same worksheet)
Ctrl+F2Displays the Print Preview window.
Shift+F2Adds or edits a cell comment.
Alt+Shift+F1Inserts a new worksheet (with the name Macro…)
F2Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.
Ctrl+F1Displays or hides the Ribbon, a component of the Microsoft Office Fluent user interface.
Ctrl+XCuts the selected cells.
Shift+F3Displays the Insert Function dialog box.
Ctrl+Shift+ZUses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.
F1Displays the Microsoft Office Excel Help task pane.
Ctrl+YRepeats the last command or action, if possible.
Ctrl+ZUses the Undo command to reverse the last command or to delete the last entry that you typed.
Ctrl+WCloses the selected workbook window.
Ctrl+Alt+VUse to paste values or formulas. 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+VInserts 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+TDisplays the Create Table dialog box.
Ctrl+SSaves the active file with its current file name, location, and file format.
Ctrl+PDisplays the Print dialog box.
Ctrl+Shift+OSelects all cells that contain comments.
Ctrl+ODisplays the Open dialog box to open or find a file.
Ctrl+KDisplays the Insert Hyperlink dialog box for new hyperlinks or theEdit Hyperlink dialog box for selected existing hyperlinks.
Ctrl+NCreates a new, blank workbook.
Ctrl+HDisplays the Find and Replace dialog box, with the Replace tab selected.
Ctrl+GDisplays the Go To dialog box.
F5Displays the Go To dialog box.
Shift+F4SHIFT+F4 repeats the last Find action (after the Find Windows is closed)
Shift+F5Displays the Find and Replace dialog box, with the Find tab selected.
Ctrl+FDisplays the Find and Replace dialog box, with the Find tab selected.
Ctrl+CCopies the selected cells.
Ctrl+Shift+ACTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.
Shift+Ctrl+Up-ArrowExtends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.
Ctrl+ASelects the entire worksheet. If the worksheet contains data, Ctrl+A selects the current region. Pressing Ctrl+A a second time, it selects the entire worksheet.
Ctrl+0Hides the selected columns.
Ctrl+9Hides the selected rows.
Ctrl+6Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
Ctrl+8Displays or hides the outline symbols.
Ctrl+5Applies or removes strikethrough.
Ctrl+UApplies or removes underlining.
Ctrl+Shift+UIncreases size of formula bar
Ctrl+4Applies or removes underlining.
Ctrl+IApplies or removes italic formatting.
Ctrl+2Applies or removes bold formatting.
Ctrl+3Applies or removes italic formatting.
Ctrl+BApplies or removes bold formatting.
Ctrl+Shift+PDisplays the Format Cells dialog box. CTRL+SHIFT+P opens the Format Cells dialog box with the Fonttab selected.
Ctrl+Shift+]Alternates between displaying cell values and displaying formulas in the worksheet.
Ctrl+MinusDisplays the Delete dialog box to delete the selected cells.
Ctrl+PlusDisplays the Insert dialog box to insert blank cells.
Ctrl+Minus-NumblockDisplays the Delete dialog box to delete the selected cells.
Ctrl+Plus-NumblockDisplays the Insert dialog box to insert blank cells.
Ctrl+DCopies the value from the cell above the active cell into the cell or the Formula Bar.
Ctrl+RUses 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+1Displays the Format Cells dialog box (with the same tab selected as last time)
Ctrl+Shift+_Removes the outline border to the selected cells.
Ctrl+Shift+7Applies the outline border to the selected cells.
Ctrl+Shift+:Enters the current time.
Ctrl+Shift+~Applies the General number format
Ctrl+Shift+8Selects 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+9Unhides any hidden rows within the selection.
Ctrl+Shift+6Applies the Scientific number format with two decimal places.
Ctrl+Shift+0Unhides any hidden columns within the selection. Does not work on Windows 7 or Vista. To fix visit http://superuser.com/questions/183197/whats-the-keyboard-shortcut-to-unhide-a-column-in-excel-2010
Ctrl+Shift+,Copies the value from the cell above the active cell into the cell or the Formula Bar.
Ctrl+Shift+2Applies the Time format.
Ctrl+Shift+5Applies the Percent format.
Ctrl+Shift+1Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
Ctrl+Shift+3Applies the Date format with the day, month, and year.

Never look up a shortcut again.

Anyone who uses Excel knows how important it is to work as quickly as possible. However, constantly looking up shortcuts severely hurts your speed and efficiency. With KeyRocket, you’ll never have to look up another shortcut again. KeyRocket suggests relevant keyboard shortcuts with subtle notifications inside of Excel. This allows you to learn new shortcuts without interrupting your workflow.

Gain access to all of Microsoft’s default shortcuts.

KeyRocket provides access to all of Microsoft’s default shortcuts in one single program. Already have some shortcut experience? KeyRocket allows you to control the amount of notifications you see based on your skill level.

Create custom shortcuts for frequently used actions.

Many of Excel’s default shortcuts are overly long and complex. With KeyRocket, you can create your own custom keyboard shortcuts for any function. Reassign the default shortcuts to better suit your work habits and increase your efficiency.

Download SlideProof