Excel 2013 Shortcuts - NWU

1 ShortcutDescriptionAlt+;Select the visible cells in the current +=Insert an AutoSum +Arrow-LeftDecrease IndentAlt+Arrow-RightIncrease IndentAlt+EnterStarts a new line in the same +F1 Insert a column chart. Column charts are used to compare values across +F11 Opens the Microsoft Visual Basic For Applications Editor, in which you can create a macro by using Visual Basic for Applications (VBA).Alt+F2 Displays the Save As dialog +F4 Closes +F5 Refresh - Gets the latest data from the source connected to the active +F8 Displays the Macro dialog box to create, run, edit, or delete a +Page-DownMoves one screen to the right in a +Page-UpMoves one screen to the left in a +Shift+Arrow-DownSort AscendingAlt+Shift+Arrow-LeftUngroups a range of cells that were previously +Shift+Arrow-RightGroup - Ties a range of cells together so that they can be collapsed or +Shift+Arrow-UpSort DescendingAlt+Shift+F1 Inserts a new +Shift+LClear FilterAlt, A, ACreates or edit relationships between tables to show related data from different tables on the same , A, BSubtotal - Totals several rows of related data together by automatically inserting subtotals and totals for the selected , A, CClears the filter and sorts state for the current range of , A.

2 ESeparates the contents of one Excel cell into separate , A, F, AImport data from a Microsoft Access , A, F, FFlash Fill - Automatically fills in , A, F, OImports data from other data , A, F, TImport data from a text , A, F, WImports data from a Web , A, G, AAuto OutlineAlt, A, G, GGroup - Ties a range of cells together so that they can be collapsed or , A, HHide Detail - Collapses a group of , A, JShow Detail - Expands a collapsed group of , A, KDisplays all of the other files this spreadsheet is linked , A, LGroup and Outline Settings - Shows the Outline dialog , A, MDelete duplicate rows from a sheet. You can specify which columns should be checked for duplicate information. - Data > Data Tools > Remove DuplicatesAlt, A, NConsolidate - Combines values from multiple ranges into one new , A, ODisplays all data connections for the , 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 , A, QAdvanced - Specifies complex criteria to limit which records are included in the result set of a , A, R, ARefresh all - Updates all the information that is coming from a data , A, R, CCancels , A, R, OConnection PropertiesAlt, A, R, RRefresh - Gets the latest data from the source connected to the active , A, R, SRefresh StatusAlt, A, S, ASorts the selection so that the lowest values are at the top of the , A, S, DSorts the selection so that the highest values are at the top of the , A.

3 S, SSort - Shows the Sort dialog box to sort data based on several criteria at , A, TApplies a data , A, U, CClear OutlineAlt, A, U, UUngroups a range of cells that were previously , A, V, ICircle Invalid DataAlt, A, V, RClear Validation CirclesAlt, A, V, VPrevent invalid data from being entered into a , A, W, GGoal SeekAlt, A, W, SScenario ManagerAlt, A, W, TData TableAlt, A, XConnects to an external data , A, Y, 3 Reapplies the filter and sort in the current , F, ADisplays the Save As dialog , F, CCloses the selected workbook , F, E, BExport (Browser View Options)Alt, F, E, CExport (Change File Type)Alt, F, E, PExport (Create PDF/XPS Document)Alt, F, H, ESend using email (as attachment)Alt, F, H, SShare (Invite People) - File > Share > Invite PeopleAlt, F, I, ACheck Accessibility - Check the workbook for content that people with disabilities might find difficult to read.

4 - Check for Issues > Check AccessibilityAlt, F, I, CCheck Compatibility - Check for features not supported by earlier versions of Excel . - Check for Issues > Check CompatibilityExcel 2013 ShortcutsAlt, F, I, IInspect Document - Check the workbook for hidden properties or personal information. - Check for Issues > Inspect DocumentAlt, F, I, P, EEncrypt with Password - Require a password to open this workbook. - Protect Workbook > Encrypt with PasswordAlt, F, I, P, FMark as Final - Let readers know the workbook is final and make it read-only. - Protect Workbook > Mark as FinalAlt, F, I, Q, PInfo (Show All Properties)Alt, F, I, Q, SInfo (Properties)Alt, F, I, RInfo (Manage Versions)Alt, F, N, LBlank workbookAlt, F, N, SSearch online templatesAlt, F, O, AOpen (Add a place)Alt, F, O, COpen (Computer)Alt, F, O, KOpen (SkyDrive)Alt, F, O, ROpen (Recent Workbooks)Alt, F, PDisplays the Print dialog , F, P, AOnly prints the active , F, P, CCollation / UncollationAlt, F, P, FPrint Preview (Next Page)Alt, F, P, GChecks out the full set of page formatting , F, P, HPrint From PagesAlt, F, P, IPrint (Which Printer)Alt, F, P, JPrint to PageAlt, F, P, LPrint (Page Size)Alt, F, P, MPrint (Margins)Alt, F, P, NPrint (Copies)Alt, F, P, OPrint (Orientation)Alt, F, P, PPrintAlt, F, P, SPrints sheets at their actual , F, P, WPrint (Zoom to Page)Alt, F, P, XPrint (Show Margins)

5 Alt, F, SSaveAlt, F, TCustomizes language, display, and other program , F, XCloses , F, Y, 1 Account DialogAlt, F, Y, 1, BOffice BackgroundAlt, F, Y, 1, DAdd a serviceAlt, F, Y, 1, ERemoves your , F, Y, 1, NSwitches your , F, Y, 1, RUpdate OptionsAlt, H, 0 Shows more decimal places for a more precise , H, 3, DDouble underlines the selected , H, 3, UApplies or removes , H, 5 Decreases the margin between the border and the text in the , H, 6 Increases the margin between the border and the text in the , H, 9 Shows fewer decimal , H, A, BAligns text to the bottom of the , H, A, CApplies align , H, A, LApplies align , H, A, MAligns text so that it is centered between the top and bottom of the , H, A, NChanges currency format for the selected , H, A, RApplies align , H, A, TAligns text to the top of the , H, B, AAll BordersAlt, H, B, BBottom Double BorderAlt, H, B, CTop and Thick Bottom , H, B, DTop and Bottom BorderAlt, H, B, EErase BorderAlt, H, B, GDraw Border GridAlt, H, B, HThick Bottom BorderAlt, H, B, ILine ColorAlt, H, B, I, MMore Border ColorsAlt, H, B, LLeft BorderAlt, H, B, MMore BordersAlt, H, B, NRemoves the outline border from the selected , H, B, OBottom BorderAlt, H, B, PTop BorderAlt, H, B, RRight BorderAlt, H, B, SApplies the outline border to the selected , H, B, TThick Box BorderAlt, H, B, UTop and Bottom BorderAlt, H, B, WDraw BorderAlt, H, B, YLine StyleAlt, H, C, CCopies the selected , H, C, PCopies as , H, D, CDelete Sheet ColumnsAlt, H, D, DDeletes the selected , H, D, RDelete Sheet RowsAlt, H, D, SDelete SheetAlt, H, E, AClears everything from the selected , H, E, CClears the content of selected cells.

6 If editing text, deletes one character to the , H, E, FClears only the formatting that is applied to the selected , H, E, LClears the hyperlinks from the selected , H, E, MClears any comments that are attached to the selected , H, E, RRemove the hyperlinks and formatting from the selected , H, F, AShows the Alignment tab of the Format Cells dialog , H, F, CFont ColorAlt, H, F, C, MMore Font ColorsAlt, H, F, D, CFind & Select Conditional FormattingAlt, H, F, D, FDisplays the Find and Replace dialog box, with the Find tab , H, F, D, GDisplays the Go To dialog , H, F, D, MFind CommentsAlt, H, F, D, NFind & Select ConstantsAlt, H, F, D, OSelects objects including ink, shapes, and text is especially useful when working with objects that are behind the , H, F, D, PDisplays the Selection Pane to help select individual objects and to change their order and , H, F, D, RSearches for text you would like to change, and replaces it with something , H, F, D, SGo To SpecialAlt, H, F, D, UFind & Select FormulasAlt, H, F, D, VFind & Select Data ValidationAlt, H, F, FChanges the font , H, F, GIncreases the font , H, F, I, AFill Across WorksheetsAlt, H, F, I, DCopies the value from the cell above the active cell into the cell or the Formula , H, F, I, FAutomatically fill in values.

7 Enter a couple of examples you want as output and keep the active cell in the column you want filled , H, F, I, JFill JustifyAlt, H, F, I, LFill LeftAlt, 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 , H, F, I, SFill SeriesAlt, H, F, I, UFill UpAlt, H, F, KDecreases font , H, F, MShows the Number tab of the Format Cells dialog , H, F, NShows the Font tab of the Format Cells dialog , H, F, ODisplays the Office Clipboard Task , H, F, PCopies formatting from one place and apply it to , H, F, Q, DRotate Text DownAlt, H, F, Q, LAngle ClockwiseAlt, H, F, Q, MShows the Alignment tab of the Format Cells dialog , H, F, Q, OAngle CounterclockwiseAlt, H, F, Q, URotate Text UpAlt, H, F, Q, VVertical TextAlt, H, F, SChanges the font , H, HShadingAlt, H, H, MMore ColorsAlt, H, H, NRemoves cell , H, I, CInsert columnsAlt, H, I, IDisplays the Insert dialog box to insert blank , H, I, RInsert Sheet RowsAlt, H, I, SInserts a new , H, JCell StylesAlt, H, J, MMerge StylesAlt, H, J, NNew Cell StyleAlt, H, KDisplays the value of the cell with a thousands separator.

8 This will change the format of the cell to Accounting without a currency , H, LHighlights interesting cells, emphasize unusual values, and visualize data using Data Bars, Color Scales, and Icon Sets based on , H, L, C, EClears rules from entire , H, L, C, PClears rules from this , H, L, C, SClears rules from selected , H, L, C, TClears rules from this , H, L, DAdds a colored data bar to represent the value in a cell. The higher the value, the longer the , H, L, D, MData Bars MoreAlt, H, L, H, AHighlight cell rules: a date occurring (Conditional formatting)Alt, H, L, H, BHighlights cell rules: between (Conditional formatting)Alt, H, L, H, DHighlight cell rules: duplicate values (Conditional formatting)Alt, H, L, H, EHighlight cell rules: equal to (Conditional formatting)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, MHighlight cell rules: more rules (Conditional formatting)Alt, H, L, H, THighlight cell rules.

9 Text that contains (Conditional formatting)Alt, H, L, IChooses a set of icons to represent the values in the selected , H, L, I, MIcon Sets - More RulesAlt, H, L, NNew rule (Conditional formatting)Alt, H, L, RCreates, edits, deletes, and views all conditional formatting rules in the workbook by using the Conditional Formatting Rules , H, L, SApplies a color gradient to a range of cells. The color indicates where each cell value falls within that , H, L, S, MApplies a color gradient to a range of cells. The color indicates where each cell value falls within that , H, L, T, ATop-bottom rules: Above Average (Conditional formatting)Alt, H, L, T, BTop-bottom rules: Bottom 10 Items (Conditional formatting)Alt, H, L, T, MTop-bottom rules: More Rules (Conditional formatting)Alt, H, L, T, OTop-bottom rules: Bottom 10 % (Conditional formatting)Alt, H, L, T, PTop-bottom rules: Top 10 % (Conditional formatting)Alt, H, L, T, TTop-bottom rules: Top 10 Items (Conditional formatting)Alt, H, L, T, VTop-bottom rules: Below Average (Conditional formatting)Alt, H, M, AMerges each row of the selected cells into a larger , H, M, CCombine and center the contents of the selected cells in a new larger , H, M, MMerge the selected cells into one , H, M, USplits the current cell into multiple , H, NChoose how the values in a cell are displayed.

10 As a percentage, as currency, as a date or time, , H, O, AAutoFit Row HeightAlt, H, O, DDefault WidthAlt, H, O, EShows the Format Cells dialog , H, O, HRow heightAlt, H, O, IAutoFit Column WidthAlt, 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 , H, O, MMove or Copy SheetAlt, H, O, PPrevents unwanted changes from others by limiting their ability to , H, O, RRename SheetAlt, H, O, TTab ColorAlt, H, O, T, MMore Sheet Tab ColorsAlt, H, O, T, NNo Tab ColorAlt, H, O, U, CHides the selected , H, O, U, HUnhide SheetAlt, H, O, U, LUnhides any hidden columns within the , H, O, U, OUnhides any hidden rows within the , H, O, U, RHides the selected , H, O, U, SHide SheetAlt, H, O, WColumn WidthAlt, H, PDisplays the value of the cell as a , H, S, CClears the filter and sorts state for the current range of , H, S, FApplies a data , H, S, OSorts the selection so that the highest values are at the top of the , H, S, SSorts the selection so that the lowest values are at the top of the , H, S.