Excel 2013 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, M, U, FMore Functions
Alt, M, U, CInserts a Count function.
Alt, M, U, AInserts an Average function.
Alt, M, TInserts Text function.
Alt, M, S, PDisplays the Paste Name dialog box. Available only if there are existing names in the workbook.
Alt, M, SChoose a name used in this workbook and insert it into the current formula.
Alt, M, RDisplays a list of recently used functions.
Alt, M, Q, SInserts Statistical function.
Alt, M, Q, IInserts an Information function.
Alt, M, Q, EInserts an Engineering function.
Alt, M, Q, CInserts a Cube function.
Alt, M, PShows arrows that indicate what cells are affected by the value of the currently selected cell.
Alt, M, OInserts a Lookup&Reference function.
Alt, M, NDisplays the Name Manager dialog box.
Alt, M, M, DNames cells so that you can refer to them in formulas by that name.
Alt, M, M, AApply Names
Alt, M, LInserts a Logical function.
Alt, M, K, KChecks for common errors that occur in formulas.
Alt, M, K, ETrace Error
Alt, M, K, CCircular References
Alt, M, JCalculates the current sheet now. This is only necessary if automatic calculation has been turned off.
Alt, M, IInserts a Financial function.
Alt, M, HAlternates between displaying cell values and displaying formulas in the worksheet.
Alt, M, GInserts a Math function.
Alt, M, FEdits the formula in the current cell by choosing functions and editing the arguments.
Alt, M, EInserts a Date&Time function.
Alt, M, DShows arrows that indicate what cells are affected by the value of the currently selected cell.
Alt, M, CDisplays the Create Name from Selection dialog box.
Alt, M, BCalculate the entire workbook now. This is only necessary if automatic calculation has been turned off.
Alt, M, A, PRemoves precedent arrows.
Alt, M, A, DRemoves dependent arrows.
Alt, M, A, ARemoves the arrows drawn by Trace Precedents or Trace Dependents.
Alt, H, XCuts the selected cells.
Alt, H, WMakes all content visible within a cell by displaying it on multiple lines.
Alt, H, V, SDisplays the Paste Special dialog box.
Alt, H, TQuickly formats a range of cells and converts it to a Table by choosing a pre-defined Table Style.
Alt, H, PDisplays the value of the cell as a percentage.
Alt, H, NChoose how the values in a cell are displayed: as a percentage, as currency, as a date or time, etc.
Alt, H, LHighlights interesting cells, emphasize unusual values, and visualize data using Data Bars, Color Scales, and Icon Sets based on criteria.
Alt, H, KDisplays the value of the cell with a thousands separator. This will change the format of the cell to Accounting without a currency symbol.
Alt, H, HShading
Alt, H, F, SChanges the font size.
Alt, H, F, PCopies formatting from one place and apply it to another.
Alt, H, F, ODisplays the Office Clipboard Task Pane.
Alt, H, F, NShows the Font tab of the Format Cells dialog box.
Alt, H, F, MShows the Number tab of the Format Cells dialog box.
Alt, H, F, KDecreases font Size.
Alt, H, F, GIncreases the font size.
Alt, H, F, FChanges the font face.
Alt, H, F, CFont Color
Alt, H, F, AShows the Alignment tab of the Format Cells dialog box.
Alt, H, C, PCopies as picture.
Alt, H, C, CCopies the selected cells.
Alt, H, B, YLine Style
Alt, H, B, WDraw Border
Alt, H, B, UTop and Bottom Border
Alt, H, B, TThick Box Border
Alt, H, B, SApplies the outline border to the selected cells.
Alt, H, B, RRight Border
Alt, H, B, PTop Border
Alt, H, B, OBottom Border
Alt, H, B, NRemoves the outline border from the selected cells.
Alt, H, B, MMore Borders
Alt, H, B, LLeft Border
Alt, H, B, I, MMore Border Colors
Alt, H, B, ILine Color
Alt, H, B, HThick Bottom Border
Alt, H, B, GDraw Border Grid
Alt, H, B, EErase Border
Alt, H, B, DTop and Bottom Border
Alt, H, B, CTop and Thick Bottom Border.
Alt, H, B, BBottom Double Border
Alt, H, B, AAll Borders
Alt, H, A, TAligns text to the top of the cell.
Alt, H, A, NChanges currency format for the selected cell.
Alt, H, A, MAligns text so that it is centered between the top and bottom of the cell.
Alt, H, A, BAligns text to the bottom of the cell.
Alt, H, 6Increases the margin between the border and the text in the cell.
Alt, H, 5Decreases the margin between the border and the text in the cell.
Alt, H, 3, UApplies or removes underlining.
Alt, H, 3, DDouble underlines the selected text.
Alt, F, TCustomizes language, display, and other program settings.
Alt, F, SSave
Alt, F, PDisplays the Print dialog box.
Alt, F, I, RInfo (Manage Versions)
Alt, F, I, Q, SInfo (Properties)
Alt, F, I, Q, PInfo (Show All Properties)
Alt, F, CCloses the selected workbook window.
Alt, F, ADisplays the Save As dialog box.
Alt, A, XConnects to an external data source.
Alt, A, W, TData Table
Alt, A, W, SScenario Manager
Alt, A, W, GGoal Seek
Alt, A, V, VPrevent invalid data from being entered into a cell.
Alt, A, V, RClear Validation Circles
Alt, A, V, ICircle Invalid Data
Alt, A, U, UUngroups a range of cells that were previously grouped.
Alt, A, U, CClear Outline
Alt, A, TApplies a data filter.
Alt, A, S, SSort - Shows the Sort dialog box to sort data based on several criteria at once.
Alt, A, S, DSorts the selection so that the highest values are at the top of the column.
Alt, A, S, ASorts the selection so that the lowest values are at the top of the column.
Alt, A, R, SRefresh Status
Alt, A, R, RRefresh - Gets the latest data from the source connected to the active cell.
Alt, A, R, OConnection Properties
Alt, A, R, CCancels refresh.
Alt, A, R, ARefresh all - Updates all the information that is coming from a data source.
Alt, A, QAdvanced - Specifies complex criteria to limit which records are included in the result set of a query.
Alt, A, PSpecify how cells connected to a data source will update, what contents from the source will be displayed, and how changes in the number of rows or columns in the data source will be handled in the workbook.
Alt, A, ODisplays all data connections for the workbook.
Alt, A, NConsolidate - Combines values from multiple ranges into one new range.
Alt, A, MDelete duplicate rows from a sheet. You can specify which columns should be checked for duplicate information. - Data > Data Tools > Remove Duplicates
Alt, A, LGroup and Outline Settings - Shows the Outline dialog box.
Alt, A, KDisplays all of the other files this spreadsheet is linked to.
Alt, A, JShow Detail - Expands a collapsed group of cells.
Alt, A, HHide Detail - Collapses a group of cells.
Alt, A, G, GGroup - Ties a range of cells together so that they can be collapsed or expanded.
Alt, A, G, AAuto Outline
Alt, A, F, WImports data from a Web page.
Alt, A, F, TImport data from a text file.
Alt, A, F, OImports data from other data sources.
Alt, A, F, AImport data from a Microsoft Access database.
Alt, A, ESeparates the contents of one Excel cell into separate columns.
Alt, A, CClears the filter and sorts state for the current range of data.
Alt, A, BSubtotal - Totals several rows of related data together by automatically inserting subtotals and totals for the selected cells.
Alt, H, 9Shows fewer decimal places.
Alt, H, 0Shows more decimal places for a more precise value.
Alt, H, A, LApplies align left.
Alt, H, A, CApplies align center.
Alt, H, A, RApplies align right.
Alt, H, H, NRemoves cell shading.
Ctrl+Shift+LApplies a data filter.
Alt+F2Displays the Save As dialog box.
Alt+F4Closes Excel.
Ctrl+Shift+0Unhides any hidden columns within the selection.
Ctrl+;Enters the current date.
Ctrl+Shift+F3Displays the Create Name from Selection dialog box.
Ctrl+F3Displays the Name Manager dialog box.
Shift+F4Repeats the last Find action (after the Find Windows is closed)
Shift+F5Displays the Find and Replace dialog box, with the Find tab selected.
Ctrl+`Alternates between displaying cell values and displaying formulas in the worksheet.
Ctrl+Minus-NumblockDeletes the selected cells.
Ctrl+MinusDeletes the selected cells.
Ctrl+Shift+;Enters the current time.
Ctrl+Plus-NumblockDisplays the Insert dialog box to insert blank cells.
Ctrl+ZUses the Undo command to reverse the last command or to delete the last entry that you typed.
Ctrl+YRedoes the last command or action, if possible (after it was undone)
Ctrl+XCuts the selected cells.
Ctrl+WCloses the selected workbook window.
Ctrl+Alt+VDisplays the Paste Special dialog box.
Ctrl+VPaste - Inserts the contents of the Clipboard at the insertion point and replaces any selection.
Ctrl+Shift+USwitches between expanding and collapsing of the formula bar.
Ctrl+UApplies or removes underlining.
Ctrl+TDisplays the Create Table dialog box.
Ctrl+SSaves the active file with its current file name, location, and file format.
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+Shift+PShows the Font tab of the Format Cells dialog box.
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+NCreates a new, blank workbook.
Ctrl+LDisplays the Create Table dialog box.
Ctrl+KCreates a link to a Web page, a picture, an e-mail address, or a program.
Ctrl+IApplies or removes italic formatting.
Ctrl+HDisplays the Find and Replace dialog box, with the Replace tab selected.
Ctrl+GDisplays the Go To dialog box.
Ctrl+Shift+FShows the Font tab of the Format Cells dialog box.
Ctrl+FDisplays the Find and Replace dialog box, with the Find tab selected.
Ctrl+DCopies the value from the cell above the active cell into the cell or the Formula Bar.
Ctrl+CCopies the selected cells.
Ctrl+BApplies or removes bold formatting.
Ctrl+Shift+AInserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.
Ctrl+ASelects the entire worksheet. If the worksheet contains data, Ctrl+A selects the current region.
Ctrl+0Hides the selected columns.
Ctrl+9Hides the selected rows.
Ctrl+8Displays or hides the outline symbols.
Ctrl+6Alternates between hiding and displaying objects.
Ctrl+5Applies or removes strikethrough.
Ctrl+4Applies or removes underlining.
Ctrl+3Applies or removes italic formatting.
Ctrl+2Applies or removes bold formatting.
Ctrl+1Shows the Format Cells dialog box.
Shift+TabMoves to the previous cell in a worksheet or the previous option in a dialog box.
TabMoves one cell to the right in a worksheet. Moves between unlocked cells in a protected worksheet. Moves to the next option or option group in a dialog box.
Ctrl+Shift+SpacebarSelects the entire worksheet. If the worksheet contains data, Ctrl+A selects the current region.
Shift+SpacebarSelects an entire row in a worksheet.
Ctrl+SpacebarSelects an entire column in a worksheet.
Ctrl+Shift+Page-UpSelects the current and previous sheet in a workbook.
Ctrl+Page-UpMoves to the previous sheet in a workbook.
Alt+Page-UpMoves one screen to the left in a worksheet.
Page-UpMoves one screen up 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.
Alt+Page-DownMoves one screen to the right in a worksheet.
Page-DownMoves one screen down in a worksheet.
Ctrl+Shift+HomeExtends the selection of cells to the beginning of the worksheet.
Ctrl+HomeMoves to the beginning of a worksheet.
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.
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.
Shift+EnterCompletes a cell entry and selects the cell above.
Ctrl+EnterFills the selected cell range with the current entry.
Alt+EnterStarts a new line in the same cell.
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).
Ctrl+Shift+Arrow-RightExtends 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+Shift+Arrow-DownExtends 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+Shift+Arrow-UpExtends 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+Arrow-LeftExtends the selection of the cells by one cell left
Shift+Arrow-RightExtends the selection of the cells by one cell right.
Shift+Arrow-DownExtends the selection of the cells by one cell down
Shift+Arrow-UpExtends the selection of the cells by one cell up.
Ctrl+Arrow-LeftMoves to the left corner of the current data region in a worksheet.
Ctrl+Arrow-RightMoves to the right corner of the current data region in a worksheet.
Ctrl+Arrow-DownMoves to the bottom of the current data region in a worksheet.
Ctrl+Arrow-UpMoves to the top of the current data region in a worksheet.
Arrow-DownMoves one cell down in a worksheet. Selects the next command when a menu or submenu is open.
Arrow-UpMoves one cell up in a worksheet. Selects the previous command when a menu or submenu is open. When a ribbon tab is selected, the key navigates up the tab group.
Arrow-LeftMoves one cell left in a worksheet. Selects the tab to the left when the ribbon is selected. When a submenu is open or selected, the arrow key switches between the main menu and the submenu. When a ribbon tab is selected, the key navigates the tab buttons.
Arrow-RightMoves one cell right in a worksheet. Selects the tab to the right when the ribbon is selected. When a submenu is open or selected, the arrow key switches between the main menu and the submenu. When a ribbon tab is selected, the key navigates the tab buttons.
F12Displays the Save As dialog box.
Alt+F11Opens the Microsoft Visual Basic For Applications Editor, in which you can create a macro by using Visual Basic for Applications (VBA).
Shift+F11Inserts a new worksheet.
F11Creates a chart of the data in the current range in a separate Chart sheet.
Ctrl+F10Maximizes or restores the selected workbook window.
F10Turns key tips on or off. (Pressing ALT does the same thing.)
Ctrl+F9Minimizes a workbook window to an icon.
Ctrl+Alt+Shift+F9Rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
Ctrl+Alt+F9Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
Shift+F9Calculates the active worksheet.
F9Calculates all worksheets in all open workbooks.
Alt+F8Displays the Macro dialog box to create, run, edit, or delete a macro.
Ctrl+F8Performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.
Shift+F8Enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.
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.
F7Displays the Spelling dialog box to check spelling in the active worksheet or selected range.
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.
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+F5Restores the window size of the selected workbook window.
F5Displays the Go To dialog box.
Ctrl+F4Closes the selected workbook window.
F4Repeats the last command or action, if possible.
Shift+F3Displays the Insert Function dialog box.
F3Displays the Paste Name dialog box. Available only if there are existing names in the workbook.
Ctrl+F2Displays the Print dialog box.
Shift+F2Adds or edits a cell comment.
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.
Alt+Shift+F1Inserts a new worksheet.
Alt+F1Insert a column chart. Column charts are used to compare values across categories.
Ctrl+F1Displays or hides the ribbon.
F1Displays the Excel Help task pane.
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+1Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
Ctrl+Shift+2Applies the Time format with the hour and minute, and AM or PM.
Ctrl+Shift+3Applies the Date format with the day, month, and year.
Ctrl+Shift+6Applies the Scientific number format with two decimal places.
Ctrl+Shift+5Applies the Percentage format with no decimal places.
Ctrl+Shift+4Applies the Currency format with two decimal places (negative numbers in parentheses).
Ctrl+Shift+`Applies the General number format.
Ctrl+Shift+MinusRemoves the outline border from the selected cells.
Ctrl+Shift+7Applies the outline border to the selected cells.
Ctrl+Shift+9Unhides any hidden rows within the selection.
Alt, N, S, C, CInserts a picture of part of the screen into the file.
Alt, N, S, FInserts a slicer to filter data interactively. Slicers make it faster and easier to filter PivotTables and cube functions.
Alt, N, S, HInserts ready-made shapes, such as rectangles and circles, arrows, lines, flowchart symbols, and callouts.
Alt, N, S, LInserts a line chart within a single cell.
Alt, N, S, OInserts a column chart within a single cell.
Alt, N, S, WInserts a win/loss chart within a single cell.
Alt, N, TDisplays the Create Table dialog box.
Alt, N, UInserts characters that are not on your keyboard, such as copyright symbols, trademark symbols, paragraph marks, and Unicode characters.
Alt, N, WInserts decorative text in your document.
Alt, P, A, A, BAligns text to the bottom of the cell.
Alt, P, A, A, CApplies align center.
Alt, P, A, A, GDisplays the lines between rows and columns in the sheet to make editing and reading easier.
Alt, P, A, A, HDistribute Horizontally
Alt, P, A, A, LApplies align left.
Alt, P, A, A, MAligns text so that it is centered between the top and bottom of the cell.
Alt, P, A, A, PSnap to Grid
Alt, P, A, A, RApplies align right.
Alt, P, A, A, SSnap to Shape
Alt, P, A, A, TAligns text to the top of the cell.
Alt, P, A, A, VDistribute Vertically
Alt, P, A, E, BSends the selected object backward so that it is hidden by the objects that are in front of it.
Alt, P, A, E, KSends the selected object behind all other objects.
Alt, P, A, F, FBrings the selected object forward so that it is hidden by fewer objects that are in front of it.
Alt, P, A, F, RBrings the selected object in front of all other objects so that no part of it is hidden behind another object.
Alt, P, A, G, ERegroup
Alt, P, A, G, GJoins two or more selected objects together so they will be treated as one object.
Alt, P, A, G, UBreaks a set of grouped objects back into individual objects.
Alt, P, A, PDisplays the Selection Pane to help select individual objects and to change their order and visibility.
Alt, P, A, Y, MMore Rotation Options
Alt, P, B, AResets All Page Breaks.
Alt, P, B, IInsert Page Break
Alt, P, B, RRemove Page Break
Alt, P, GSets an image to display as the background of the sheet.
Alt, P, HShrinks the height of printed output to fit a maximum number of pages.
Alt, P, ISets rows and columns to repeat on each printed page.
Alt, P, MSelects the margin sizes for the entire document or the current section.
Alt, P, R, CClear Print Area
Alt, P, R, SSet Print Area
Alt, P, S, ODisplays the Sheet tab of the Page Setup dialog box.
Alt, P, S, PDisplays the Page tab of the Page Setup dialog box.
Alt, P, S, ZChoose a paper size for the current section.
Alt, P, T, CChanges the colors for the current theme.
Alt, P, T, EChanges the effects for the current theme.
Alt, P, T, FChanges the fonts for the current theme.
Alt, P, T, H, ASave Current Theme
Alt, P, T, H, BBrowse for Themes
Alt, P, WShrinks the width of printed output to fit a maximum number of pages.
Alt, P, XStretches or shrinks the printed output to a percentage of its actual size.
Alt, R, ADisplays all comments in the sheet.
Alt, R, CAdds a comment about the selection.
Alt, R, DDeleteS the selected comment.
Alt, R, ESuggests other words with a similar meaning to the word you have selected.
Alt, R, G, CAccept/Reject Changes
Alt, R, G, HHighlight Changes
Alt, R, HDisplays or hides the comment attached to the selected cell.
Alt, R, IDisplays or hides any ink annotations on the sheet.
Alt, R, LTranslates selected text into a different language.
Alt, R, NAdds a comment about the selection.
Alt, R, OShares the workbook and protects it with a password at the same time.
Alt, R, P, SPrevents unwanted changes to the data in a sheet by specifying what information can be changed.
Alt, R, P, WPrevents unwanted changes to the structure of the workbook, such as moving, deleting, or adding sheets.
Alt, R, ROpens the Research Task Pane to search through reference materials, such as dictionaries, encyclopedias, and translation services.
Alt, R, SChecks the spelling of text.
Alt, R, UAllows specific people to edit ranges of cells in a protected workbook or sheet.
Alt, R, VSelects the previous comment in the sheet.
Alt, R, WPrevents unwanted changes to the structure of the workbook, such as moving, deleting, or adding sheets.
Alt, W, ATiles all open program windows side-by-side on the screen.
Alt, W, BDisplays two worksheets side-by-side so that you can compare their contents.
Alt, W, CSaves a set of display and prints settings as a custom view.
Alt, W, GZooms the worksheet so that the currently selected range of cells fills the entire window.
Alt, W, HHides the current window so that it cannot be seen.
Alt, W, IDisplays a preview of where pages will break when this document is printed.
Alt, W, JZooms the document to 100% of the normal size.
Alt, W, KSaves the current layout of all windows as a workspace so that it can be restored later.
Alt, W, LDisplays the document in Normal view
Alt, W, M, RRecords a macro. Each of the commands you perform will be saved into the macro so that you can play them back again.
Alt, W, M, UUses relative references so that macros are recorded with actions relative to the initial selected cell.
Alt, W, M, VDisplays the Macro dialog box to create, run, edit, or delete a macro.
Alt, W, NOpens a new window containing a view of the current document.
Alt, W, PDisplays the document as it will appear on the printed page.
Alt, W, QDisplays the Zoom dialog box to specify the zoom level of the document.
Alt, W, RDisplays the rulers, used to measure and line up objects in the document.
Alt, W, TReset the window position of the documents being compared side-by-side so that they share the screen equally.
Alt, W, UUnhides any windows hidden by the Hide Window feature.
Alt, W, V, FDisplays the formula bar, in which you can enter text and formulas into cells.
Alt, W, V, GDisplays the lines between rows and columns in the sheet to make editing and reading easier.
Alt, W, V, HDisplays row and column headings.
Alt, W, V, SSynchronizes the scrolling of two documents so that they scroll together.
Alt, W, WSwitches to a different currently open window.
Alt, A, ACreates or edit relationships between tables to show related data from different tables on the same report.
Alt+Shift+Arrow-RightGroup - Ties a range of cells together so that they can be collapsed or expanded.
Alt+Shift+Arrow-LeftUngroups a range of cells that were previously grouped.
Alt, A, Y, 3Reapplies the filter and sort in the current range.
Alt, F, H, SShare (Invite People) - File > Share > Invite People
Alt, F, P, FPrint Preview (Next Page)
Alt, F, P, XPrint (Show Margins)
Alt, F, P, WPrint (Zoom to Page)
Alt, F, E, PExport (Create PDF/XPS Document)
Alt, F, E, BExport (Browser View Options)
Alt, F, E, CExport (Change File Type)
Alt, F, O, ROpen (Recent Workbooks)
Alt, F, Y, 1Account Dialog
Alt, H, F, D, FDisplays the Find and Replace dialog box, with the Find tab selected.
Alt, H, F, D, RSearches for text you would like to change, and replaces it with something else.
Alt, H, F, D, GDisplays the Go To dialog box.
Alt, H, F, D, SGo To Special
Alt, H, F, D, UFind & Select Formulas
Alt, H, F, D, MFind Comments
Alt, H, F, D, CFind & Select Conditional Formatting
Alt, H, F, D, VFind & Select Data Validation
Alt, H, F, Q, URotate Text Up
Alt, H, F, Q, DRotate Text Down
Alt, H, F, Q, MShows the Alignment tab of the Format Cells dialog box.
Alt, H, H, MMore Colors
Alt, H, I, IDisplays the Insert dialog box to insert blank cells.
Alt, H, I, RInsert Sheet Rows
Alt, H, I, CInsert columns
Alt, H, I, SInserts a new worksheet.
Alt, H, L, H, GHighlight cell rules: greater than (Conditional formatting)
Alt, H, L, H, LHighlight cell rules: less than (Conditional formatting)
Alt, H, L, H, BHighlights cell rules: between (Conditional formatting)
Alt, H, L, H, EHighlight cell rules: equal to (Conditional formatting)
Alt, H, L, H, THighlight cell rules: text that contains (Conditional formatting)
Alt, H, L, SApplies a color gradient to a range of cells. The color indicates where each cell value falls within that range.
Alt, H, L, S, MApplies a color gradient to a range of cells. The color indicates where each cell value falls within that range.
Alt, H, L, IChooses a set of icons to represent the values in the selected cells.
Alt, H, L, I, MIcon Sets - More Rules
Alt, H, L, NNew rule (Conditional formatting)
Alt, H, L, C, SClears rules from selected cells.
Alt, H, L, C, EClears rules from entire sheet.
Alt, H, L, C, TClears rules from this table.
Alt, H, L, C, PClears rules from this PivotTable.
Alt, H, L, RCreates, edits, deletes, and views all conditional formatting rules in the workbook by using the Conditional Formatting Rules Manager.
Alt, H, T, NNew Table Style
Alt, P, V, GDisplays the lines between rows and columns in the sheet to make editing and reading easier.
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 end—this does not affect the height of the formula bar.
Ctrl+EndMoves to the last cell on a worksheet, to 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.
EndTurns End mode on. In End mode, you can then press an arrow key to move to the next nonblank cell in the same column or row as the active cell. If the cells are blank, pressing END followed by an arrow key moves to the last cell in the row or column. END also selects the last command on the menu when a menu or submenu is visible.
DeleteClears the content of selected cells. If editing text, deletes one character to the right.
BackspaceEdits the active cell and then clears it, or deletes the preceding character in the active cell as you edit cell contents.
Ctrl+Shift+Arrow-LeftExtends 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, P, P, GPrints the lines between rows and columns in the sheet to make reading easier.
Alt, P, P, HPrints row and column headings.
Alt, P, V, HDisplays column headings and row numbers.
Ctrl+Alt+LReapplies the filter and sort in the current range.
Alt, F, N, SSearch online templates
Alt, F, Y, 1, BOffice Background
Alt, F, Y, 1, ERemoves your account.
Alt, F, Y, 1, DAdd a service
Alt, F, Y, 1, RUpdate Options
Ctrl+Shift+=Displays the Insert dialog box to insert blank cells.
Alt, H, O, HRow height
Alt, H, O, AAutoFit Row Height
Alt, H, O, WColumn Width
Alt, H, O, IAutoFit Column Width
Alt, H, O, DDefault Width
Alt, H, O, U, RHides the selected rows.
Alt, H, O, U, CHides the selected columns.
Alt, H, O, U, SHide Sheet
Alt, H, O, U, OUnhides any hidden rows within the selection.
Alt, H, O, U, LUnhides any hidden columns within the selection.
Alt, H, O, U, HUnhide Sheet
Alt, W, SSplist the window into multiple resizable panes containing views of your worksheet.
Ctrl+Shift+[Select all cells directly or indirectly referenced by formulas in the selection.
Ctrl+Shift+]Select cells that contain formulas that directly or indirectly reference the active cell.
Alt+;Select the visible cells in the current selection.
Alt, H, F, C, MMore Font Colors
Ctrl+Alt+F5Refresh all - Updates all the information that is coming from a data source.
Alt+F5Refresh - Gets the latest data from the source connected to the active cell.
Alt, F, XCloses Excel.
Alt, F, I, IInspect Document - Check the workbook for hidden properties or personal information. - Check for Issues > Inspect Document
Alt, F, I, ACheck Accessibility - Check the workbook for content that people with disabilities might find difficult to read. - Check for Issues > Check Accessibility
Alt, F, I, CCheck Compatibility - Check for features not supported by earlier versions of Excel. - Check for Issues > Check Compatibility
Alt, F, I, P, EEncrypt with Password - Require a password to open this workbook. - Protect Workbook > Encrypt with Password
Alt, F, I, P, FMark as Final - Let readers know the workbook is final and make it read-only. - Protect Workbook > Mark as Final
Alt+=Insert an AutoSum function.
Alt, H, U, AInserts an Average function.
Alt, H, U, CInserts a Count function.
Alt, H, U, MInserts a Maximum function.
Alt, H, U, IInserts a Minimum function.
Alt, H, U, FShows the Insert function dialog.
Alt, F, H, ESend using email (as attachment)
Alt, F, O, KOpen (SkyDrive)
Alt, F, O, COpen (Computer)
Alt, F, O, AOpen (Add a place)
Alt, F, N, LBlank workbook
Alt, F, P, PPrint
Alt, F, P, NPrint (Copies)
Alt, F, P, IPrint (Which Printer)
Alt, F, P, AOnly prints the active sheets.
Alt, F, P, HPrint From Pages
Alt, F, P, JPrint to Page
Alt, F, P, CCollation / Uncollation
Alt, F, P, OPrint (Orientation)
Alt, F, P, LPrint (Page Size)
Alt, F, P, MPrint (Margins)
Alt, F, P, SPrints sheets at their actual size.
Alt, F, P, GChecks out the full set of page formatting options.
Alt, H, F, D, OSelects objects including ink, shapes, and text areas.This is especially useful when working with objects that are behind the text.
Alt, H, F, D, PDisplays the Selection Pane to help select individual objects and to change their order and visibility.
Alt, H, F, I, DCopies the value from the cell above the active cell into the cell or the Formula Bar.
Alt, H, F, I, 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.
Alt, H, F, I, UFill Up
Alt, H, F, I, LFill Left
Alt, H, F, I, AFill Across Worksheets
Alt, H, F, I, SFill Series
Alt, H, F, I, JFill Justify
Alt, H, F, I, FAutomatically fill in values. Enter a couple of examples you want as output and keep the active cell in the column you want filled in.
Alt, H, F, Q, OAngle Counterclockwise
Alt, H, F, Q, LAngle Clockwise
Alt, H, F, Q, VVertical Text
Alt, H, L, H, AHighlight cell rules: a date occurring (Conditional formatting)
Alt, H, L, H, DHighlight cell rules: duplicate values (Conditional formatting)
Alt, H, L, H, MHighlight cell rules: more rules (Conditional formatting)
Alt, H, L, T, TTop-bottom rules: Top 10 Items (Conditional formatting)
Alt, H, L, T, PTop-bottom rules: Top 10 % (Conditional formatting)
Alt, H, L, T, BTop-bottom rules: Bottom 10 Items (Conditional formatting)
Alt, H, L, T, OTop-bottom rules: Bottom 10 % (Conditional formatting)
Alt, H, L, T, ATop-bottom rules: Above Average (Conditional formatting)
Alt, H, L, T, VTop-bottom rules: Below Average (Conditional formatting)
Alt, H, L, T, MTop-bottom rules: More Rules (Conditional formatting)
Alt, H, L, DAdds a colored data bar to represent the value in a cell. The higher the value, the longer the bar.
Alt, H, L, D, MData Bars More
Alt, H, T, PNew PivotTable Style
Alt, H, U, SDisplays the sum of the selected cells directly after the selected cells.
Alt, H, M, CCombine and center the contents of the selected cells in a new larger cell.
Alt, H, M, AMerges each row of the selected cells into a larger cell.
Alt, H, M, MMerge the selected cells into one cell.
Alt, H, M, USplits the current cell into multiple cells.
Alt, H, S, SSorts the selection so that the lowest values are at the top of the column.
Alt, H, S, OSorts the selection so that the highest values are at the top of the column.
Alt, H, S, USort - Shows the Sort dialog box to sort data based on several criteria at once.
Alt, H, S, FApplies a data filter.
Alt, H, S, CClears the filter and sorts state for the current range of data.
Alt, H, S, YReapplies the filter and sort in the current range.
Alt, H, V, PPaste - Inserts the contents of the Clipboard at the insertion point and replaces any selection.
Alt, H, V, FPastes formulas.
Alt, H, V, OPastes formulas & numbers.
Alt, H, V, KPaste (Keeps source column width.)
Alt, H, V, BPaste (No borders)
Alt, H, V, WPaste (Keeps source column width.)
Alt, H, V, TPaste (Transpose)
Alt, H, V, VPastes as Values.
Alt, H, V, APaste (Number formatting)
Alt, H, V, EPaste (Source Formatting)
Alt, H, V, RPastes formatting.
Alt, H, V, NPastes a link.
Alt, H, V, UPastes a picture.
Alt, H, V, IPastes a linked picture.
Alt, N, A, 1Inserts an area chart. Area charts emphasize differences between several sets of data over a period of time.
Alt, N, A, P, SShows additional available agave extensions.
Alt, N, A, PApps for Office
Alt, N, RRecommended Charts
Alt, N, S, DHighlights different types of information. Use it when the range of values in the chart varies widely or you have mixed types of data.
Alt, N, S, PRecommended PivotTable
Alt, N, S, TCreates a Timeline to filter dates interactively.
Alt, N, S, VInserts PowerView.
Alt, N, VSummarizes data using a PivotTable.
Alt, N, XInserts a text box that can be positioned anywhere on the page.
Alt, P, A, Y, RRotate Right 90°
Alt, P, A, Y, LRotate Left 90°
Alt, P, A, Y, VFlip Vertical
Alt, P, A, Y, HFlip Horizontal
Alt, N, S, Z, CInserts a PivotChart.
Alt, N, S, Z, PInserts Pivot Chart and Table.
Alt, F, Y, 1, NSwitches your account.
Alt, H, D, DDeletes the selected cells.
Alt, H, D, RDelete Sheet Rows
Alt, H, D, CDelete Sheet Columns
Alt, H, D, SDelete Sheet
Alt, H, E, AClears everything from the selected cells.
Alt, H, E, FClears only the formatting that is applied to the selected cells.
Alt, H, E, CClears the content of selected cells. If editing text, deletes one character to the right.
Alt, H, E, MClears any comments that are attached to the selected cells.
Alt, H, E, LClears the hyperlinks from the selected cells.
Alt, H, E, RRemove the hyperlinks and formatting from the selected cells.
Ctrl+]Select cells that contain formulas that directly reference the active cell.
Ctrl+[Select all cells directly referenced by formulas in the selection.
Alt, M, Q, WInserts Web function.
Alt, P, T, HChanges the overall design of the entire document, including colors, fonts, and effects.
Alt, H, O, RRename Sheet
Alt, H, O, MMove or Copy Sheet
Alt, H, O, TTab Color
Alt, H, O, T, NNo Tab Color
Alt, H, O, T, MMore Sheet Tab Colors
Alt, H, O, PPrevents unwanted changes from others by limiting their ability to edit.
Alt, H, O, LLocks the selected cells to keep people from making changes to them. You must turn on Protect Sheet in order for this feature to work.
Alt, H, O, EShows the Format Cells dialog box.
Alt, P, O, EnterPortrait
Alt, P, O, Arrow-Down, EnterLandscape
Alt, H, JCell Styles
Alt, H, J, NNew Cell Style
Alt, H, J, MMerge Styles
Ctrl+EFlash Fill - Automatically fills in values.
Alt, A, F, FFlash Fill - Automatically fills in values.
Alt, H, F, D, NFind & Select Constants
Alt, W, F, FKeeps rows and columns visible while the rest of the worksheet scrolls (based on current selection).
Alt, W, F, RKeeps the top row visible while scrolling through the rest of the worksheet.
Alt, W, F, CKeeps the first column visible while scrolling through the rest of the worksheet.
Ctrl+/Selects the array containing the active cell.
Ctrl+In a selected row, select the cells that don't match the formula or static value in the active cell.
Ctrl+Shift+In a selected column, select the cells that don't match the formula or static value in the active cell.

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