Analysis

 

Grouping / Ungrouping

Shortcut

Description

ALT+SHIFT+ARROW RIGHT

Group Rows or Columns

ALT+SHIFT+ARROW LEFT

Ungroup Rows of Columns

 

Filter

Shortcut

Description

CTRL+SHIFT+L

Add / Remove the filter

CTRL+ALT+L

Reapply the filter and sort on the current range

 

Quick Analysis

Shortcut

Description

CTRL+Q

Displays the Quick Analysis options for your data when you have cells that contain that data selected

 

Tables

Shortcut

Description

CTRL+L or CTRL+T

Displays the Create Table dialog box

ALT+N T

Insert Table

 

Pivot Tables

Shortcut

Description

ALT+D+ P

Open Pivot Table Wizard

ALT+N+V

Insert the Pivot Table

 

Charts

Shortcut

Description

ALT+F1

Creates an embedded chart of the data in the current range

F11

Creates a chart of the data in the current range in a separate chart sheet

ALT+N+C

Insert Column Chart

ALT+N+B

Insert Bar Chart

ALT+N+O

Insert Stock, Surface and Radar Chart

ALT+N+N

Insert Line Chart

ALT+N+A 1 1

Insert Area Chart

ALT+N+S D

Insert Combo Chart

ALT+N+Q

Insert Pie Chart

ALT+N+D

Insert Scatter Chart

 

Macros

Shortcut

Description

CTRL+F11

Open VBBE

ALT+Y R

Record a macro

ALT+F8

Displays the Macro dialog box to create, run, edit or delete a macro

 

VBA Editor

Shortcut

Description

ALT+F11

Opens the Microsoft Visual Basic for Application Editor

CTRL+SHIFT+F2

Go to Last position

CTRL+SHIFT+F8

Step out

CTRL+SHIFT+F9

Clear all breakpoints

SHIFT+F9

Quick Watch

CTRL+E

Export Module

CTRL+J

List properties / methods

CTRL+L

Show call stack

CTRL+SHIFT+I

Edit parameter info

CTRL+SHIFT+J

Edit list constants

 

Calculations

Shortcut

Description

F9

(1) Calculates all worksheets in all open workbooks

(2) Evaluate a part of the formula

ALT+=

Autosums the numbers above the current cell

SHIFT+F9

Calculates the active worksheet

CTRL+ALT+F9

Calculates all worksheets in all open workbooks, regardless whether they have changed since the last calculation

CTRL+ALT+SHIFT+F9

Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017