Complete excel keyboard shortcuts

Page 1

Become an Excel Master

Complete

Keyboard Shortcuts

ExcelDemy.com


Become an Excel Master

MICROSOFT EXCEL 2013 Keyboard Shortcuts For Windows & Mac Users

ExcelDemy.com


Become an Excel Master

Feedback Find a problem or have a suggestion? Let us know: feedback@exceldemy.com

Links to Online Version Each shortcut is linked to an online version that has more detail. Just click the title of the shortcut to navigate to the same shortcut online. Online shortcuts are here: http://www.exceldemy.com/microsoft-excel-keyboard-shortcuts

Mac keyboard shortcuts Historically, Macintosh computers use special symbols for certain keys, including Alt, Shift, Control, and Command keys. This guide uses these symbols as follows:

Shift - - - - - - - - - - - - - -

Control - - - - - - - - - - - - - -

Option / Alt - - - - - - - -

Command - - - - - - - - - - - -

Function - - - - - - - - - -

Mouse Click - - - - - - - - - -

Mac computers have a special preference for function keys in System preferences. This guide assumes your Mac is set at the default, with Use all F1, F2, etc .keys as standard function keys unchecked. In this state, you generally have to use the function key (Fn) when using function keys (F1, F2, etc.)

Disclaimer These shortcuts were tested with Excel 2010 for Windows, and Excel 2011 for Macintosh. Many shortcuts should work with earlier versions of Excel, but not all. Shortcuts often do not work on a particular computer because other programs, or the operating system itself, has reserved some key combinations for another purpose.

ExcelDemy.com


Become an Excel Master

ExcelDemy.com No part of this publication shall be reproduced, transmitted, or sold in whole or in part in any form, without the prior written consent of the author. All trademarks and registered trademarks appearing in this guide are the property of their respective owners. Copyright 2014 ExcelDemy.com. All rights reserved.

ExcelDemy.com


Become an Excel Master

Table of Contents Excel File Shortcuts

Page 6

Excel Ribbon Shortcuts

Page 6

General Shortcuts

Page 7

Drag and Drop Shortcuts

Page 8

Navigation Shortcuts

Page 9

Selection Shortcuts

Page 10

Active Cell Shortcuts

Page 10

Extend Selection Shortcuts

Page 11

Select Special Shortcuts

Page 12

Cell Edit Shortcuts

Page 13

Entering Data Shortcuts

Page 14

Formatting Shortcuts

Page 15

Number Formatting Shortcuts

Page 16

Border Shortcuts

Page 17

Formula Shortcuts

Page 17

Grid Operation Shortcuts

Page 19

Pivot Table Shortcuts

Page 20

Workbook Shortcuts

Page 20

Dialog Box Shortcuts

Page 21

Other Shortcuts

Page 22

ExcelDemy.com


Become an Excel Master

Excel File Shortcuts Actions

Windows Shortcuts

Mac Shortcuts

Create New Workbook Open Workbook Save Workbook Save As Print File Open Print Preview Window Close Current Workbook Close Excel

Excel Ribbon Shortcuts Actions Expand or Collapse Ribbon Activate Access Keys Move to Next Ribbon Control Activate or Open Selected Control

ExcelDemy.com

Windows Shortcuts

Mac Shortcuts


Become an Excel Master

Confirm Control Change Get Help on Selected Control

General Shortcuts Actions Open Help Undo Last Action Redo Last Action Copy Selected Cells Cut Selected Cells Paste Content from Clipboard Display the Paste Special Dialog Box Display Find and Replace Display Find and Replace, Replace Selected Find Next Match Find Previous Match Create Embedded Chart Create Chart in New Worksheet ExcelDemy.com

Windows Shortcuts

Mac Shortcuts


Become an Excel Master

Toggle AutoFilter Activate Filter Insert Table Select Table Row Select Table Column Select Table

Drag and Drop Shortcuts Actions Drag and Cut Drag and Copy Drag and Insert Drag and Insert Copy Drag to Worksheet Drag to Duplicate Worksheet

ExcelDemy.com

Windows Shortcuts

Mac Shortcuts


Become an Excel Master

Navigation Shortcuts Actions Move One Cell Right Move One Cell Left Move One Cell Up Move One Cell Down Move One Screen Right Move One Screen Left Move One Screen Up Move One Screen Down Move to Right Edge of Data Region Move to Left Edge of Data Region Move to Top Edge of Data Region Move to Bottom Edge of Data Region Move to Beginning of Row Move to Last Cell in Worksheet Move to First Cell in Worksheet Turn End Mode on ExcelDemy.com

Windows Shortcuts

Mac Shortcuts


Become an Excel Master

Selection Shortcuts Actions

Windows Shortcuts

Mac Shortcuts

Select Entire Row Select Entire Column Select Entire Worksheet Add Non-Adjacent Cells to Selection Move Right between Non-Adjacent Selections Move Left between Non-Adjacent Selections Toggle Add to Selection Mode Cancel Selection

Active Cell Shortcuts Actions Select Active Cell Only Show the Active Cell on Worksheet Move Active Cell Clockwise in Selection Move Active Cell Down in Selection ExcelDemy.com

Windows Shortcuts

Mac Shortcuts


Become an Excel Master

Move Active Cell Up in Selection Move Active Cell Right in a Selection Move Active Cell Left in a Selection

Extend Selection Shortcuts Actions Extend Selection by One Cell Right Extend Selection by One Cell Left Extend Selection by One Cell Up Extend Selection by One Cell Down Extend the Selection to the Last Cell Right Extend the Selection to the Last Cell Left Extend the Selection to the Last Cell Up Extend the Selection to the Last Cell Down Extend Selection Up One Screen Extend Selection Down One Screen

ExcelDemy.com

Windows Shortcuts

Mac Shortcuts


Become an Excel Master

Extend Selection to Start of Row

Extend Selection to First Cell in Worksheet Extend Selection to Last Cell in Worksheet Toggle Extend Selection Mode

Select Special Shortcuts Actions Display ‘Go To’ Dialog Box Select Cells with Comments Select Current Region around Active Cell Select Current Region Select Current Array Select Row Differences Select Column Differences Select Direct Precedents Select All Precedents Select Direct Dependents ExcelDemy.com

Windows Shortcuts

Mac Shortcuts


Become an Excel Master

Select All Dependents Select Visible Cells Only

Cell Edit Shortcuts Actions Edit the Active Cell Insert or Edit Comment Cancel Entry Select One Character Right Select One Character Left Move One Word Up Move One Word Left Select One Word Right Select One Word Left Select to Beginning of Cell Select to End of Cell Delete to End of Line Delete Character to the Left of Cursor ExcelDemy.com

Windows Shortcuts

Mac Shortcuts


Become an Excel Master

Delete Character to the Right of Cursor Start a New Line in the Same Cell

Entering Data Shortcuts Actions Enter and Move Down Enter and Move Up Enter and Move Right Enter and Move Left Complete Entry and Stay in Same Cell Enter Same Data in Multiple Cells Insert Current Date Insert Current Time Fill Down from Cell Above Fill Right from Cell Left Copy Formula from Cell Above Copy Value from Cell Above

ExcelDemy.com

Windows Shortcuts

Mac Shortcuts


Become an Excel Master

Add Hyperlink Display AutoComplete List

Formatting Shortcuts Actions Display the Format Cells Dialog Box Display Format Cells with Font Tab Selected Apply Format Again Apply or Remove Bold Formatting Apply or Remove Italic Formatting Apply or Remove Underscoring Apply or Remove Strikethrough Formatting Add or Remove the Shadow Font Style Add or Remove the Outline Font Style Align Center Align Left

ExcelDemy.com

Windows Shortcuts

Mac Shortcuts


Become an Excel Master

Align Right Indent Remove Indent Increase Font Size One Step Decrease Font Size One Step

Number Formatting Shortcuts Actions Apply General Format Apply Currency Format Apply Percentage Format Apply Scientific Format Apply Date Format Apply Time Format Apply Number Format

ExcelDemy.com

Windows Shortcuts

Mac Shortcuts


Become an Excel Master

Border Shortcuts Actions

Windows Shortcuts

Mac Shortcuts

Add Border Outline Add or Remove Border Right Add or Remove Border Left Add or Remove Border Top Add or Remove Border Bottom Add or Remove Border Upward Diagonal Add or Remove Border Horizontal Interior Add or Remove Border Vertical Interior Remove Borders

Formula Shortcuts Actions Toggle Absolute and Relative References Open the Insert Function Dialog Box ExcelDemy.com

Windows Shortcuts

Mac Shortcuts


Become an Excel Master

AutoSum Selected Cells Toggle Formulas On and Off Insert Function Arguments Enter Array Formula Calculate Worksheets Calculate Active Worksheet Force Calculate All Worksheets Evaluate Part of a Formula Expand or Collapse the Formula Bar Display Function Arguments Dialog Box Define Name Define Name Using Row and Column Labels Paste Name into Formula Accept Function with AutoComplete

ExcelDemy.com


Become an Excel Master

Grid Operation Shortcuts Actions Display Insert Dialog Box Insert Rows Insert Columns Display Delete Dialog Box Delete Rows Delete Columns Delete Cells Delete Contents of Selected Cells Hide Columns Hide Rows Unhide Rows Unhide Columns

Group Rows or Columns Ungroup Rows or Columns Open Group Dialog Box

ExcelDemy.com

Windows Shortcuts

Mac Shortcuts


Become an Excel Master

Open Ungroup Dialog Box Hide or Show Outline Symbols

Pivot Table Shortcuts Actions

Windows Shortcuts

Mac Shortcuts

Select Entire Pivot Table Toggle Pivot Table Field Checkbox Group Pivot Table Items Ungroup Pivot Table Items

Hide Pivot Table Item Create Pivot Chart on Same Worksheet Create Pivot Chart on New Worksheet

Workbook Shortcuts Actions Insert New Worksheet Go to Next Worksheet Go to Previous Worksheet ExcelDemy.com

Windows Shortcuts

Mac Shortcuts


Become an Excel Master

Move to Next Pane

Move to Previous Pane Go to Next Workbook Go to Previous Workbook Display Control Menu Minimize Current Workbook Window Maximize Current Workbook Window

Dialog Box Shortcuts Actions Move to Next Control Move to Previous Control Move to Next Tab Move to Previous Tab

Accept and Apply Check and Uncheck Box

Cancel and Close the Dialog Box ExcelDemy.com

Windows Shortcuts

Mac Shortcuts


Become an Excel Master

Other Shortcuts Actions Open Spelling Dialog Box Open Thesaurus Box Open Macro Dialog Box Open VBA Editor

Hide or Show Objects Display Modify Cell Style Dialog Box

ExcelDemy.com

Windows Shortcuts

Mac Shortcuts


Become an Excel Master

Thank You for Reading Complete Excel! Keyboard Shortcuts EBook. For More Information visit http://www.exceldemy.com

Become an Excel Master

ExcelDemy.com


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.