quick reference summary · dcount function ex 386 ‘lookup & reference’ button (formulas tab...
TRANSCRIPT
Microsoft Excel 2013
Quick Reference Summary
Microsoft Excel 2013 Quick Reference Summary
TaskPage Number Ribbon
Other On-Screen Element
Shortcut Menu
Keyboard Shortcut
2-D Line Chart, Create
EX 478 ‘Insert Line Chart’ button (INSERT tab | Charts group)
‘Quick Analysis Lens’ button, Charts tab
3-D Cone Chart, Insert
EX 445 ‘Quick Analysis Lens’ button, CHARTS tab, More Charts button, All Charts tab (Insert Chart dialog box)
3-D Pie Chart, Explode
EX 313 Tap or click slice twice to select, display shortcut menu, ‘Format Data Point’
3-D Pie Chart, Rotate
EX 314 ‘3-D Rotation’
3-D Reference EX 306 Start entering formula, tap or click sheet tab, tap or click cell
Accounting Number Format, Apply
EX 32 ‘Accounting Number Format’ button (HOME tab | Number group)
‘Accounting Number Format’ button on mini toolbar
Format Cells ctrl+shift+dollar sign ($)
Auto Fill EX 16 Fill button (HOME tab | Editing group)
Drag fill handle
AutoFilter, Search Using
EX 377 Tap or click filter button in column to search, enter search string in Search box
AutoFilter, Turn On/Off
EX 377 Filter button (DATA tab | Sort & Filter group)
ctrl+shift+l
AutoFilter Data in Table
EX 374 Tap or click filter button in column to sort
Average EX 86 Sum arrow (HOME tab | Editing group) or (FORMULAS tab | Function Library group)
Insert Function box in formula bar, AVERAGE in ‘Select a function’ list, OK button, select range, OK button
Type =av, down arrow, enter
Axis Numbers, Format
EX 448 Double-tap or double-click number, NUMBER tab (Format Axis task pane)
C8554_QR_REV2.indd 1 08/11/13 5:36 PM
QR 2 Excel 2013 Quick Reference Summary
TaskPage Number Ribbon
Other On-Screen Element
Shortcut Menu
Keyboard Shortcut
Axis Title, Add to Chart
EX 174 Chart Elements button on chart, Axis Titles
Background Color EX 93 Fill Color arrow (HOME tab | Font group)
Format Cells, Fill tab (Format Cells dialog box)
ctrl+1
Background Formula Checking
EX 258 Options | FILE tab, Formulas in left pane (Excel Options dialog box), ‘Enable background error checking’ in right pane
Background, Format
EX 701 Background button (PAGE LAYOUT tab | Page Setup group)
Bold EX 26 Bold button (HOME tab | Font group)
Bold button on mini toolbar Format Cells ctrl+b
Border, Add EX 93 Borders arrow (HOME tab | Font group)
Cell Style EX 24 Cell Styles button (HOME tab | Styles group)
Cell Style, Create EX 292 Cell Styles button (HOME tab | Styles group), ‘New Cell Style’
Cell Style, Modify EX 296 Cell Styles button (HOME tab | Styles group), Merge Styles
Center across Selection
EX 357 Format Cells, Alignment tab (Format Cells dialog box), Horizontal button
Center Horizontally
EX 317 Page Setup Dialog BOX Launcher (PAGE LAYOUT tab | Page Setup Group), ‘Horizontally’ in Center on Page section (Margins tab)
Chart, Add EX 38 ‘Insert Pie or Doughnut Chart’ button (INSERT tab | Charts group)
Chart, Add Legend
EX 735 Chart Elements button on chart, Legend
Chart, Add Shadow
EX 736 ‘Format Plot Area’, Effects button in Format Plot Area task pane
Chart, Move to New Sheet
EX 41 Move Chart button (CHART TOOLS DESIGN tab | Location group)
Chart, Sparkline EX 160 Line Sparkline button (INSERT tab | Sparklines group)
Chart, Move to New Location on Same Worksheet
EX 311 Drag chart to new location
Chart, Resize EX 312 Enter value in Shape Height or Shape Width box (CHART TOOLS FORMAT tab | Size group)
Drag corner sizing handle
Microsoft Excel 2013 Quick Reference Summary (continued)
C8554_QR_REV2.indd 2 08/11/13 5:36 PM
Quick Reference Summary Excel 2013 QR 3
Exce
l Q
uic
k R
efer
ence
TaskPage Number Ribbon
Other On-Screen Element
Shortcut Menu
Keyboard Shortcut
Chart Filter, Apply EX 174 Chart Filters button on chart
Chart Style, Apply EX 40 Chart Styles button
Chart Style, Change
EX 176 More button (CHART TOOLS DESIGN tab | Chart Styles group)
Clear Cell Entries EX 52 Clear button (HOME tab | Editing group) Clear Contents
Drag fill handle back into selected range
Clear Contents
Clear Entire Worksheet
EX 52 Clear button (HOME tab | Editing group), Clear All
Column, Insert EX 145 Insert Cells arrow (HOME tab | Cells group)
Insert ctrl+shift+plus sign (+)
Column Width, Adjust
EX 34 Double-tap or double-click boundary or drag boundary
Column Width
Columns, Convert Text To
EX 435 ‘Text to Columns’ button (DATA tab | Data Tools group)
Comma Style, Apply
EX 32 Comma Style button (HOME tab | Number group)
Format Cells, Number tab (Format Cells dialog box)
Command Button Procedure, Enter
EX 665 View Code button (DEVELOPER tab | Controls group), Object arrow, enter VBA code
Command Button, Add
EX 652 Insert Controls button (DEVELOPER tab | Controls group)
Comment, Add EX 695 ‘Insert a Comment’ button (REVIEW tab | Comments group)
Insert Comment shift+f2
Comment, Format EX 699 Edit Comment button (REVIEW tab | Comments group)
Edit Comment
Comments, Display
EX 697 ‘Show All Comments’ button (REVIEW tab | Comments group)
Comments, Edit EX 697 Edit Comment
Comments, Hide EX 697 ‘Show All Comments’ button (REVIEW tab | Comments group)
Comments, Print EX 700 Page Setup Dialog Box Launcher (PAGE LAYOUT tab | Page Setup group), Comments arrow (Sheet tab in Page Setup Dialog box)
Compare Workbooks
EX 719 ‘View Side by Side’ button (VIEW tab | Window group)
Conditional Formatting
EX 100 Conditional Formatting button (HOME tab | Styles group)
Microsoft Excel 2013 Quick Reference Summary (continued)
C8554_QR_REV2.indd 3 08/11/13 5:36 PM
QR 4 Excel 2013 Quick Reference Summary
TaskPage Number Ribbon
Other On-Screen Element
Shortcut Menu
Keyboard Shortcut
Control(s), Format EX 659 Select control(s), Control Properties button (DEVELOPER tab | Controls group)
Copy and Paste EX 16 Copy button (HOME tab | Clipboard Group), select destination, Paste button (HOME tab | Clipboard group)
Drag fill handle Copy, select destination, PasteTouch mode: ‘Show Context Menu’ button on mini toolbar, Copy, select destination, Paste
ctrl+c; ctrl+v
Copy Worksheet EX 297 Select All button, Copy button (HOME tab | Clipboard group)
‘Move or Copy’ ctrl+c; ctrl+v
COUNTIF Function EX 389 ‘Lookup & Reference’ button (FORMULAS tab | Function Library group), COUNTIF
Insert Function box in formula bar, ‘Or select a category’, ‘Lookup & Reference’, COUNTIF
Currency Style, Apply
EX 98 Number Format Dialog Box Launcher (HOME tab | Number group), Currency in Category list (Format Cells dialog box)
Format Cells, Number tab (Format Cells dialog box)
Custom Format Code, Create
EX 290 Format Cells, Number tab (Format Cells dialog box), Custom category
Custom View, Save
EX 724 Custom Views button (VIEW tab | Workbook Views group)
Data Labels, Add to Chart
EX 173 Chart Elements button on chart, Data Labels
Data Point, Change Format
EX 483 Select data point, ‘Format Data Point’, ‘Fill & Line button (Format Data Point task pane), MARKER
Data Table, Define Range As
EX 228 ‘What-If Analysis’ button (DATA tab | Data Tools group), Data Table
Data Validation EX 565 Data Validation button (DATA tab | Data Tools group)
Date, Format EX 96 Format Cells, Number tab (Format Cells dialog box)
Date, Insert EX 148 ‘Date & Time’ button (FORMULAS tab | Function Library group)
Insert Function box in formula bar, ‘Or select a category’ arrow (Insert Function dialog box)
ctrl+semicolon (;)
DAVERAGE Function
EX 386 ‘Lookup & Reference’ button (FORMULAS tab | Function Library group), DAVERAGE
Insert Function box in formula bar, ‘Or select a category’, ‘Lookup & Reference’, DAVERAGE
Microsoft Excel 2013 Quick Reference Summary (continued)
C8554_QR_REV2.indd 4 08/11/13 5:36 PM
Quick Reference Summary Excel 2013 QR 5
Exce
l Q
uic
k R
efer
ence
TaskPage Number Ribbon
Other On-Screen Element
Shortcut Menu
Keyboard Shortcut
DCOUNT Function EX 386 ‘Lookup & Reference’ button (FORMULAS tab | Function Library group), DCOUNT
Insert Function box in formula bar, ‘Or select a category’, ‘Lookup & Reference’, DCOUNT
Dependent Arrows, Remove
EX 558 ‘Remove All Arrows’ button (FORMULAS tab | Formula Auditing group)
Dependents, Trace EX 557 Trace Dependents button (FORMULAS tab | Formula Auditing group)
DEVELOPER Tab, Display
EX 625 Options (FILE tab), Customize Ribbon (Excel Options Dialog box)
Digital Box/Signature, Add
EX 671 ‘Add a Signature Line’ button (INSERT tab | Text group)
Digital Signature, Review
EX 672 View Signatures (FILE tab | Info tab)
Distribute Workbook by Email
EX 711 Email button (FILE tab | Share tab), ‘Send as Attachment’ button
Document Properties, Change
EX 44 Properties button (FILE tab | Info tab)
Drill Data through Worksheets
EX 300 Select worksheets, enter data
Duplicates, Remove
EX 355 Remove Duplicates button (TABLE TOOLS DESIGN tab | Tools group)
Entry, Complete EX 7 Tap or click Enter box in formula bar
enter or arrow keys
Error Checking EX 558 Error Checking button (FORMULAS tab | Formula Auditing group), Trace Error button (Error Checking dialog box)
Filter, Remove EX 380 Clear button (DATA tab | Sort & Filter group)
Find and Replace EX 443 ‘Find & Select’ button (HOME tab | Editing group)
ctrl+h
Find Data EX 441 ‘Find & Select’ button (HOME tab | Editing group)
ctrl+f
Fit on One Page EX 115 Page Setup Dialog Box Launcher (PAGE LAYOUT tab | Page Setup group), Fit to (Page Setup dialog box)
Font, Change EX 25 Font arrow (HOME tab | Font group)
Font arrow on mini toolbar Touch mode: ‘Show Context Menu’ button on mini toolbar, Format Cells
Format Cells
Font Color, Change
EX 28 Font Color arrow (HOME tab | Font group)
Font Color arrow on mini toolbar
Format Cells, Font tab
Microsoft Excel 2013 Quick Reference Summary (continued)
C8554_QR_REV2.indd 5 08/11/13 5:36 PM
QR 6 Excel 2013 Quick Reference Summary
TaskPage Number Ribbon
Other On-Screen Element
Shortcut Menu
Keyboard Shortcut
Font Size, Increase EX 27 Font Size arrow (HOME tab | Font group) or ’Increase Font Size’ button (HOME tab | Font group)
Font Size arrow on mini toolbar
Format Cells
Form Controls EX 648 Insert Controls button (DEVELOPER tab | Controls group)
Format Painter EX 168 Format Painter button (HOME tab | Clipboard group)
Formats, Undo EX 238 Cell Styles button (HOME tab | Styles group), Normal
Formulas Version, Display
EX 115 ctrl+accent mark (`)
Freeze Panes EX 185 Freeze Panes button (VIEW tab | Window group), Freeze Panes
Goal Seek EX 188, EX 570
‘What-If Analysis’ button (DATA tab | Data Tools group), Goal Seek
Group Control, Remove Outline
EX 668 In VBE, press ctrl+g
Group Option Buttons
EX 651 Insert Controls button (DEVELOPER tab | Controls group)
Group/Ungroup Sheets
EX 322 ‘Select All Sheets’/Ungroup Sheets
Header, Add EX 110 ‘Header & Footer’ button (INSERT tab | text group)
Page Layout button on status bar, tap or click in header area
Hide/Unhide Workbook
EX 255 Hide/Unhide Window button (VIEW tab | Window group)
Hide/Unhide Worksheet
EX 255 Hide/Unhide
Hyperlink, Add EX 725 ‘Add a Hyperlink’ button (INSERT tab | Links group)
Hyperlink ctrl+k
Hyperlink, Delete EX 731 Remove Hyperlink
Hyperlink, Edit EX 731 Edit Hyperlink
Hyperlink, Format EX 728 Cell Styles button (HOME tab | Styles group)
Icon Sets EX 363 Conditional Formatting button (HOME tab | Styles group), New Rule, Format Style button (New Formatting Rule dialog box)
‘Quick Analysis Lens’ button, FORMATTING tab
Image, Insert EX 458 From File button (INSERT tab | Illustrations group)
Microsoft Excel 2013 Quick Reference Summary (continued)
C8554_QR_REV2.indd 6 08/11/13 5:36 PM
Quick Reference Summary Excel 2013 QR 7
Exce
l Q
uic
k R
efer
ence
TaskPage Number Ribbon
Other On-Screen Element
Shortcut Menu
Keyboard Shortcut
Import Data from Access File
EX 426 ‘Get Data From Access’ button (DATA tab | Get External Data group)
Import Data from Text File
EX 423 ‘Get Data From Text’ button (DATA tab | Get External Data group)
Import Data from Webpage
EX 429 ‘Get Data From Web’ button (DATA tab | Get External Data group)
Indent EX 140 Increase Indent button (HOME tab | Alignment group)
Format CellsTouch Mode: ‘Show Context Menu’ button on mini toolbar, Format Cells
INDEX Function EX 389 ‘Lookup & Reference’ button (FORMULAS tab | Function Library group), INDEX
Insert Function box in formula bar, ‘Or select a category’, ‘Lookup & Reference’, INDEX
Inspect Document EX 599 ‘Check for Issues button (FILE tab | Info tab), Inspect Document
Iterative Calculation
EX 562 Formulas button (Excel options dialog box), ‘Enable Iterative Calculations’
Macro VBA Code, View
EX 638 View Macros button (DEVELOPER tab | Code group)
View Code alt+f11
Macro, Assign Button on Quick Access Toolbar
EX 639 ‘Customize Quick Access Toolbar’, ‘Choose commands from’ arrow (Excel Options dialog box), Macros, Add button
Macro, Execute EX 637 Enable Content button (SECURITY WARNING bar), Unprotect Sheet button (REVIEW tab | Changes group)
Macro, Record EX 629 Record Macro button (DEVELOPER tab | Code group)
Macro, Set Security Level
EX 635 Macro Security button (DEVELOPER tab | Code group), ‘Disable all macros with notification’ option button
Macros, Enable EX 625 Macro Security button (DEVELOPER tab | Code group)
Magnify or Shrink View
EX 182 Zoom button (VIEW tab | Zoom group)
Zoom In or Zoom Out button on status bar
Microsoft Excel 2013 Quick Reference Summary (continued)
C8554_QR_REV2.indd 7 08/11/13 5:36 PM
QR 8 Excel 2013 Quick Reference Summary
TaskPage Number Ribbon
Other On-Screen Element
Shortcut Menu
Keyboard Shortcut
Margins, Change EX 110 Adjust Margins button (PAGE LAYOUT tab | Page Setup group)
Mark as Final EX 602 Protect Workbook button (FILE tab | Info gallery), ‘Mark as Final’
MATCH Function EX 389 ‘Lookup & Reference’ button (FORMULAS tab | Function Library group), MATCH
Insert Function box in formula bar, ‘Or select a category’, ‘Lookup & Reference’, MATCH
Maximum, Determine
EX 48 Sum arrow (HOME tab | Editing group), Max
Insert Function box in formula bar, Statistical category, MAX
Maximum on Customize Status Bar shortcut menu
=max
Merge and Center EX 29 ‘Merge & Center’ button (HOME tab | Alignment group)
Merge Workbooks EX 721 FILE tab | Options, ‘Compare and Merge Workbooks’ button (Excel Options dialog box)
‘Customize Quick Access Toolbar’, ‘Choose commands from’ arrow (Excel Options dialog box), All Commands, add ‘Compare and Merge Workbooks’ button
Minimum, Determine
EX 84 Sum arrow (HOME tab | Editing group), Min
Insert Function box in formula bar, Statistical category, MIN
=min
Name Cells EX 216 Define Name button (FORMULAS tab | Defined Names group)
Type name in Name box in formula bar
Name Manager EX 216 Name Manager button (FORMULAS tab | Defined Names group)
Names Based on Row Titles
EX 218 ‘Create from Selection’ button (FORMULAS tab | Defined Names group)
Type name in Name box in formula bar
ctrl+shift+f3
Orientation, Change
EX 110 ‘Change Page Orientation’ button (PAGE LAYOUT tab | Page Setup group)
Page Break, Insert EX 323 Breaks button (PAGE LAYOUT tab | Page Setup group), ‘Insert Page Break’
‘Page Break Preview’ button on status bar, drag page breaks
Page Break, Remove
EX 323 Breaks button (PAGE LAYOUT tab | Page Setup group), ‘Remove Page Break’
Page Breaks, Hide EX 324 Options | FILE tab, Advanced in left pane, ‘Show page breaks’ in right pane (Excel Options dialog box)
Page Layout View EX 48 Page Layout button on status bar
Password-Protect Worksheet
EX 255 Protect Sheet button (REVIEW tab | Changes group)
Paste Special EX 432 Paste arrow (HOME tab | Clipboard group), Paste Special
Paste Special
Microsoft Excel 2013 Quick Reference Summary (continued)
C8554_QR_REV2.indd 8 08/11/13 5:36 PM
Quick Reference Summary Excel 2013 QR 9
Exce
l Q
uic
k R
efer
ence
TaskPage Number Ribbon
Other On-Screen Element
Shortcut Menu
Keyboard Shortcut
Percent Series, Create with Fill Handle
EX 226 Fill button (HOME tab | Editing group)
Select range, drag fill handle Fill Series
Percent Style Format, Apply
EX 99 Percent Style button (HOME tab | Number group)
Format Cells, Number tab (Format Cells dialog box)
ctrl+shift+%
Picture, Add to Worksheet
EX 731 From File button (INSERT tab | Illustrations group)
PivotChart Report, Create Directly from Data
EX 518 PivotChart arrow (INSERT tab | Charts group), ‘PivotChart & PivotTable)
PivotChart, Change View
EX 516 Select/deselect check box(es) (PivotChart Fields task pane)
PivotChart, Create Report from PivotTable Report
EX 509 PivotChart button (PIVOTTABLE TOOLS ANALYZE tab | Tools group)
PivotTable Report, Add Calculated Field
EX 520 ‘Fields, Items, & Sets’ button (PIVOTTABLE TOOLS ANALYZE tab | Calculations group)
PivotTable Report, Display Field List/Header
EX 504 Field List or Field Headers button (PIVOTTABLE TOOLS ANALYZE tab | Show group)
PivotTable Report, Expand Collapse Buttons
EX 506 Expand/Collapse
PivotTable Report, Filter Using Row Label Filter
EX 494 Filter button in desired cell, select/deselect desired check boxes
PivotTable Report, Update Contents
EX 508 Refresh button (PIVOTTABLE TOOLS ANALYZE tab | Data group)
PivotTable Report, Use a Report Filter
EX 491 Drag field from Choose field to add to report area to FILTERS area (PivotTable Fields task pane)
PivotTable, Add Data
EX 487 Drag field(s) from Choose fields to add to report area
PivotTable, Change Layout
EX 488 Report Layout button (PIVOTTABLE TOOLS DESIGN tab | Layout group)
PivotTable, Change View
EX 490 Drag button in ROWS area (PivotTable Fields task pane)
PivotTable, Create EX 486 PivotTable button (INSERT tab | Tables group)
Quick Analysis
PivotTable, Remove Report Filter
EX 494 Drag button out of PivotTable Fields task pane
PivotTable, Switch Summary Functions
EX 499 ‘Summarize Values By’
Microsoft Excel 2013 Quick Reference Summary (continued)
C8554_QR_REV2.indd 9 08/11/13 5:36 PM
QR 10 Excel 2013 Quick Reference Summary
TaskPage Number Ribbon
Other On-Screen Element
Shortcut Menu
Keyboard Shortcut
PMT Function EX 221 Financial button (FORMULAS tab | Function Library group)
Insert Function button in formula bar, ‘Or select a category’, Financial, PMT
Precedent Arrows, Remove
EX 555 ‘Remove All Arrows’ button (FORMULAS tab | Formula Auditing group)
Precedents, Review on Different Worksheet
EX 556 Double-tap or double-click dashed precedent arrow, select cell reference in Go to list (Go To dialog box)
Precedents, Trace EX 552 Trace Precedents button (FORMULAS tab | Formula Auditing group)
Print EX 46 Print button (FILE tab | Print tab)
ctrl+p
Print Area, Set EX 248 Print Area button (PAGE LAYOUT tab | Page Setup group), ‘Set Print Area’
Print Named Sections
EX 249 Name arrow in formula bar, tap or click named section; Print button (FILE tab | Print tab)
Print Scaling, Change Back to 100%
EX 117 Page Setup Dialog Box Launcher (PAGE LAYOUT tab | Page Setup group), Adjust to (Page Setup dialog box)
Print Section of Worksheet
EX 114 Print Selection option (FILE tab | Print tab)
Proper Case, Convert Names To
EX 627 Type = proper in cell, tap or click Enter box in formula bar
Protect Cells EX 252 Format Cells, Protection tab (Format Cells dialog box)
Protect Worksheet EX 252 Protect Sheet button (REVIEW tab | Changes group)
Quick Access Toolbar, Reset
EX 671 FILE tab | Options, Reset button (Excel Options dialog box)
Quick Analysis Toolbar
EX 439 ‘Quick Analysis Lens’ button
Range Finder EX 89 Double-tap or double-click cell
Redo EX 51 Redo button on Quick Access Toolbar
ctrl+y
Reorder Sheet Tabs
EX 180 Drag sheet tab Move or Copy
Replicate Formulas
EX 437 Drag fill handle
Microsoft Excel 2013 Quick Reference Summary (continued)
C8554_QR_REV2.indd 10 08/11/13 5:36 PM
Quick Reference Summary Excel 2013 QR 11
Exce
l Q
uic
k R
efer
ence
TaskPage Number Ribbon
Other On-Screen Element
Shortcut Menu
Keyboard Shortcut
Rotate Text EX 135 Alignment Settings Dialog Box Launcher (HOME tab | Alignment group)
ROUND Function EX 282 ‘Math & Trig’ button, (FORMULAS tab | Function Library group), ROUND
Insert Function button in formula bar, ‘Or select a category’, ‘Math & Trig’, ROUND
Row, Insert EX 144 Insert Cells arrow (HOME tab | Cells group)
Insert ctrl+shift+plus sign (+)
Row Height, Adjust
EX 106 Drag row boundary Row Height
Save as Excel 97-2003 Workbook File Format
EX 602 FILE tab | Save As tab, ‘Save as type’ arrow
Save As Template EX 418 Save button on Quick Access Toolbar, ‘Save as Type’ arrow (Save As dialog box)
ctrl+s, ‘Save as Type’ arrow
Scenario PivotTable Worksheet, Create
EX 596 ‘What-If Analysis’ button (DATA tab | Data Tools group, Scenario Manager, Summary button (Scenario Manager dialog box)
Scenario, Save As EX 582 ‘What-If Analysis’ button (DATA tab | Data Tools group), Scenario Manager, Add button (Scenario Manager dialog box)
Screen Clipping, Insert
EX 461 ‘Take a Screenshot’ button (INSERT tab | Illustrations group), Screen Clipping
Screen Shot, Insert
EX 460 ‘Take a Screenshot’ button (INSERT tab | Illustrations group), tap or click live preview
Search for and Open Workbook
EX 326 Select location, enter name in Search box, (Open tab | FILE tab)
Select Adjacent Cell EX 36 arrow
Select All Data in a Cell
EX 51 Double-tap or double-click (if no spaces in data)
Select Cell One Window Down
EX 36 page down
Select Cell One Window Up
EX 36 page up
Select Cell One Worksheet Window to the Left
EX 36 alt+page up
Select Cell One Worksheet Window to the Right
EX 36 alt+page down
Select First Cell in Worksheet
EX 36 ctrl+home
Microsoft Excel 2013 Quick Reference Summary (continued)
C8554_QR_REV2.indd 11 08/11/13 5:36 PM
QR 12 Excel 2013 Quick Reference Summary
TaskPage Number Ribbon
Other On-Screen Element
Shortcut Menu
Keyboard Shortcut
Series, Create EX 137 Fill button (HOME tab | Editing group)
Drag fill handle
Shape, Add EX 733 Shapes button (INSERT tab | Illustrations group)
Share/Collaborate on Workbook
EX 706 Share Workbook button (REVIEW tab | Changes group)
Sheet Tab Color, Change
EX 43 Tab Color
Sheet Tab Name, Change
EX 43 Double-tap or double-click sheet tab
Slicer, Add EX 525 Insert Slicer button (PIVOTCHART TOOLS ANALYZE tab | Filter group)
SmartArt Graphic, Add
EX 451 ‘Insert a SmartArt Graphic’ button (INSERT tab | Illustrations group)
SmartArt Graphic, Add Picture
EX 454 Insert Picture icon in SmartArt graphic or in Text Pane
SmartArt Graphic, Add Shape
EX 453 Add Shape button (SMARTART TOOLS DESIGN tab | Create Graphic group)
Tap or click level item in Text Pane, ENTER
Add Shape
SmartArt Graphic, Add Style
EX 457 More button (SMARTART TOOLS DESIGN tab | SmartArt Styles group)
SmartArt Graphic, Add Text
EX 453 Text Pane button (SMARTART TOOLS DESIGN tab | Create Graphic group)
Tap or click left arrow on edge of graphic
Edit Text
SmartArt Graphic, Change Color
EX 452 Change Colors button (SMARTART TOOLS DESIGN tab | SmartArt Styles group)
Solver EX 575 Solver button (DATA tab | Analysis group)
Solver Answer Report, View
EX 580 Tap or click sheet tab containing report
Sort, Ascending EX 369 ‘Sort & Filter’ button (HOME tab | Editing group), ‘Sort A to Z’
Tap or click filter button of sort field, tap or click ‘Sort A to Z’
Sort, ‘Sort A to Z’
Sort, Descending EX 370 ‘Sort Largest to Smallest’ button (DATA tab | Sort & Filter group)
Tap or click filter button of sort field, tap or click ‘Sort Z to A’
Sort, ‘Sort Z to A’ (for alphabetic) or ‘Sort Largest to Smallest’ (for numeric)
Sort, Custom EX 370 ‘Sort & Filter’ button (HOME tab | Editing group), Custom Sort
Spelling, Check EX 108 Spelling button (REVIEW tab | Proofing group)
f7
Subtotals EX 392 Subtotal button (DATA tab | Outline group)
Microsoft Excel 2013 Quick Reference Summary (continued)
C8554_QR_REV2.indd 12 08/11/13 5:36 PM
Quick Reference Summary Excel 2013 QR 13
Exce
l Q
uic
k R
efer
ence
TaskPage Number Ribbon
Other On-Screen Element
Shortcut Menu
Keyboard Shortcut
Subtotals, Remove
EX 394 Subtotal button (DATA tab | Outline group), Remove All button (Subtotal dialog box)
Sum EX 14 Sum button (HOME tab | Editing group)
Insert Function button in formula bar, SUM in Select a function list
alt+equal sign (=) twice
SUMIF Function EX 388 ‘Lookup & Reference’ button (FORMULAS tab | Function Library group), SUMIF
Insert Function box in formula bar, ‘Or select a category’, ‘Lookup & Reference’, SUMIF
Table, Convert to Range
EX 391 ‘Convert to Range’ button (TABLE TOOLS DESIGN | Tools group)
Table, ‘Convert to Range’
Table, Format Range As
EX 352 ‘Format as Table’ button (HOME tab | Styles group)
Table, Name EX 354 Table name text box (TABLE TOOLS DESIGN tab | Properties group)
Template, Change Default Location
EX 419 Options (FILE tab), Save in left pane (Excel Options dialog box), type path in right pane in ‘Default personal templates location’ box
Text Box Control, Add
EX 653 Insert Controls button (DEVELOPER tab | Controls group)
Theme, Apply EX 91 Themes button (PAGE LAYOUT tab | Themes group)
Total Row, Insert EX 366 Total Row check box (TABLE TOOLS DESIGN tab | Table Style Options group)
‘Quick Analysis Lens’ button, TOTALS tab, Sum button
Trace Errors EX 258 Error Checking button (FORMULAS tab | Formula Auditing group)
Track Changes EX 709 Track Changes button (REVIEW tab | Changes group)
Track Changes, Review
EX 712 Track Changes button (REVIEW tab | Changes group), Highlight Changes
Track Changes, Turn Off
EX 717 Track Changes button (REVIEW tab | Changes group), Highlight Changes, remove check mark from ‘Track changes while editing’ check box
Transpose EX 434 Paste arrow (HOME tab | Clipboard group), Transpose button
Transpose button
Trendline, Add to Chart
EX 481 ‘Add Chart Element’ button (CHART TOOLS DESIGN tab | Chart Layouts group), Trendline
Add Trendline
Microsoft Excel 2013 Quick Reference Summary (continued)
C8554_QR_REV2.indd 13 08/11/13 5:36 PM
QR 14 Excel 2013 Quick Reference Summary
TaskPage Number Ribbon
Other On-Screen Element
Shortcut Menu
Keyboard Shortcut
Undo EX 51 Undo button on Quick Access Toolbar
ctrl+z
Unfreeze Panes EX 187 Freeze Panes button (VIEW tab | Window group), Unfreeze Panes
Unlock Cells EX 255 ‘Allow Users to Edit Ranges’ button (REVIEW Tab | Changes group)
Unprotect Password-Protected Worksheet
EX 623 Unprotect Sheet button (REVIEW tab | Changes group)
Unprotect Worksheet
EX 255 Unprotect Sheet button (REVIEW tab | Changes group)
Validation Circles EX 571 Data Validation arrow (DATA tab | Data Tools group)
Validation Rules, Copy
EX 567 Select cell, Paste arrow (HOME tab | Clipboard group), Paste Special, Validation (Paste Special dialog box)
VLOOKUP Function
EX 362 ‘Lookup & Reference’ button (FORMULAS tab | Function Library group), VLOOKUP
Insert Function box in formula bar, ‘Or select a category’, ‘Lookup & Reference’, VLOOKUP
Watch Window, Add Cells
EX 563 Add Watch button (FORMULAS tab | Formula Auditing group), select cell to watch
Watch Window, Close
EX 564 Close button on Watch Window title bar
Watch Window, Delete Cells
EX 564 Tap or click watched cell, Delete Watch button in Watch Window
Watch Window, Open
EX 563 Watch Window button (FORMULAS tab | Formula Auditing group)
Watermark EX 703 Insert WordArt button (INSERT tab | Text group)
Window, Remove Panes
EX 185 Double-tap or double-click intersection of split bars
Window, Split into Panes
EX 184 Split button (VIEW tab | Window group)
Windows, Arrange
EX 326 Arrange All button (VIEW tab | Window group)
WordArt Chart Title, Add
EX 448 Insert WordArt button (INSERT tab | Text group)
Worksheet, Add EX 297 Insert Cells arrow (HOME tab | Cells group), Insert Sheet
New sheet button Insert (sheet tab shortcut menu)
Microsoft Excel 2013 Quick Reference Summary (continued)
C8554_QR_REV2.indd 14 08/11/13 5:36 PM