Excel 2010 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, A, BSubtotal - Total several rows of related data together by automatically inserting subtotals and totals for the selected cells. - Data > Outline > Subtotal
Alt, A, CClear - Clear the filter and sort state for the current range of data. - Data > Sort & Filter > Clear
Alt, A, EText to Columns - Separate the contents of one Excel cell into separate columns. For example, you can separate a column of full names into separate first and last name columns. In Word, use this feature to convert the selected text into a table, splitting the text into columns at each comma, period, or other character you specify. - Data > Data Tools > Text to Columns
Alt, A, F, AFrom Access - Import data from a Microsoft Access database. - Data > Get External Data > From Access
Alt, A, F, OFrom Other Sources - Import data from other data sources. - Data > Get External Data > From Other Sources
Alt, A, F, TFrom Text - Import data from a text file. - Data > Get External Data > From Text
Alt, A, F, WFrom Web - Import data from a Web page. - Data > Get External Data > From Web
Alt, A, G, AAuto Outline - Data > Outline > Group > Auto Outline
Alt, A, G, GGroup - Tie a range of cells together so that they can be collapsed or expanded. - Data > Outline > Group > Group
Alt, A, HHide Detail - Collapse a group of cells. - Data > Outline > Hide Detail
Alt, A, JShow Detail - Expand a collapsed group of cells. - Data > Outline > Show Detail
Alt, A, KEdit Links - View all of the other files this spreadsheet is linked to so that you can update or remove the links. - Data > Connections > Edit Links
Alt, A, LGroup and Outline Settings. - Show the Outline dialog box. - Data > Outline > Group and Outline Settings
Alt, A, MRemove Duplicates - Delete duplicate rows from a sheet. You can specify which columns should be checked for duplicate information. - Data > Data Tools > Remove Duplicates
Alt, A, NConsolidate - Combine values from multiple ranges into one new range. - Data > Data Tools > Consolidate
Alt, A, OConnections - Display all data connections for the workbook. Data connections are links to data outside of this workbook which can be updated if the source data changes. - Data > Connections
Alt, A, PProperties - Specify 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. - Data > Connections > Properties
Alt, A, QAdvanced - Specify complex criteria to limit which records are included in the result set of a query. - Data > Sort & Filter > Advanced
Alt, A, R, ARefresh All - Update all the information that is coming from a data source. - Data > Connections > Refresh All > Refresh All
Alt, A, R, CCancel Refresh - Data > Connections > Refresh All > Cancel Refresh
Alt, A, R, OConnection Properties - Data > Connections > Refresh All > Connection Properties
Alt, A, R, RRefresh - Update the information in the workbook that is coming from a data source. - Data > Connections > Refresh All > Refresh
Alt, A, R, SRefresh Status - Data > Connections > Refresh All > Refresh Status
Alt, A, S, ASort A to Z. - Sort the selection so that the lowest values are at the top of the column. - Data > Sort & Filter > Sort A to Z
Alt, A, S, DSort Z to A. - Sort the selection so that the highest values are at the top of the column. - Data > Sort & Filter > Sort Z to A
Alt, A, S, SSort - Show the Sort dialog box to sort data based on several criteria at once. - Data > Sort & Filter > Sort
Alt, A, TFilter - Enable filtering of the selected cells. Once filtering is turned on, click the arrow in the column header to choose a filter for the column. - Data > Sort & Filter > Filter
Alt, A, U, CClear Outline - Data > Outline > Ungroup > Clear Outline
Alt, A, U, UUngroup - Ungroup a range of cells that were previously grouped. - Data > Outline > Ungroup > Ungroup
Alt, A, V, ICircle Invalid Data - Data > Data Tools > Data Validation > Circle Invalid Data
Alt, A, V, RClear Validation Circles - Data > Data Tools > Data Validation > Clear Validation Circles
Alt, A, V, VData Validation - Prevent invalid data from being entered into a cell. For example, you could reject invalid dates or numbers greater than 1000. You can also force input to be chosen from a dropdown list of values you specify. - Data > Data Tools > Data Validation > Data Validation
Alt, A, W, GGoal Seek - Data > Data Tools > What-If Analysis > Goal Seek
Alt, A, W, SScenario Manager - Data > Data Tools > What-If Analysis > Scenario Manager
Alt, A, W, TData Table - Data > Data Tools > What-If Analysis > Data Table
Alt, A, XExisting Connections - Connect to an external data source by selecting from a list of commonly used sources. - Data > Get External Data > Existing Connections
Alt, A, Y, 2Reapply - Reapply the filter and sort in the current range. New or modified data in the column won't be filtered or sorted until you click Reapply. - Data > Sort & Filter > Reapply
Alt, F, ASave As
Alt, F, CClose
Alt, F, DSave & Send
Alt, F, HHelp
Alt, F, I, ICheck for Issues
Alt, F, I, PProtect Workbook
Alt, F, I, Q, PShow All Properties
Alt, F, I, Q, SProperties
Alt, F, I, RManage Versions
Alt, F, I, XReturn to Document
Alt, F, NNew
Alt, F, OOpen
Alt, F, PPrint
Alt, F, RRecent
Alt, F, SSave
Alt, F, TOptions
Alt, F, XExit
Alt, H, 0Increases Decimal
Alt, H, 1Applies or removes bold formatting - Home > Font > Bold
Alt, H, 2Applies or removes italic formatting. - Home > Font > Italic
Alt, H, 3, DDouble Underline - Double underline the selected text. - Home > Font > Underline > Double Underline
Alt, H, 3, UUnderline - Underline the selected text. - Home > Font > Underline > Underline
Alt, H, 5Decrease Indent - Decrease the margin between the border and the text in the cell. - Home > Alignment > Decrease Indent
Alt, H, 6Increase Indent - Increase the margin between the border and the text in the cell. - Home > Alignment > Increase Indent
Alt, H, 9Decreases Decimal
Alt, H, A, BBottom Align - Align text to the bottom of the cell. - Home > Alignment > Bottom Align
Alt, H, A, CApplies align justify.
Alt, H, A, LApplies align left.
Alt, H, A, MMiddle Align - Align text so that it is centered between the top and bottom of the cell. - Home > Alignment > Middle Align
Alt, H, A, NAccounting Number Format - Choose an alternate currency format for the selected cell. For instance, choose Euros instead of Dollars. - Home > Number > Accounting Number Format
Alt, H, A, RApplies align right.
Alt, H, A, TTop Align - Align text to the top of the cell. - Home > Alignment > Top Align
Alt, H, B, AAll Borders - Home > Font > Borders > All Borders
Alt, H, B, BBottom Double Border - Home > Font > Borders > Bottom Double Border
Alt, H, B, CTop and Thick Bottom Border. - Home > Font > Borders > Top and Thick Bottom Border
Alt, H, B, DTop and Bottom Border. - Home > Font > Borders > Top and Bottom Border
Alt, H, B, EErase Border - Home > Font > Borders > Erase Border
Alt, H, B, GDraw Border Grid - Home > Font > Borders > Draw Border Grid
Alt, H, B, HThick Bottom Border - Home > Font > Borders > Thick Bottom Border
Alt, H, B, ILine Color - Home > Font > Borders
Alt, H, B, I, MMore Colors - More Border Colors - Home > Font > Borders > More Colors
Alt, H, B, LLeft Border - Home > Font > Borders > Left Border
Alt, H, B, MMore Borders - Home > Font > Borders > More Borders
Alt, H, B, NNo Border - Home > Font > Borders > No Border
Alt, H, B, OBottom Border - Home > Font > Borders > Bottom Border
Alt, H, B, PTop Border - Home > Font > Borders > Top Border
Alt, H, B, RRight Border - Home > Font > Borders > Right Border
Alt, H, B, SOutside Borders - Outside Borders (Ctrl+Shift+&) - Home > Font > Borders > Outside Borders
Alt, H, B, TThick Box Border - Home > Font > Borders > Thick Box Border
Alt, H, B, UTop and Double Bottom Border. - Home > Font > Borders > Top and Double Bottom Border
Alt, H, B, WDraw Border - Draw Border Line - Home > Font > Borders > Draw Border
Alt, H, B, YLine Style - Home > Font > Borders > Line Style
Alt, H, C, CCopy - Copy the selection and put it on the Clipboard. - Home > Clipboard > Copy > Copy
Alt, H, C, PCopy as Picture - Home > Clipboard > Copy > Copy as Picture
Alt, H, DDelete - Delete cells, rows, or columns from the sheet or table. - Home > Cells > Delete
Alt, H, EClear - Delete everything from the cell, or selectively remove the formatting, the contents, or the comments. - Home > Editing > Clear
Alt, H, F, AFormat Cell Alignment - Show the Alignment tab of the Format Cells dialog box. - Home > Alignment > Format Cell Alignment
Alt, H, F, CFont Color - Home > Font > Font Color
Alt, H, F, DFind & Select - Find and select specific text, formatting, or type of information within the document. You can also replace the information with new text or formatting. - Home > Editing > Find & Select
Alt, H, F, FFont - Change the font face. - Home > Font
Alt, H, F, GIncrease Font Size - Increase the font size. - Home > Font > Increase Font Size
Alt, H, F, IFill - Continue a pattern into one or more adjacent cells. You can fill cells in any direction and into any range of adjacent cells. - Home > Editing > Fill
Alt, H, F, KDecrease Font Size - Decrease the font size. - Home > Font > Decrease Font Size
Alt, H, F, MFormat Cell Number - Show the Number tab of the Format Cells dialog box. - Home > Number > Format Cell Number
Alt, H, F, NFormat Cell Font - Show the Font tab of the Format Cells dialog box. - Home > Font > Format Cell Font
Alt, H, F, OOffice Clipboard - Show the Office Clipboard Task Pane. - Home > Clipboard > Office Clipboard
Alt, H, F, PFormat Painter - Copy formatting from one place and apply it to another. Double-click this button to apply the same formatting to multiple places in the document. - Home > Clipboard > Format Painter
Alt, H, F, QOrientation - Rotate text to a diagonal angle or vertical orientation. This is often used for labeling narrow columns. Click the currently selected text orientation again to reset the text back to normal orientation. - Home > Alignment > Orientation
Alt, H, F, SFont Size - Change the font size. - Home > Font > Font Size
Alt, H, HShading - Fill Color - Home > Font > Shading
Alt, H, H, NRemoves cell shading.
Alt, H, IInsert - Click here to insert cells, rows, or columns into the sheet or table, or to add a sheet to the workbook. - Home > Cells > Insert
Alt, H, KComma Style - Display the value of the cell with a thousands separator. This will change the format of the cell to Accounting without a currency symbol. - Home > Number > Comma Style
Alt, H, LConditional Formatting - Highlight interesting cells, emphasize unusual values, and visualize data using Data Bars, Color Scales, and Icon Sets based on criteria. - Home > Styles > Conditional Formatting
Alt, H, MMerge & Center - Click here to merge across several cells, or to split cells that have been merged back into individual cells. - Home > Alignment > Merge & Center
Alt, H, NNumber Format - Choose how the values in a cell are displayed: as a percentage, as currency, as a date or time, etc. - Home > Number > Number Format
Alt, H, OFormat - Change the row height or column width, organize sheets, or protect or hide cells. - Home > Cells > Format
Alt, H, PPercent Style - Display the value of the cell as a percentage. - Home > Number > Percent Style
Alt, H, SSort & Filter - Arrange data so that it is easier to analyze. You can sort the selected data in ascending or descending order, or you can temporarily filter out specific values. - Home > Editing > Sort & Filter
Alt, H, TFormat as Table - Quickly format a range of cells and convert it to a Table by choosing a pre-defined Table Style. - Home > Styles > Format as Table
Alt, H, UAutoSum - Click here to display the result of a simple calculation, such as Average or Maximum Value, after the selected cells. - Home > Editing > AutoSum
Alt, H, VPaste - Click here for more options such as pasting only the values or formatting. - Home > Clipboard > Paste
Alt, H, V, SPaste Special - Paste Special. (Ctrl+Alt+V) - Home > Clipboard > Paste > Paste Special
Alt, H, WWrap Text - Make all content visible within a cell by displaying it on multiple lines. - Home > Alignment > Wrap Text
Alt, H, XCut - Cut the selection and put it on the Clipboard. - Home > Clipboard > Cut
Alt, J, H, AScale with Document - Specify whether the header and footer should scale as you use the "Shrink To Fit" feature on the document. - Design > Options > Scale with Document
Alt, J, H, CFormat Picture - Format the picture in the header or footer to change the brightness, contrast, or size. - Design > Header & Footer Elements > Format Picture
Alt, J, H, DCurrent Date - Add the current date to the header or footer. - Design > Header & Footer Elements > Current Date
Alt, J, H, EGo to Header - Activate the header on this page so that you can edit it. - Design > Navigation > Go to Header
Alt, J, H, FDifferent First Page - Specify a unique header and footer for the first page of the document. - Design > Options > Different First Page
Alt, J, H, GGo to Footer - Activate the footer on this page so that you can edit it. - Design > Navigation > Go to Footer
Alt, J, H, HHeader - Add text to the header, such as the page number, the name of the sheet, or the date. - Design > Header & Footer > Header
Alt, J, H, IPicture - Add a picture to the header or footer. - Design > Header & Footer Elements > Picture
Alt, J, H, LAlign with Page Margins. - Align the sides of the header or footer to the page margins. - Design > Options > Align with Page Margins
Alt, J, H, NFile Name - Add the name of the current file to the header or footer. - Design > Header & Footer Elements > File Name
Alt, J, H, OFooter - Add text to the footer, such as the page number, the name of the sheet, or the date. - Design > Header & Footer > Footer
Alt, J, H, PPage Number - Add the page number to the header or footer. - Design > Header & Footer Elements > Page Number
Alt, J, H, RCurrent Time - Add the current time to the header or footer. - Design > Header & Footer Elements > Current Time
Alt, J, H, SSheet Name - Add the name of the sheet to the header or footer. - Design > Header & Footer Elements > Sheet Name
Alt, J, H, TFile Path - Add the name of the current file, including the full path, to the header or footer. - Design > Header & Footer Elements > File Path
Alt, J, H, UNumber of Pages - Add the number of pages to the header or footer. It will automatically update as you change the workbook. - Design > Header & Footer Elements > Number of Pages
Alt, J, H, VDifferent Odd & Even Pages. - Specify that odd-numbered pages should have a different header and footer from even-numbered pages. - Design > Options > Different Odd & Even Pages
Alt, M, A, ARemove Arrows - Remove the arrows drawn by Trace Precedents or Trace Dependents. - Formulas > Formula Auditing > Remove Arrows > Remove Arrows
Alt, M, A, DRemove Dependent Arrows - Formulas > Formula Auditing > Remove Arrows > Remove Dependent Arrows
Alt, M, A, PRemove Precedent Arrows - Formulas > Formula Auditing > Remove Arrows > Remove Precedent Arrows
Alt, M, BCalculate Now - Calculate the entire workbook now. This is only necessary if automatic calculation has been turned off. - Formulas > Calculation > Calculate Now
Alt, M, CCreate from Selection - Automatically generate names from the selected cells. Many people choose to use the text in the top row or the leftmost column of a selection. - Formulas > Defined Names > Create from Selection
Alt, M, DTrace Dependents - Show arrows that indicate what cells are affected by the value of the currently selected cell. - Formulas > Formula Auditing > Trace Dependents
Alt, M, EDate & Time - Browse and select from a list of date and time functions. - Formulas > Function Library > Date & Time
Alt, M, E, FInsert Function - Edit the formula in the current cell by choosing functions and editing the arguments. - Formulas > Function Library > Date & Time > Insert Function
Alt, M, FInsert Function - Edit the formula in the current cell by choosing functions and editing the arguments. - Formulas > Function Library > Insert Function
Alt, M, GMath & Trig - Browse and select from a list of math and trigonometry functions. - Formulas > Function Library > Math & Trig
Alt, M, G, FInsert Function - Edit the formula in the current cell by choosing functions and editing the arguments. - Formulas > Function Library > Math & Trig > Insert Function
Alt, M, HShow Formulas - Display the formula in each cell instead of the resulting value. - Formulas > Formula Auditing > Show Formulas
Alt, M, IFinancial - Browse and select from a list of financial functions. - Formulas > Function Library > Financial
Alt, M, I, FInsert Function - Edit the formula in the current cell by choosing functions and editing the arguments. - Formulas > Function Library > Financial > Insert Function
Alt, M, JCalculate Sheet - Calculate the current sheet now. This is only necessary if automatic calculation has been turned off. - Formulas > Calculation > Calculate Sheet
Alt, M, K, CCircular References - Formulas > Formula Auditing > Error Checking
Alt, M, K, ETrace Error - Formulas > Formula Auditing > Error Checking > Trace Error
Alt, M, K, KError Checking - Check for common errors that occur in formulas. - Formulas > Formula Auditing > Error Checking > Error Checking
Alt, M, LLogical - Browse and select from a list of logical functions. - Formulas > Function Library > Logical
Alt, M, L, FInsert Function - Edit the formula in the current cell by choosing functions and editing the arguments. - Formulas > Function Library > Logical > Insert Function
Alt, M, M, AApply Names - Formulas > Defined Names > Define Name > Apply Names
Alt, M, M, DDefine Name - Name cells so that you can refer to them in formulas by that name. For example, you might name the cells A20 to A40 "Expenses." Names can be used in formulas to make them easier to understand. - Formulas > Defined Names > Define Name > Define Name
Alt, M, NName Manager - Create, edit, delete, and find all the names used in the workbook. Names can be used in formulas as substitutes for cell references. For example:=SUM(MySales) instead of =SUM(C20:C30). - Formulas > Defined Names > Name Manager
Alt, M, OLookup & Reference - Browse and select from a list of lookup and reference functions. - Formulas > Function Library > Lookup & Reference
Alt, M, O, FInsert Function - Edit the formula in the current cell by choosing functions and editing the arguments. - Formulas > Function Library > Lookup & Reference > Insert Function
Alt, M, PTrace Precedents - Show arrows that indicate what cells affect the value of the currently selected cell. - Formulas > Formula Auditing > Trace Precedents
Alt, M, Q, CCompatibility
Alt, M, Q, EEngineering - Formulas > Function Library > More Functions > Engineering
Alt, M, Q, IInformation - Formulas > Function Library > More Functions > Information
Alt, M, Q, SStatistical - Marks the selected text for inclusion in the TOC. You specify at which level in the TOC the selected text should appear. - Formulas > Function Library > More Functions
Alt, M, RRecently Used - Browse and select from a list of recently used functions. - Formulas > Function Library > Recently Used
Alt, M, R, FInsert Function - Edit the formula in the current cell by choosing functions and editing the arguments. - Formulas > Function Library > Recently Used > Insert Function
Alt, M, SUse in Formula - Choose a name used in this workbook and insert it into the current formula. - Formulas > Defined Names > Use in Formula
Alt, M, S, PPaste Names - Paste Names (F3) - Formulas > Defined Names > Use in Formula > Paste Names
Alt, M, TText - Browse and select from a list of text functions. - Formulas > Function Library > Text
Alt, M, T, FInsert Function - Edit the formula in the current cell by choosing functions and editing the arguments. - Formulas > Function Library > Text > Insert Function
Alt, M, U, AAverage - Formulas > Function Library > AutoSum > Average
Alt, M, U, CCount Numbers - Formulas > Function Library > AutoSum > Count Numbers
Alt, M, U, FMore Functions - Formulas > Function Library > AutoSum > More Functions
Alt, M, U, IMin - Formulas > Function Library > AutoSum > Min
Alt, M, U, MMax - Formulas > Function Library > AutoSum > Max
Alt, M, U, SSum - Display the sum of the selected cells directly after the selected cells. - Formulas > Function Library > AutoSum > Sum
Alt, M, VEvaluate Formula - Show the Evaluate Formula dialog box to debug a formula by evaluating each part of the formula individually. - Formulas > Formula Auditing > Evaluate Formula
Alt, M, WWatch Window - Monitors the values of certain cells as changes are made to the sheet. The values are displayed in a separate window that remains visible, regardless of what area of the workbook is shown. - Formulas > Formula Auditing > Watch Window
Alt, M, X, AAutomatic - Formulas > Calculation > Calculation Options > Automatic
Alt, M, X, EAutomatic Except for Data Tables. - Formulas > Calculation > Calculation Options > Automatic Except for Data Tables
Alt, M, X, MManual - Formulas > Calculation > Calculation Options > Manual
Alt, N, AArea - Insert an area chart. Area charts emphasize differences between several sets of data over a period of time. - Insert > Charts > Area
Alt, N, A, AAll Chart Types - Show the Chart dialog box to choose a chart type to insert. - Insert > Charts > Area > All Chart Types
Alt, N, BBar - Insert a bar chart. Bar charts are the best chart type for comparing multiple values. - Insert > Charts > Bar
Alt, N, B, AAll Chart Types - Show the Chart dialog box to choose a chart type to insert. - Insert > Charts > Bar > All Chart Types
Alt, N, CColumn - Insert a column chart. Column charts are used to compare values across categories. - Insert > Charts > Column
Alt, N, C, AAll Chart Types - Show the Chart dialog box to choose a chart type to insert. - Insert > Charts > Column > All Chart Types
Alt, N, DScatter - Insert a Scatter chart, also known as an X Y chart. This type of chart compares pairs of values. Use it when the values being charted are not in X-axis order or when they represent separate measurements. - Insert > Charts > Scatter
Alt, N, D, AAll Chart Types - Show the Chart dialog box to choose a chart type to insert. - Insert > Charts > Scatter > All Chart Types
Alt, N, EEquation - Insert Equation - Insert > Symbols > Equation
Alt, N, E, IInsert New Equation - Insert > Symbols > Insert New Equation
Alt, N, FClip Art - Insert Clip Art into the document, including drawings, movies, sounds, or stock photography to illustrate a specific concept. - Insert > Illustrations > Clip Art
Alt, N, GSignature Line - Insert a signature line that specifies the individual who must sign. Inserting a digital signature requires that you obtain a digital ID, such as one from a certified Microsoft partner. - Insert > Text > Signature Line
Alt, N, G, AAdd Signature Services - Insert > Text > Signature Line > Add Signature Services
Alt, N, HHeader & Footer - Edit the Header or Footer of the document. The information in the Header or Footer will appear at the top or bottom of each printed page. - Insert > Text > Header & Footer
Alt, N, IHyperlink - Create a link to a Web page, a picture, an e-mail address, or a program. - Insert > Links > Hyperlink
Alt, N, JObject - Insert an embedded object. - Insert > Text > Object
Alt, N, KAll Chart Types - Show the Chart dialog box to choose a chart type to insert. - Insert > Charts > All Chart Types
Alt, N, MSmartArt - Insert a SmartArt graphic to visually communicate information. SmartArt graphics range from graphical lists and process diagrams to more complex graphics, such as Venn diagrams and organization charts. - Insert > Illustrations > SmartArt
Alt, N, NLine - Insert a line chart. Line charts are used to display trends over time. - Insert > Charts > Line
Alt, N, N, AAll Chart Types - Show the Chart dialog box to choose a chart type to insert. - Insert > Charts > Line > All Chart Types
Alt, N, OOther Charts - Insert a stock, surface, doughnut, bubble, or radar chart. - Insert > Charts > Other Charts
Alt, N, O, AAll Chart Types - Show the Chart dialog box to choose a chart type to insert. - Insert > Charts > Other Charts > All Chart Types
Alt, N, PPicture - Insert a picture from a file. - Insert > Illustrations > Picture
Alt, N, QPie - Insert a pie chart. Pie charts display the contribution of each value to a total. Use it when values can be added together or when you have only one data series and all values are positive. - Insert > Charts > Pie
Alt, N, Q, AAll Chart Types - Show the Chart dialog box to choose a chart type to insert. - Insert > Charts > Pie > All Chart Types
Alt, N, S, CScreenshot - Insert a picture of any program that is not minimized to the taskbar. Click Screen Clipping to insert a picture of any part of the screen. - Insert > Illustrations > Screenshot
Alt, N, S, C, CScreen Clipping - Insert a picture of part of the screen into the file. - Insert > Illustrations > Screenshot > Screen Clipping
Alt, N, S, FSlicer - Insert a slicer to filter data interactively. Slicers make it faster and easier to filter PivotTables and cube functions. - Insert > Filter > Slicer
Alt, N, S, HShapes - Insert ready-made shapes, such as rectangles and circles, arrows, lines, flowchart symbols, and callouts. - Insert > Illustrations > Shapes
Alt, N, S, LLine - Insert a line chart within a single cell. - Insert > Sparklines > Line
Alt, N, S, OColumn - Insert a column chart within a single cell. - Insert > Sparklines > Column
Alt, N, S, WWin/Loss - Insert a win/loss chart within a single cell. - Insert > Sparklines > Win/Loss
Alt, N, TTable - Create a table to manage and analyze related data. Tables make it easy to sort, filter, and format data within a sheet. - Insert > Tables > Table
Alt, N, USymbol - Insert characters that are not on your keyboard, such as copyright symbols, trademark symbols, paragraph marks, and Unicode characters. - Insert > Symbols > Symbol
Alt, N, V, CPivotChart - Insert PivotChart - Insert > Tables > PivotTable > PivotChart
Alt, N, V, TPivotTable - Summarize data using a PivotTable. PivotTables make it easy to arrange and summarize complicated data and drill down on details. - Insert > Tables > PivotTable > PivotTable
Alt, N, WWordArt - Insert decorative text in your document. - Insert > Text > WordArt
Alt, N, XText Box - Insert a text box that can be positioned anywhere on the page. - Insert > Text > Text Box
Alt, P, A, A, BAlign Bottom - Page Layout > Arrange > Align > Align Bottom
Alt, P, A, A, CAlign Center - Page Layout > Arrange > Align > Align Center
Alt, P, A, A, GView Gridlines - Show the lines between rows and columns in the sheet to make editing and reading easier. - Page Layout > Arrange > Align > View Gridlines
Alt, P, A, A, HDistribute Horizontally - Page Layout > Arrange > Align > Distribute Horizontally
Alt, P, A, A, LAlign Left - Page Layout > Arrange > Align > Align Left
Alt, P, A, A, MAlign Middle - Page Layout > Arrange > Align > Align Middle
Alt, P, A, A, PSnap to Grid - Page Layout > Arrange > Align > Snap to Grid
Alt, P, A, A, RAlign Right - Page Layout > Arrange > Align > Align Right
Alt, P, A, A, SSnap to Shape - Page Layout > Arrange > Align > Snap to Shape
Alt, P, A, A, TAlign Top - Page Layout > Arrange > Align > Align Top
Alt, P, A, A, VDistribute Vertically - Page Layout > Arrange > Align > Distribute Vertically
Alt, P, A, E, BSend Backward - Send the selected object backward so that it is hidden by the objects that are in front of it. - Page Layout > Arrange > Send Backward > Send Backward
Alt, P, A, E, KSend to Back - Send the selected object behind all other objects. - Page Layout > Arrange > Send Backward > Send to Back
Alt, P, A, F, FBring Forward - Bring the selected object forward so that it is hidden by fewer objects that are in front of it. - Page Layout > Arrange > Bring Forward > Bring Forward
Alt, P, A, F, RBring to Front - Bring the selected object in front of all other objects so that no part of it is hidden behind another object. - Page Layout > Arrange > Bring Forward > Bring to Front
Alt, P, A, G, ERegroup - Page Layout > Arrange > Group > Regroup
Alt, P, A, G, GGroup - Join two or more selected objects together so they will be treated as one object. - Page Layout > Arrange > Group > Group
Alt, P, A, G, UUngroup - Break a set of grouped objects back into individual objects. - Page Layout > Arrange > Group > Ungroup
Alt, P, A, PSelection Pane - Show the Selection Pane to help select individual objects and to change their order and visibility. - Page Layout > Arrange > Selection Pane
Alt, P, A, YRotate - Rotate or flip the selected object. - Page Layout > Arrange > Rotate
Alt, P, A, Y, MMore Rotation Options - Page Layout > Arrange > Rotate > More Rotation Options
Alt, P, B, AReset All Page Breaks. - Page Layout > Page Setup > Breaks > Reset All Page Breaks
Alt, P, B, IInsert Page Break - Page Layout > Page Setup > Breaks > Insert Page Break
Alt, P, B, RRemove Page Break - Page Layout > Page Setup > Breaks > Remove Page Break
Alt, P, GBackground - Choose an image to display as the background of the sheet. - Page Layout > Page Setup > Background
Alt, P, HHeight - Shrink the height of printed output to fit a maximum number of pages. - Page Layout > Scale to Fit > Height
Alt, P, IPrint Titles - Specify rows and columns to repeat on each printed page. - Page Layout > Page Setup > Print Titles
Alt, P, MMargins - Select the margin sizes for the entire document or the current section. - Page Layout > Page Setup > Margins
Alt, P, M, ACustom Margins - Page Layout > Page Setup > Margins > Custom Margins
Alt, P, OOrientation - Switch the pages between portrait and landscape layouts. - Page Layout > Page Setup > Orientation
Alt, P, R, CClear Print Area - Page Layout > Page Setup > Print Area > Clear Print Area
Alt, P, R, SSet Print Area - Page Layout > Page Setup > Print Area > Set Print Area
Alt, P, S, OSheet Options - Show the Sheet tab of the Page Setup dialog box. - Page Layout > Sheet Options
Alt, P, S, PPage Setup - Show the Page tab of the Page Setup dialog box.
Alt, P, S, ZSize - Choose a paper size for the current section. To apply a specific paper size to all sections in the document, click More Paper Sizes. - Page Layout > Page Setup > Size
Alt, P, T, CColors - Current: Office Change the colors for the current theme. - Page Layout > Themes > Colors
Alt, P, T, C, CCreate New Theme Colors. - Page Layout > Themes > Colors > Create New Theme Colors
Alt, P, T, EEffects - Current: Office Change the effects for the current theme. - Page Layout > Themes > Effects
Alt, P, T, FFonts - Current: Office Heading: Cambria Body: Calibri Change the fonts for the current theme. - Page Layout > Themes > Fonts
Alt, P, T, F, CCreate New Theme Fonts. - Page Layout > Themes > Fonts > Create New Theme Fonts
Alt, P, T, H, ASave Current Theme - Page Layout > Themes > Save Current Theme
Alt, P, T, H, BBrowse for Themes - Page Layout > Themes > Browse for Themes
Alt, P, WWidth - Shrink the width of printed output to fit a maximum number of pages. - Page Layout > Scale to Fit > Width
Alt, P, XScale - Stretch or shrink the printed output to a percentage of its actual size. The maximum width and height must be set to "Automatic" to use this feature. - Page Layout > Scale to Fit > Scale
Alt, P, Y, P, GPrint - Print the lines between rows and columns in the sheet to make reading easier. - Page Layout > Sheet Options > Gridlines > Print
Alt, P, Y, P, HPrint - Print row and column headings. Row headings are the row numbers to the side of the sheet. Column headings are the letters or numbers that appear above the columns on a sheet. - Page Layout > Sheet Options > Headings > Print
Alt, P, Y, V, GView - Show the lines between rows and columns in the sheet to make editing and reading easier. These lines will not print unless Print is also checked. - Page Layout > Sheet Options > Gridlines > View
Alt, P, Y, V, HView - Show row and column headings. Row headings are the row numbers to the side of the sheet. Column headings are the letters or numbers that appear above the columns on a sheet. - Page Layout > Sheet Options > Headings > View
Alt, R, AShow All Comments - Display all comments in the sheet. - Review > Comments > Show All Comments
Alt, R, CNew Comment - Add a comment about the selection. - Review > Comments > New Comment
Alt, R, DDelete - Delete the selected comment. - Review > Comments > Delete
Alt, R, EThesaurus - Suggests other words with a similar meaning to the word you have selected. - Review > Proofing > Thesaurus
Alt, R, G, CAccept/Reject Changes - Review > Changes > Track Changes > Accept/Reject Changes
Alt, R, G, HHighlight Changes - Review > Changes > Track Changes > Highlight Changes
Alt, R, HShow/Hide Comment - Show or hide the comment attached to the selected cell. - Review > Comments > Show/Hide Comment
Alt, R, IShow Ink - Show or hide any ink annotations on the sheet. - Review > Comments > Show Ink
Alt, R, LTranslate - Translate selected text into a different language. - Review > Language > Translate
Alt, R, NNext - Navigate to the next comment in the document. - Review > Comments > Next
Alt, R, OProtect and Share Workbook. - Share the workbook and protect it with a password at the same time. The password will prevent others from turning off change tracking. - Review > Changes > Protect and Share Workbook
Alt, R, P, SProtect Sheet - Prevent unwanted changes to the data in a sheet by specifying what information can be changed. For example, you can prevent people from editing locked cells or changing the formatting of the document. You can specify a password that can by entered to unprotect the sheet and allow these changes. - Review > Changes > Protect Sheet
Alt, R, P, WProtect Workbook - Prevent unwanted changes to the structure of the workbook, such as moving, deleting, or adding sheets. You can specify a password that can be entered to unprotect the workbook and allow these changes. - Review > Changes > Protect Workbook
Alt, R, RResearch - Open the Research Task Pane to search through reference materials, such as dictionaries, encyclopedias, and translation services. - Review > Proofing > Research
Alt, R, SSpelling - Check the spelling of text. - Review > Proofing > Spelling
Alt, R, TEdit Comment - Add a comment about the selection. - Review > Comments > Edit Comment
Alt, R, UAllow Users to Edit Ranges. - Allows specific people to edit ranges of cells in a protected workbook or sheet. Before using this feature, first set security on the sheet by using the Protect Sheet command. To use this feature, your computer must be joined to a Microsoft Windows domain. - Review > Changes > Allow Users to Edit Ranges
Alt, R, VPrevious - Select the previous comment in the sheet. - Review > Comments > Previous
Alt, R, WShare Workbook - Allow multiple people to work in a workbook at the same time. The workbook should be saved to a network location where multiple people can open it. Workbooks containing tables cannot be shared. - Review > Changes > Share Workbook
Alt, W, AArrange All - Tile all open program windows side-by-side on the screen. - View > Window > Arrange All
Alt, W, BView Side by Side. - View two worksheets side-by-side so that you can compare their contents. - View > Window > View Side by Side
Alt, W, CCustom Views - Save a set of display and print settings as a custom view. Once you have saved the current view, you can apply it to the document by selecting it from the list of available custom views. - View > Workbook Views > Custom Views
Alt, W, EFull Screen - View the document in full screen mode. - View > Workbook Views > Full Screen
Alt, W, FFreeze Panes - Keep a portion of the sheet visible while the rest of the sheet scrolls. - View > Window > Freeze Panes
Alt, W, GZoom to Selection - Zoom the worksheet so that the currently selected range of cells fills the entire window. This can help you focus on a specific area of the spreadsheet. - View > Zoom > Zoom to Selection
Alt, W, HHide - Hide the current window so that it cannot be seen. To bring the window back, click the Unhide button. - View > Window > Hide
Alt, W, IPage Break Preview - View a preview of where pages will break when this document is printed. - View > Workbook Views > Page Break Preview
Alt, W, J100% - Zoom the document to 100% of the normal size. - View > Zoom > 100%
Alt, W, KSave Workspace - Save the current layout of all windows as a workspace so that it can be restored later. - View > Window > Save Workspace
Alt, W, LNormal - View the document in Normal view. - View > Workbook Views > Normal
Alt, W, M, RRecord Macro - Record a macro. Each of the commands you perform will be saved into the macro so that you can play them back again. - View > Macros > Record Macro
Alt, W, M, UUse Relative References - Use relative references so that macros are recorded with actions relative to the initial selected cell. For instance, if you record a macro in cell A1 which moves the cursor to A3 with this option turned on, running the resulting macro in cell J6 would move the cursor to J8. If this option was turned off when the macro was recorded, running it in cell J6 would move the cursor to A3. - View > Macros > Use Relative References
Alt, W, M, VView Macros - View the list of macros, from which you can run, create, or delete a macro. - View > Macros > View Macros
Alt, W, NNew Window - Open a new window containing a view of the current document. - View > Window > New Window
Alt, W, PPage Layout - View the document as it will appear on the printed page. Use this view to see where pages begin and end, and to view any headers or footers on the page. - View > Workbook Views > Page Layout
Alt, W, QZoom - Show the Zoom dialog box to specify the zoom level of the document. In most cases, you can also use the zoom controls in the status bar at the bottom of the window to quickly zoom the document. - View > Zoom
Alt, W, RRuler - View the rulers, used to measure and line up objects in the document. - View > Show > Ruler
Alt, W, SSplit - Split the window into multiple resizable panes containing views of your worksheet. You can use this feature to view multiple distant parts of your worksheet at once. - View > Window > Split
Alt, W, TReset Window Position - Reset the window position of the documents being compared side-by-side so that they share the screen equally. To enable this feature, turn on View Side by Side. - View > Window > Reset Window Position
Alt, W, UUnhide - Unhide any windows hidden by the Hide Window feature. - View > Window > Unhide
Alt, W, V, FFormula Bar - View the formula bar, in which you can enter text and formulas into cells. - View > Show > Formula Bar
Alt, W, V, GGridlines - Show the lines between rows and columns in the sheet to make editing and reading easier. - View > Show > Gridlines
Alt, W, V, HHeadings - Show row and column headings. Row headings are the row numbers to the side of the sheet. Column headings are the letters or numbers that appear above the columns on a sheet. - View > Show > Headings
Alt, W, V, SSynchronous Scrolling - Synchronize the scrolling of two documents so that they scroll together. To enable this feature, turn on View Side by Side. - View > Window > Synchronous Scrolling
Alt, W, WSwitch Windows - Switch to a different currently open window. - View > Window > Switch Windows
Alt, W, W, 11 Book1 - View > Window > Switch Windows > 1 Book1
Alt, W, Z, ZZoom - View > Zoom
Alt, Y, AAdd Tree Level - Team Foundation Add-in Press F1 for add-in help. - Team > Tree > Add Tree Level
Alt, Y, CChoose Columns - Team Foundation Add-in Press F1 for add-in help. - Team > Work Items > Choose Columns
Alt, Y, EEdit Areas and Iterations. - Team Foundation Add-in Press F1 for add-in help. - Team > Work Items > Edit Areas and Iterations
Alt, Y, F, NServer Connection - Team Foundation Add-in Press F1 for add-in help. - Team > Work Items > Configure > Server Connection
Alt, Y, F, SList - Team Foundation Add-in Press F1 for add-in help. - Team > Work Items > Configure > List
Alt, Y, GGet Work Items - Team Foundation Add-in Press F1 for add-in help. - Team > Work Items > Get Work Items
Alt, Y, HAdd Child - Team Foundation Add-in Press F1 for add-in help. - Team > Tree > Add Child
Alt, Y, ITeam Project Process Guidance. - Team Foundation Add-in Press F1 for add-in help. - Team > Help > Team Project Process Guidance
Alt, Y, JTeam Project Portal - Team Foundation Add-in Press F1 for add-in help. - Team > Help > Team Project Portal
Alt, Y, J, HDesign - Header & Footer Tools > Design
Alt, Y, LLinks and Attachments - Team Foundation Add-in Press F1 for add-in help. - Team > Work Items > Links and Attachments
Alt, Y, NNew List - Team Foundation Add-in Press F1 for add-in help. - Team > Work Items > New List
Alt, Y, ONew Report - Team Foundation Add-in Press F1 for add-in help. - Team > Reports > New Report
Alt, Y, PPublish - Team Foundation Add-in Press F1 for add-in help. - Team > Work Items > Publish
Alt, Y, RRefresh - Team Foundation Add-in Press F1 for add-in help. - Team > Work Items > Refresh
Alt, Y, TTeam Foundation Help - Team Foundation Add-in Press F1 for add-in help. - Team > Help > Team Foundation Help
Alt, Y, UOutdent - Team Foundation Add-in Press F1 for add-in help. - Team > Tree > Outdent
Alt, Y, WOpen in Web Access. - Team Foundation Add-in Press F1 for add-in help. - Team > Work Items > Open in Web Access
Alt, Y, XIndent - Team Foundation Add-in Press F1 for add-in help. - Team > Tree > Indent
Alt+Down-ArrowOpens a selected drop-down list.
Alt+EnterStarts a new line in the same cell.
Alt+F1Creates an embedded chart of the data in the current range.
Alt+F11Opens the Microsoft Visual Basic For Applications Editor, in which you can create a macro by using Visual Basic for Applications (VBA).
Alt+F2Displays the Save As dialog box.
Alt+F4Closes Excel.
Alt+F8Displays the Macro dialog box to create, run, edit, or delete a macro.
Alt+Page-DownMoves one screen to the right in a worksheet.
Alt+Page-UpMoves one screen to the left in a worksheet.
Alt+Shift+F1Inserts a new worksheet.
Alt+SpacebarDisplays the Control menu for the Excel window.
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.
Ctrl+;Enters the current date.
Ctrl+`Alternates between displaying cell values and displaying formulas in the worksheet.
Ctrl+0Hides the selected columns.
Ctrl+1Displays the Format Cells dialog box.
Ctrl+2Applies or removes bold formatting.
Ctrl+3Applies or removes italic formatting.
Ctrl+4Applies or removes underlining.
Ctrl+5Applies or removes strikethrough.
Ctrl+6Alternates between hiding and displaying objects.
Ctrl+8Displays or hides the outline symbols.
Ctrl+9Hides the selected rows.
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+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.
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+BApplies or removes bold formatting.
Ctrl+CCopies the selected cells.
Ctrl+DUses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
Ctrl+Down-ArrowMoves to the bottom of the current data region in a worksheet.
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.
Ctrl+EnterFills the selected cell range with the current entry.
Ctrl+FDisplays the Find and Replace dialog box, with the Find tab selected.
Ctrl+F1Displays or hides the ribbon.
Ctrl+F2Displays the print preview area on the Print tab in the Backstage view.
Ctrl+F3Displays the Name Manager dialog box.
Ctrl+F4Closes the selected workbook window.
Ctrl+F5Restores the window size of the selected workbook window.
Ctrl+F6Switches to the next workbook window when more than one workbook window is open.
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+F8Performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.
Ctrl+F9Minimizes a workbook window to an icon.
Ctrl+F10Maximizes or restores the selected workbook window.
Ctrl+GDisplays the Go To dialog box.
Ctrl+HDisplays the Find and Replace dialog box, with the Replace tab selected.
Ctrl+HomeMoves to the beginning of a worksheet.
Ctrl+IApplies or removes italic formatting.
Ctrl+KDisplays the Insert Hyperlink dialog box for new hyperlinks or theEdit Hyperlink dialog box for selected existing hyperlinks.
Ctrl+LDisplays the Create Table dialog box.
Ctrl+Left-ArrowMoves to the left corner of the current data region in a worksheet.
Ctrl+MinusDisplays the Delete dialog box to delete the selected cells.
Ctrl+Minus-NumblockDisplays the Delete dialog box to delete the selected cells.
Ctrl+NCreates a new, blank workbook.
Ctrl+ODisplays the Open dialog box to open or find a file.
Ctrl+PDisplays the Print tab in Microsoft Office Backstage view.
Ctrl+Page-DownMoves to the next sheet in a workbook.
Ctrl+Page-UpMoves to the previous sheet in a workbook.
Ctrl+PlusDisplays the Insert dialog box to insert blank cells.
Ctrl+Plus-NumblockDisplays the Insert dialog box to insert blank cells.
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+Right-ArrowMoves to the right corner of the current data region in a worksheet.
Ctrl+SSaves the active file with its current file name, location, and file format.
Ctrl+Shift+:Enters the current time.
Ctrl+Shift+_Removes the outline border from the selected cells.
Ctrl+Shift+~Applies the General number format.
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+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+4Applies the Currency format with two decimal places (negative numbers in parentheses).
Ctrl+Shift+5Applies the Percentage format with no decimal places.
Ctrl+Shift+6Applies the Scientific number format with two decimal places.
Ctrl+Shift+7Applies the outline border to the selected cells.
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+AInserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.
Ctrl+Shift+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.
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+Shift+FOpens the Format Cells dialog box with the Fonttab selected.
Ctrl+Shift+F3Displays the Create Name from Selection dialog box.
Ctrl+Shift+HomeExtends the selection of cells to the beginning of the worksheet.
Ctrl+Shift+LApplies a data filter.
Ctrl+Shift+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.
Ctrl+Shift+OSelects all cells that contain comments.
Ctrl+Shift+POpens the Format Cells dialog box with the Fonttab selected.
Ctrl+Shift+Page-DownSelects the current and next sheet in a workbook.
Ctrl+Shift+Page-UpSelects the current and previous sheet in a workbook.
Ctrl+Shift+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.
Ctrl+Shift+SpacebarSelects the entire worksheet. If the worksheet contains data, the key combination selects the current region. Pressing the key combination a second time selects the current region and its summary rows. Pressing the key combination a third time selects the entire worksheet. When an object is selected, the key combination selects all objects on a worksheet.
Ctrl+Shift+TabSwitches to the previous tab in a dialog box.
Ctrl+Shift+USwitches between expanding and collapsing of the formula bar.
Ctrl+Shift+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+SpacebarSelects an entire column in a worksheet.
Ctrl+TDisplays the Create Table dialog box.
Ctrl+TabSwitches to the next tab in dialog box.
Ctrl+UApplies or removes underlining.
Ctrl+Up-ArrowMoves to the top of the current data region in a worksheet.
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+WCloses the selected workbook window.
Ctrl+XCuts the selected cells.
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.
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.
Down-ArrowMove one cell down in a worksheet. Selects the next command when a menu or submenu is open. When a ribbon tab is selected, the key navigates down the tab group.
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.
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).
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.
F1Displays the Excel Help task pane.
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.
F3Displays the Paste Name dialog box. Available only if there are existing names in the workbook.
F4Repeats the last command or action, if possible.
F5Displays the Go To dialog box.
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.
F7Displays the Spelling dialog box to check spelling in the active worksheet or selected range.
F8Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection.
F9Calculates all worksheets in all open workbooks.
F10Turns key tips on or off. (Pressing ALT does the same thing.)
F11Creates a chart of the data in the current range in a separate Chart sheet.
F12Displays the Save As dialog box.
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.
Left-ArrowMove 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.
Page-DownMoves one screen down in a worksheet.
Page-UpMoves one screen up in a worksheet.
Right-ArrowMove 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.
Shift+Down-ArrowExtends the selection of the cells by one cell down
Shift+EnterCompletes a cell entry and selects the cell above.
Shift+F10Displays the shortcut menu for a selected item.
Shift+F11Inserts a new worksheet.
Shift+F2Adds or edits a cell comment.
Shift+F3Displays the Insert Function 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.
Shift+F6Switches between the worksheet, Zoom controls, task pane, and ribbon.
Shift+F8Enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.
Shift+F9Calculates the active worksheet.
Shift+Left-ArrowExtends the selection of the cells by one cell left
Shift+Right-ArrowExtends the selection of the cells by one cell right
Shift+SpacebarSelects an entire row in a worksheet.
Shift+TabMoves to the previous cell in a worksheet or the previous option in a dialog box.
Shift+Up-ArrowExtends the selection of the cells by one cell up
SpacebarIn a dialog box, performs the action for the selected button, or selects or clears a check 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.
Up-ArrowMove 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.

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 KeyRocket