EXCEL tutorial keyboard shortcuts


Télécharger EXCEL tutorial keyboard shortcuts

★★★★★★★★★★3.5 étoiles sur 5 basé sur 1 votes.
Votez ce document:

Télécharger aussi :



 

Hello and welcome to Excel Shortcuts and Hotkeys: The Power Spreadsheets Cheat Sheet.

In my experience, one of the best ways to improve your productivity in Excel is by learning the keyword shortcuts for the commands that you use frequently. My purpose with this (admittedly long) Cheat Sheet is to provide you with a resource that helps you identify these keyword shortcuts in a fast and easy manner.

This version of Excel Shortcuts and Hotkeys: The Power Spreadsheets Cheat Sheet contains more than 300 keyboard shortcuts (including several hotkeys). As a consequence of this, you will generally find 2 types of keyboard shortcuts within this Go-To List.

1.  Keyboard shortcuts whose different keys must be pressed all at the same time. This is the case, usually, for regular keyboard shortcuts, which normally start with the Ctrl key.

Some examples of these type of keyboard shortcuts are Ctrl + B (bold), Ctrl + I (Italics), Ctrl + X (Cut) and Ctrl + C (Copy).

2.  Keyboard shortcuts whose component keys must be pressed in sequential order. This means you must release each key before pressing the next one.

Keyboard shortcuts within this group are usually key tips or Ribbon shortcuts. Key tips are generally turned on and off by using the keys Alt or F10.

Some examples of these type of keyboard shortcuts are Alt + H + B + A (all borders), Alt H + M + C (Merge & Center) and Alt + W + F + F (Freeze Panes).

Excel Shortcuts and Hotkeys: The Power Spreadsheets Cheat Sheet is divided in the following 14 sections (organized alphabetically):

1. Charts and Graphs

8. Navigation and Selection

2. Data

9. PivotTables

3. Display

10. Print

4. Format

11. Sort and Filter

5. Formulas and Functions

12. Text

6. General

13. VBA and Macros

7. Grid

14. Workbooks and Worksheets

If you have any doubts or questions regarding Excel shortcuts, please feel free to leave a question at:

I read each and every single comment and will get back to you as soon as possible. You can also suggest additional Excel keyboard shortcuts there.

In order to ensure that you are informed whenever I update this Cheat Sheet, you may want to register for the Power Spreadsheets Newsletter at: .

     

Data

 

Shortcut #1

Shortcut #2

Shortcut #3

Basic Description

Additional Comments

(Ctrl + Alt + V) + B

   

Paste special, skipping blanks

When skipping blanks, existing values in the destination are not replac

(Ctrl + Alt + V) + C

   

Paste cell comments

 

(Ctrl + Alt + V) + D

   

Paste special, performing an addition

Adds the value in the clipboard to the value(s) in the destination cells

(Ctrl + Alt + V) + E

Alt + H + V + T

 

Transpose when pasting

 

(Ctrl + Alt + V) + H

Alt + H + V + K

 

Paste all, keeping source formatting

 

(Ctrl + Alt + V) + I

   

Paste special, performing a division

Divides the value(s) in the destination cells by the value in the clipboa

(Ctrl + Alt + V) + M

   

Paste special, performing a multiplication

Multiplies the value(s) in the destination cells by the value in the clipbo

(Ctrl + Alt + V) + N

   

Paste data validation

 

(Ctrl + Alt + V) + S

   

Paste special, performing a subtraction

Subtracts the value in the clipboard from the value(s) in the destination

(Ctrl + Alt + V) + U

Alt + H + V + A

 

Paste values and number formatting

 

(Ctrl + Alt + V) + V

Alt + H + V + V

 

Paste values

 

(Ctrl + Alt + V) + X

Alt + H + V + B

 

Paste all, except borders

 

Alt + A + M

   

Displays the Remove Duplicates dialog box

 

Alt + A + W + G

   

Display the Goal Seek dialog box

 

Alt + A + W + S

   

Display the Scenario Manager dialog box

 

Alt + A + W + T

   

Display the Data Table dialog box

 

r


Alt + Enter

   

Start new line within cell

 

Alt + H + C + P

   

Display the Copy as Picture dialog

 

Alt + H + E + A

   

Clear all

 

Alt + H + E + L

   

Clear hyperlinks

 

Alt + H + E + M

   

Clear comments

 

Alt + H + E + R

   

Remove hyperlinks

 

Alt + H + FI + A

   

Display the Fill Across Worksheets dialog box

 

Alt + H + FI + J

   

Fill justify

 

Alt + H + FI + L

   

Fill left as follows: (1) Copy right-most cell of a selected range into cells to the left; or (2) Copy from right cell into active cell

 

Alt + H + FI + S

   

Display the Series dialog box

 

Alt + H + FI + U

   

Fill up as follows: (1) Copy lower cell of a selected range into cells above; or (2) Copy from cell below into active cell

 

Alt + H + FO

   

Display the Clipboard task pane

 

Alt + H + V + E

   

Paste values, keeping source formatting

 

Alt + H + V + I

   

Paste linked picture

 

Alt + H + V + U

   

Paste picture

 

Alt + R + A

   

Show all comments

 

Alt + R + D

   

Delete comment

 

Backspace

   

(1) Within Formula Bar or cell (in cell-editing mode), deletes 1 character to the left or deletes the selection (if any); or (2) When not in cell-editing mode, clears the contents of selected/active cell(s)

 

Ctrl + '

Ctrl + Shift + '

 

Copy formula/text from cell above into active cell or Formula Bar

 

Ctrl + "

   

Copy values/text from cell above into active cell or Formula Bar

 

Ctrl + ;

   

Enter current date

 

Ctrl + Alt + V

Alt + H + V + S

 

Display the Paste Special dialog box

There must be data in the Clipboard for command to be available

Ctrl + C

Ctrl + Insert

Alt + H + C + C

Copy

 

Ctrl + D

Alt + H + FI + D

 

Fill down as follows: (1) Copy top cell of a selected range into cells below; or (2) Copy from cell above into active cell

 

Ctrl + Delete

   

Delete to the end of current line

 

Ctrl + E

Alt + H + FI + F

 

Flash Fill

 

Ctrl + Enter

   

(1) Enter current entry in selected range and stay in same active cell; or (2) Complete cell entry and stay in same active cell

 

Ctrl + K

   

(1) Within a cell without hyperlinks, display the Insert Hyperlink dialog box; or (2) Within a cell with a hyperlink, display the Edit Hyperlink dialog box

 

Data

   

Data

  Shortcut #1                  Shortcut #2

Shortcut #3

   Basic Description                                                                                                   Additional Comments

Ctrl + Q

   

Expand the Quick Analysis tool

 

Ctrl + R

Alt + H + FI + R

 

Fill right as follows: (1) Copy left-most cell of a selected range into cells to the right; or (2) Copy from left cell into active cell

 

Ctrl + Shift + :

   

Enter current time

 

Ctrl + Shift + :

   

Enter current time

 

Ctrl + V

Alt + H + V + P

 

Paste

Pastes at the insertion point and replaces any selection. There must be data in the Clipboard for command to be available

Ctrl + X

Alt + H + X

 

Cut

 

Delete

Alt + H + E + C

 

Clear contents of the selected/active cell(s)

 

Delete

   

Within Formula Bar or cell (in cell-editing mode), deletes 1 character to the right or deletes the selection (if any)

 

Enter

   

(1) Within cell or Formula Bar, complete cell entry and (by default) go to cell below; or (2) Within an AutoFilter list, filter the list using the selected item

Enter is also under the Navigation and Selection category

Esc

   

Within cell of Formula Bar, cancel entry

Esc is also under the Navigation and Selection category

F2

   

Edit active cell

Positions the insertion point at the end of cell contents. When Allow editing directly in cells is turned off, moves the insertion point to the Formula Bar

F7

   

Display the Spelling dialog box

 

Right Mouse Button

+ E

   

When a row or column is selected, insert copied or cut cells

 

Shift + Enter

   

Within cell of Formula Bar, complete cell entry and (by default) go to the cell above

 

Shift + F10 + m

   

Insert or delete cell comment

 

Shift + F2

   

Insert or edit a cell comment

 

Shift + F7

   

Display the Thesaurus dialog box or task pane

 

Shift + Tab

   

(1) Complete cell entry and move one cell to the left in a worksheet or to previous unlocked cell in a protected sheet; (2) Select suggestion from autocomplete to complete entry and move one cell to the left or to previous unlocked cell

Shift + Tab is also under the Navigation and Selection and Formulas

and Functions categories

Tab

   

(1) Complete cell entry and move one cell to the right in a worksheet or to next unlocked cell in a protected sheet; (2) Select suggestion from autocomplete to complete entry and move one cell to the right or to next unlocked cell

Tab is also under the Navigation and Selection and Formulas and

Functions categories


 

Ctrl + `

   

Toggle between (1) displaying cell values and (2) displaying formulas in worksheet

 

Ctrl + 6

   

Alternate between hiding and showing object(s)

 

Ctrl + F1

   

Expand or collapse the Ribbon

 

Ctrl + F10

   

Maximize/restore current selected workbook window

 

Ctrl + Scroll Mouse

Wheel

   

Zoom in/out

 

Ctrl + Shift + U

   

Toggle between expanding and collapsing the Formula Bar

 

Display


Alt + H + B + C

   

Top and thick bottom border

 

Alt + H + B + D

   

Top and bottom border

 

Alt + H + B + E

   

Erase border

 

Alt + H + B + G

   

Draw border grid

 

Alt + H + B + H

   

Thick bottom border

 

Alt + H + B + I

   

Choose border line color

 

Alt + H + B + L

   

Left Border

 

Alt + H + B + M

   

Display the Format Cells dialog box with the Border tab selected

 

Alt + H + B + N

Ctrl + Shift + -

 

No Border

 

Alt + H + B + O

   

Bottom Border

 

Alt + H + B + P

   

Top Border

 

Alt + H + B + R

   

Right Border

 

Alt + H + B + S

Ctrl + Shift + 7

 

Outside border

 

Alt + H + B + T

   

Thick box border

 

Alt + H + B + U

   

Top and double bottom border

 

Alt + H + B + W

   

Draw border

 

Alt + H + B + Y



   

Choose border line style

 

Alt + H + E + F

   

Clear formatting

 

Alt + H + FC

   

Choose font color

 

Alt + H + FC

   

Expand Font Color drop-down menu

 

Alt + H + FF

   

Change the font face

 

Alt + H + FG

   

Increase font size one point

 

Alt + H + FG

   

Increase the font size by 1 point

 

Alt + H + FK

   

Decrease font size one point

 

Alt + H + FK

   

Decrease the font size by 1 point

 

Alt + H + FM

   

Display the Format Cells dialog box with the Number tab selected

 

Alt + H + FN

   

Display the Format Cells dialog box with the Font tab selected

 

Alt + H + FP

   

Activate the Format Painter

 

Alt + H + FQ + D

   

Rotate text down

 

Alt + H + FQ + L

   

Rotate text in an angle clockwise

 

Alt + H + FQ + M

Alt + H + FA

 

Display the Format Cells dialog box with the Alignment tab selected

 

Alt + H + FQ + O

   

Rotate text in an angle counterclockwise

 

Alt + H + FQ + U

   

Rotate text up

 

Alt + H + FQ + V

   

Rotate text so that it is vertical

 

Alt + H + FS

   

Change the font size

 

Alt + H + H

   

Expand Fill Color drop-down menu

 

Alt + H + H + N

   

Apply no fill color to current cell selection

 

Alt + H + J

   

Expand the Cell Styles menu

 

Alt + H + J + M

   

Display the Merge Styles dialog box to merge (copy) cell styles from another workbook

 

Alt + H + J + N

   

Display the Style dialog box to create a new cell style

 

 

Alt + H + K

   

Format number with a thousands comma (,) separator

 

Alt + H + L + C + E

   

Clear conditional formatting rules from entire worksheet

 

Alt + H + L + C + P

   

Clear conditional formatting rules from selected PivotTable

This option is only active when the active cell is within a PivotTable

Alt + H + L + C + S

   

Clear conditional formatting rules from selected cells

 

Alt + H + L + C + T

   

Clear conditional formatting rules from selected table

This option is only active when the active cell is within a table

Alt + H + L + D

   

Expand the menu to set a conditional formatting rule using data bars with gradient or solid fill

 

Alt + H + L + D + M

Alt + H + L + S + M

Alt + H + L + I + M

Display the New Conditional Formatting Rule dialog box, with the

Format all cells based on their values rule type selected

 

Alt + H + L + H + A

   

Display the A Data Occurring dialog box to conditionally format cells whose date occurs within the time period set in the rule

 

Alt + H + L + H + B

   

Display the Between dialog box to conditionally format cells whose value is between the values set in the rule

 

Alt + H + L + H + D

   

Display the Duplicate Values dialog box to conditionally format cells with duplicate or unique values in the selected cell range

 

Alt + H + L + H + E

   

Display the Equal To dialog box to conditionally format cells whose value is equal to the value set in the rule

 

Alt + H + L + H + G

   

Display the Greater Than dialog box to conditionally format cells whose value is greater than the value set in the rule

 

Alt + H + L + H + L

   

Display the Less Than dialog box to conditionally format cells whose value is less than the value set in the rule

 

Alt + H + L + H + M

   

Display the New Conditional Formatting Rule dialog box, with the

Format only cells that contain rule type selected

 

Alt + H + L + H + T

   

Display the Text That Contains dialog box to conditionally format cells whose text contains the text set in the rule

 

Alt + H + L + I

   

Expand the menu to set a conditional formatting rule using icon sets

 

Alt + H + L + N

   

Display the New Conditional Formatting Rule dialog box

 

Alt + H + L + R

   

Display the Conditional Formatting Rules Manager

 

Alt + H + L + S

   

Expand the menu to set a conditional formatting rule using color scales

 

Alt + H + L + T + A

   

Display the Above Average dialog box to conditionally format cells that are above the average in the selected cell range

 

Alt + H + L + T + B

   

Display the Bottom 10 Items dialog box to conditionally format cells that rank within the bottom values in the selected cell range

 

Alt + H + L + T + M

   

Display the New Conditional Formatting Rule dialog box, with the

Format only top or bottom ranked values rule type selected

 

 

Alt + H + L + T + O

   

Display the Bottom 10% dialog box to conditionally format cells that rank within a certain bottom percentile in the selected cell range

 

Alt + H + L + T + P

   

Display the Top 10% dialog box to conditionally format cells that rank within a certain top percentile in the selected cell range

 

Alt + H + L + T + T

   

Display the Top 10 Items dialog box to conditionally format cells that rank within the top values in the selected cell range

 

Alt + H + L + T + V

   

Display the Below Average dialog box to conditionally format cells that are below the average in the selected cell range

 

Alt + H + M + A

   

Merge across cells

The selected cells in the same row are merged

Alt + H + M + M

   

Merge cells

 

Alt + H + M + U

   

Unmerge cells

 

Alt + H + N

   

Choose number format

 

Alt + H + O + A

   

Auto-fit row height

 

Alt + H + O + H

   

Display the Row Height dialog box

 

Alt + H + O + I

   

Auto-fit column width

 

Alt + H + O + W

   

Display the Column Width dialog box

 

Alt + H + T

   

Expand Format as Table drop-down menu

 

Alt + H + T

   

Expand the Format as Table menu

 

Alt + H + T + N

   

Display the New Table Style dialog box

 

Alt + H + T + P

   

Display the New PivotTable Style dialog box

 

Alt + H + W

   

Wrap text

 

Alt + L

   

Within Border tab of Format Cells dialog box, add/remove left border

 

Alt + R

   

Within Border tab of Format Cells dialog box, add/remove right border

 

Alt + T

   

Within Border tab of Format Cells dialog box, add/remove top border

 

Alt + V

   

Within Border tab of Format Cells dialog box and when more than 1 column is selected, add/remove vertical interior border

 

Ctrl + 1

Alt + H + O + E

 

Display Format Cells dialog box

 

Ctrl + 5

   

Apply or remove strikethrough formatting

 

Ctrl + B

Ctrl + 2

Alt + H + 1

Apply or remove bold formatting

 

Ctrl + I

Ctrl + 3

Alt + H + 2

Apply or remove italic formatting

 

Ctrl + Shift + !

   

Apply number format

Default settings are: (1) 2 decimal places, (2) 1000 separator, and (3) minus (-) sign for negative values

Ctrl + Shift + #

   

Apply date format

Default setting is date, month and year

Ctrl + Shift + $

   

Apply currency format

Default settings are: (1) 2 decimal places, (2) 1000 separator, and (3) negative values within parentheses ( )

Ctrl + Shift + %

Alt + H + P

 

Apply percentage format

Default setting is without decimal places

Ctrl + Shift + &

   

Add outside borders to selected cell(s)

 

Ctrl + Shift + @

   

Apply time format

Default settings are: (1) hour and minute, and (2) AM or PM

 

     

Format

 

Shortcut #1

Shortcut #2

Shortcut #3

Basic Description

Additional Comments

Ctrl + Shift + ^

   

Apply scientific format

Default setting is with 2 decimal places

Ctrl + Shift + _

   

Remove outside borders

 

Ctrl + Shift + ~

   

Apply general format

 

Ctrl + Shift + F

Ctrl + Shift + P

 

Display the Format Cells dialog box with the Font tab selected

 

Ctrl + T

Ctrl + L

 

Display the Create Table dialog box

 

Ctrl + U

Ctrl + 4

Alt + H + 3 + U

Apply or remove underlining

 

F4

   

Repeat last command or action, when possible

 

 
     

Formulas and Functions

Shortcut #1

Shortcut #2

Shortcut #3

   Basic Description                                                                                                   Additional Comments

F4

   

Toggles between available combinations of absolute and relative references

 

F9

   

Calculate all worksheets in all open workbooks

 

Shift + F3

Alt + H + U + F

 

Display the Insert Function dialog box

 

Shift + F9

   

Calculate the current active worksheet

 

Shift + Tab

   

(1) Complete formula and move one cell to the left in a worksheet or to previous unlocked cell in a protected sheet; (2) Select suggestion from autocomplete to complete formula and move one cell to the left or to previous unlocked cell

Shift + Tab is also under the Navigation and Selection and Data

categories

Tab

   

(1) Complete formula and move one cell to the right in a worksheet or to next unlocked cell in a protected sheet; (2) Select suggestion from autocomplete to complete formula and move one cell to the right or to next unlocked cell

Tab is also under the Navigation and Selection and Data categories


 
   

Grid

Shortcut #1

  Shortcut #2                  Shortcut #3

   Basic Description                                                                                                   Additional Comments

Alt + H + O + D

   

Display the Standard Width dialog box to change the default column width



 

Alt + H + O + L

   

Lock active cell(s)

 

Ctrl + 0

Alt + H + O + U + C

 

Hide active column(s)

 

Ctrl + 8

   

Alternate between hiding and displaying outline symbols

Applies if there are rows/columns grouped

Ctrl + 9

Alt + H + O + U + R

 

Hide active row(s)

 

Ctrl + Shift + +

Alt + H + I + E

 

(1) Insert rows/columns above/to the left of the selected row/column; or (2) Display the Insert dialog box to insert cells/rows/columns

 

Alt + H + I + A

   

Insert table rows above of the active cell

Command is only available when active cell is within a table

Alt + H + I + L

   

Insert table columns to the left of the active cell

Command is only available when active cell is within a table

Alt + H + I + R

   

Insert worksheet rows above of the active cell

 

Alt + H + I + C

   

Insert worksheet columns to the left of the active cell

 

Ctrl + Shift + 0

Alt + H + O + U + L

 

Unhide any hidden columns within selection

May not work in certain (particularly newer versions) of Excel by default. In those cases, you can usually enable the shortcut by modifying the language bar hotkey settings and changing the setting (e.g. selecting "Not Assigned") for the key sequence to switch input keyboard layout

Ctrl + Shift + 9

Alt + H + O + U + O

 

Unhide any hidden rows within selection

 

 

Navigation and Selection

  Shortcut #1                  Shortcut #2                   Shortcut #3                   Basic Description                                                                                                   Additional Comments

Arrow Keys

   

(1) Within a worksheet, go to cell to the right, left, up or down of current active cell; (2) Within the Ribbon, move to the option to the next (right) or previous (left) option or tab; (3) Within a menu or submenu, switch between the main menu and the sub-menu; (4) Within a drop-down list, move between items; (5) Within a group of options, move between options; or (6) When Extend Selection mode is on, extend selection

 

Ctrl + Shift + *

F5 + (Alt + S) + R

 

When in a cell, select data area around active cell

 

Ctrl + .

   

When in a cell selection, move active cell clockwise to next corner

(top-right > bottom-right > bottom-left > top-left)

 

Ctrl + [

F5 + (Alt + S) + P

 

Go to direct precedents within active worksheet

 

Ctrl + ]

F5 + (Alt + S) + D

 

Go to direct dependents within active worksheet

 

Ctrl + A

Ctrl + Shift +

Spacebar

 

(1) When in a cell, select data area around active cell (press shortcut a second or third time to select entire worksheet) or select entire worksheet; or (2) When an object is selected, select all such objects in worksheet

Ctrl + A is also under the Formulas and Functions category

Ctrl + Arrow Keys

   

(1) Go to edge of current data area; or (2) Within a cell, skip a word to the left or to the right

Within a cell, only right and left arrows can be used

Ctrl + Backspace

   

Go to active cell in worksheet

 

Ctrl + End

F5 + (Alt + S) + S

 

Go to last cell (cell in lowest used row and right-most used column) of worksheet

 

Ctrl + End

   

Within a cell, go to end of cell contents

 

Ctrl + F

Shift + F5

Alt + H + FD + F

Display the Find and Replace dialog with the Find tab selected

 

Ctrl + F6

   

Alternate between current active workbook window and next workbook window

 

Ctrl + G

F5

Alt + H + FD + G

Display the Go To dialog box

 

Ctrl + H

Alt + H + FD + R

 

Display the Find and Replace dialog with the Replace tab selected

 

Ctrl + Home

   

(1) Go to first cell of worksheet; or (2) Within a cell, go to beginning of cell contents

 

Ctrl + Left-Mouse-

Button Click

   

Add non-adjacent (1) Cells to current cell selection; or (2) Sheets to current sheet selection

 

Ctrl + Page Down /

Ctrl + Page Up

   

Go to next sheet to the right / Go to prior sheet to the left

 

Ctrl + Shift + {

F5 + (Alt + S) + D +

L

 

Go to all precedents (direct and indirect)  within active worksheet

 

Ctrl + Shift + }

F5 + (Alt + S) + P +

L

 

Go to all dependents (direct and indirect) within active worksheet

 

Ctrl + Shift + Arrow

Keys

   

(1) Extend selection to edge of current data area; or (2) Within a cell, select (or add to selection) the word to the left or to the right of the current selection/insertion point

Within a cell, only right and left arrows can be used


 

Navigation and Selection

Shortcut #1                    Shortcut #2                   Shortcut #3                   Basic Description                                                                                                   Additional Comments

Ctrl + Shift + End

   

(1) Extend selection to last cell (cell in lowest used row and rightmost used column) of worksheet; or (2) Within a cell or the Formula Bar, select (or add to selection) all the words from the current selection/insertion point to the end of contents of cell or Formula Bar

 

Ctrl + Shift + F4

   

Find previous match

 

Ctrl + Shift + Home

   

(1) Extend selection to first cell of worksheet; or (2) Within a cell or the Formula Bar, select (or add to selection) all the words from the current selection/insertion point to the beginning of contents of cell or Formula Bar

 

Ctrl + Shift + O

F5 + (Alt + S) + C

Alt + H + FD + M

Go to cells with comments

 

Ctrl + Shift + Page

Down / Ctrl + Shift

+ Page Up

   

Select current active and next sheet to the right / Select current active and prior sheet to the left

 

Ctrl + Shift + Tab

   

(1) Go to previous workbook; or (2) Within a dialog box, go to previous tab

 

Ctrl + Space

   

Select active column

Within a table: (1) First time shortcut is pressed selects active column within table; (2) Second time shortcut is pressed selects active column header (if any); and (3) Third time shortcut is pressed selects active column of worksheet

Ctrl + Tab

   

(1) Go to next workbook; or (2) Within a dialog box, go to next tab

 

End

   

(1) Turn End mode on; (2) Within a cell, go to end of current line; (3) When Scroll Lock is turned on, go to cell in lower-right corner of the window; or (4) When a menu or sub-menu is visible, select last command of the menu or sub-menu

When End mode is on: (1) Use arrow keys to go to edge of current data area; (2) Use Home to go to last cell (cell in lowest used row and right-most used column) of worksheet; (3) Use Enter to go to last non-blank cell to the right. End mode turns off automatically after pressing arrow/Home/Enter key

Enter

   

(1) Within Ribbon, display selected tab or execute selected command; (2) Within a dialog box, perform action for default command button in dialog box; (3) Within cell selection, move active cell to next cell (usually right or down); or (4) Within Data Form, go to first field in next record

Enter is also under the Data category

Enter

   

Within cell selection, move active cell to previous cell (usually left or up)

 

Esc

   

(1) Within menu, submenu, dialog box or message window, cancel the command and close the menu, submenu, dialog box or message window; (2) When object is selected, cancel selection

Esc is also under the Data category

F1

   

Display the Help Task pane

When a command or control is selected, the Help Task pane displays the Help topic associated with the command or control. If no Help topic is associated, the Home of the Help Task pane is displayed

 


 
   

Navigation and Selection

  Shortcut #1                  Shortcut #2

Shortcut #3

   Basic Description                                                                                                   Additional Comments

Shift + F8

   

Add non-adjacent range to current selection

Use arrow keys to move to beginning of new selection. Use Shift +

Arrow keys to select new selection

Shift + Home

   

(1) Select to the beginning of the current row or (2) Within a cell, select to the beginning of the current row

 

Shift + Page Down

/ Shift + Page Up

   

Extend selection 1 screen down / 1 screen up

 

Shift + Space

   

Select active row

Within a table: (1) First time shortcut is pressed selects active row within table; (2) Second time shortcut is pressed selects active row of worksheet

Shift + Tab

   

(1) Move one cell to the left in a worksheet or to previous unlocked cell in a protected worksheet; (2) Within a selection, move active cell to the left; (3) Within a dialog box or the Ribbon, move to previous option or option group

Shift + Tab is also under the Data and Formulas and Functions

categories

Spacebar

   

(1) Within a dialog box, perform the action that corresponds to the selected button, or select or clear a checkbox; (2) Within the Ribbon, activate the selected command or control or open the selected menu or gallery

 

Tab

   

(1) Move one cell to the right in a worksheet or to next unlocked cell in a protected worksheet; (2) Within a selection, move active cell to the right; (3) Within a dialog box or the Ribbon, move to next option or option group

Tab is also under the Data and Formulas and Functions categories

     

Sort and Filter

 

Shortcut #1

Shortcut #2

Shortcut #3

Basic Description

Additional Comments

Alt + A + Q

   

Advanced Filter

 

Alt + A + SA

Alt + H + S + S

 

Sort smallest to largest

 

Alt + A + SD

Alt + H + S + O

 

Sort largest to smallest

 

Alt + A + SS

Alt + H + S + U

 

Displays the Sort dialog box

 

Alt + A + V + V

   

Display the Data Validation dialog box

 

Alt + H + S + C

   

Clear filter

 

Ctrl + Alt + L

Alt + H + S + Y

 

Reapply filter and sort on current range

 
     

PivotTables

 

Shortcut #1

Shortcut #2

Shortcut #3

Basic Description

Additional Comments

Alt + N + V

   

PivotTable

 

 
   

Sort and Filter

 

  Shortcut #1                  Shortcut #2

Shortcut #3

Basic Description

Additional Comments

Ctrl + Shift + L

Alt + H + S + F

 

Turn filter on or off

 

Right Mouse Button

+ E + V

   

Filter by the selected cell's value

 

   

Thank you very much!

I hope you find Excel Shortcuts and Hotkeys: The Power Spreadsheets Cheat Sheet useful. I enjoyed preparing this for you, and learned a lot during the process.

Thank you also for your support of Power Spreadsheets and my work there. I appreciate you for taking the time to go through this Cheat Sheet.

If you have an extra minute, I would love to hear what you think. Please leave a comment at:

I read each and every single comment and take them into consideration when updating and further developing this Cheat Sheet and the Power Spreadsheets blog in general.

If you haven't done so, please make sure to subscribe to the Power Spreadsheets Newsletter at: .

Excel Shortcuts and Hotkeys: The Power Spreadsheets Cheat Sheet

By Jorge A. Gomez from Power Spreadsheets

Copyright © 2015-2016 Jorge Alberto Gomez Soto. All rights reserved

I update this Cheat Sheet every once in a while. Being part of the Power Spreadsheets Newsletter allows me to let you know when a new version of the Cheat Sheet is released.

Lastly, remember that you can find Power Spreadsheets on Social Media as follows:

-  Twitter:

-  Facebook:

-  LinkedIn:

-  Google +:

Thanks again for your time. Happy Excel learning!

Jorge A. Gomez



4