101 Excel Shortcuts to Make You More Productive

So, what would you like to
learn to do faster?

101 Useful Excel Shortcuts to
Make You More Productive

Being productive is all about being fast – and effective. Using Microsoft Excel is no different. You want to plug in your numbers, get answers and analyze – and the faster the better. Shortcuts are one of the easiest ways to boost your Excel productivity. They’re easy to learn, quick to implement and there are hundreds to choose from. We’ve made the best guide to easily choose the best Excel shortcuts for all types of tasks. All you have to decide is which ones to use.

top

Key commands on a
Mac

mac excel shortcuts
  • Format Data

    Choose Alignment

    Applies align center (left, right)

    + + (L,R)

  • Add Borders

    All Borders (outline, bottom, top, left, right, none)

    + + (0, ↓, ↑, ←, →, -)

  • Displays or hides the outline symbols

    +

  • Removes the outline border from the selected cells

    + +

  • Apply Filters

    Applies a data filter

    + +

  • Style Data

    Applies or removes bold formatting

    +

  • Applies or removes bold formatting

    +

  • Applies or removes underlining

    +

  • Format Values

    Applies the Date format with the day, month, and year

    + +

  • Applies the General number format

    + +

  • Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values

    + +

  • Applies the outline border to the selected cells

    + +

  • Applies the Percentage format with no decimal places

    + +

  • Applies the Scientific number format with two decimal places

    + +

  • Applies the Time format with the hour and minute, and AM or PM

    + +

  • Shows the Format Cells dialog box.

    +

  • Applies the Currency format with two decimal places

    + +

  • Insert and Edit Data

    Charts

    Displays the Create Table dialog box

    +

  • Create chart in a new worksheet

    +

  • Insert a column chart

    + +

  • Comments

    Adds or edits a cell comment.

    + +

  • Delete Data

    Cancels an entry in the cell or Formula Bar

  • Deletes the selected cells

    +

  • Individual Cell Entries

    Completes a cell entry and selects the cell above

    +

  • Edits the active cell and positions the insertion point at the end of the cell contents

    +

  • Starts a new line in the same cells

    + +

  • Insert Data

    Displays the Insert dialog box to insert blank cells

    +

  • Enters the current date (time)

    +
    ( + + )

  • Inserts a new worksheet

    +

  • Links

    Creates a link to a Web page, a picture, an e-mail address, or a program

    +

  • Repeat/Undo Actions

    Redoes the last command or action, if possible (after it was undone)

    +

  • Uses the Undo command to reverse the last command or to delete the last entry that you typed

    +

  • Navigate

    Close/Open Windows

    Closes Excel

    +

  • Closes the selected workbook window

    +

  • Minimizes a workbook window to an icon

    +

  • Find Data

    Displays the Find and Replace dialog box, with the Find (Replace) tab selected

    + ( + )

  • Displays the Go To dialog box.

    +

  • Move Between Worksheets

    Moves to the next sheet in a workbook.

    + + ↓

  • Moves to the previous sheet in a workbook

    + + ↑

  • Move Within Worksheets

    Moves one cell to the right in a worksheet

  • Moves one screen down (up) in a worksheet

    + ↓ + ↑

  • Moves one screen down (up) in a worksheet

    + + ↑ (↓)

  • Moves to the beginning of a row in a worksheet

    + ←

  • Moves to the beginning of a worksheet

    + + ←

  • Moves to the bottom (top, left, right) of the current data region in a worksheet

    + ↓ (↑, ←, →)

  • Moves to the last cell on a worksheet, to the lowest used row of the rightmost used column

    + + →

  • Moves to the previous cell in a worksheet or the previous option in a dialog box

    +

  • Work With Data Selections

    Copy/Paste Data

    Copies the selected cells.

    +

  • Copies the value from the cell above the active cell into the cell or the Formula Bar

    +

  • Cuts the selected cells

    +

  • Displays the Paste Special dialog box

    + +

  • Paste - Inserts the contents of the Clipboard at the insertion point and replaces any selection

    +

  • Pastes a picture

    + +

  • Pastes as Values

    + +

  • Pastes formatting

    + +

  • Pastes formulas & numbers

    + +

  • Pastes formulas

    + +

  • Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right

    +

  • Hide/Unhide Data

    Alternates between hiding and displaying objects

    +

  • Hides the selected columns (rows)

    + ()

  • Unhides any hidden columns (rows) within the selection.

    + + ()

  • Select Data

    Enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.

    + +

  • Extends the selection of cells to the beginning of the worksheet

    + + + ←

  • Extends the selection of cells to the last nonblank cell in the same column or row as the active cell

    + + → (←, ↓, ↑)

  • Extends the selection of cells to the last used cell on the worksheet (lower-right corner)

    + + + →

  • Extends the selection of the cells by one cell right, left, up, down

    + → (←, ↓, ↑)

  • Select all cells directly or indirectly referenced by formulas in the selection

    + +

  • Select all cells directly referenced by formulas in the selection

    +

  • Select cells that contain formulas that directly or indirectly reference the active cell

    + +

  • Select cells that contain formulas that directly reference the active cell

    +

  • Selects an entire column in a worksheet

    +

  • Selects an entire row in a worksheet

    +

  • Selects the array containing the active cell

    +

  • Selects the entire worksheet. If the worksheet contains data, Ctrl+A selects the current region

    +

  • Work With Formulas

    Calculate Data

    Calculates all worksheets in all open workbooks

    +

  • Calculates the active worksheet

    + +

  • Check Formulas

    Alternates between displaying cell values and displaying formulas in the worksheet

    +

  • Toggle absolute and relative references

    +

  • Fill Formulas

    Fills the selected cell range with the current entry

    +

  • Insert Functions

    Displays the Insert Function dialog box

    + +

  • Insert an AutoSum function.

    + +

  • Inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula

    + +

  • Access Other Excel Features

    Creates a new, blank workbook

    +

  • Displays the Excel Help task pane

    +

  • Displays the Open dialog box to open or find a file

    +

  • Displays the Print dialog box

    +

  • Displays the Save As dialog box

    + +

  • Saves the active file with its current file name, location, and file format

    +

top

Key commands on a
Windows

windows excel shortcuts
  • Format Data

    Choose Alignment

    Applies align center (left, right)

    Alt

    +

    H,B,S,A

  • Add Borders

    All Borders (outline, bottom, top, left, right, none)

    Alt

    +

    H,B,S,A

  • Displays or hides the outline symbols

    Ctrl

    +

    8

  • Removes the outline border from the selected cells

    Ctrl + Shift

    +

    -

  • Apply Filters

    Applies a data filter

    Ctrl + Shift

    +

    L

  • Style Data

    Applies or removes bold formatting

    Ctrl

    +

    B

  • Applies or removes italic formatting

    Ctrl

    +

    i

  • Applies or removes underlining

    Ctrl

    +

    U

  • Format Values

    Applies the Date format with the day, month, and year

    Ctrl + Shift

    +

    #

  • Applies the General number format

    Ctrl + Shift

    +

    ~

  • Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values

    Ctrl + Shift

    +

    !

  • Applies the outline border to the selected cells

    Ctrl + Shift

    +

    &

  • Applies the Percentage format with no decimal places

    Ctrl + Shift

    +

    %

  • Applies the Scientific number format with two decimal places

    Ctrl + Shift

    +

    ~

  • Applies the Time format with the hour and minute, and AM or PM

    Ctrl + Shift

    +

    @

  • Shows fewer (more) decimal places

    Alt

    +

    H,9,(0)

  • Shows the Font tab of the Format Cells dialog box

    Ctrl + Shift

    +

    F

  • Shows the Format Cells dialog box

    Ctrl

    +

    1

  • Applies the Currency format with two decimal places

    Ctrl + Shift

    +

    $

  • Insert and Edit Data

    Charts

    Displays the Create Table dialog box

    Ctrl

    +

    T

  • Create chart in a new worksheets

    F11

  • Insert a column chart

    Atl

    +

    F1

  • Comments

    Adds or edits a cell comment.

    Shift

    +

    F2

  • Delete Data

    Cancels an entry in the cell or Formula Bar

    esc

  • Deletes the selected cells

    Ctrl

    +

    -

  • Individual Cell Entries

    Completes a cell entry and selects the cell above

    Shift

    +

    Enter

  • Edits the active cell and positions the insertion point at the end of the cell contents

    F2

  • Starts a new line in the same cells

    Alt

    +

    Enter

  • Insert Data

    Displays the Insert dialog box to insert blank cells

    Ctrl + Shift

    +

    =

  • Enters the current date (time)

    Ctrl + ;

  • Inserts a new worksheet

    Shift

    +

    F11

  • Links

    Creates a link to a Web page, a picture, an e-mail address, or a program

    Ctrl

    +

    K

  • Repeat/Undo Actions

    Redoes the last command or action, if possible (after it was undone)

    Ctrl

    +

    Y

  • Uses the Undo command to reverse the last command or to delete the last entry that you typed

    Ctrl

    +

    Z

  • Navigate

    Close/Open Windows

    Closes Excel

    Alt

    +

    F4

  • Closes the selected workbook window

    Ctrl

    +

    W

  • Maximizes or restores the selected workbook window

    Ctrl

    +

    F10

  • Minimizes a workbook window to an icon

    Ctrl

    +

    F9

  • Find Data

    Displays the Find and Replace dialog box, with the Find (Replace) tab selected

    Ctrl

    +

    F (H)

  • Displays the Go To dialog box

    Ctrl

    +

    G

  • Move Between Worksheets

    Moves to the next sheet in a workbook

    Ctrl

    +

    PgDn

  • Moves to the previous sheet in a workbook

    Ctrl

    +

    PgUp

  • Move Within Worksheets

    Moves one cell to the right in a worksheet

    Tab

  • Moves one screen down (up) in a worksheet

    PgUp

     

    PgDn

  • Moves one screen to the left in a worksheet

    Alt

    +

    PgUp

  • Moves to the beginning of a row in a worksheet

    Home

  • Moves to the beginning of a worksheet

    Ctrl

    +

    Home

  • Moves to the bottom (top, left, right) of the current data region in a worksheet

    Ctrl

    +

    ↓, ↑, ←, →

  • Moves to the last cell on a worksheet, to the lowest used row of the rightmost used column

    Ctrl

    +

    End

  • Moves to the previous cell in a worksheet or the previous option in a dialog box.

    Shift

    +

    Tab

  • Work With Data Selections

    Copy/Paste Data

    Copies the selected cells.

    Ctrl

    +

    C

  • Copies the value from the cell above the active cell into the cell or the Formula Bar

    Ctrl

    +

    D

  • Cuts the selected cells

    Ctrl

    +

    X

  • Displays the Paste Special dialog box

    Ctrl + Alt

    +

    V

  • Paste - Inserts the contents of the Clipboard at the insertion point and replaces any selection

    Ctrl

    +

    V

  • Pastes a picture

    Alt

    +

    H, V, U

  • Pastes as Values

    Alt

    +

    H, V, V

  • Pastes formatting

    Alt

    +

    H, V, R

  • Pastes formulas & numbers

    Alt

    +

    H, V, O

  • Pastes formulas

    Alt

    +

    H, V, F

  • Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right

    Ctrl

    +

    R

  • Group Data

    Group - Ties a range of cells together so that they can be collapsed or expanded

    Alt

    +

    A,G,G

  • Hide/Unhide Data

    Alternates between hiding and displaying objects

    Ctrl

    +

    6

  • Hides the selected columns (rows)

    Ctrl

    +

    0 (9)

  • Unhides any hidden columns (rows) within the selection

    Ctrl + Shift

    +

    0 (9)

  • Select Data

    Enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys

    Shift

    +

    F8

  • Extends the selection of cells to the beginning of the worksheet

    Ctrl + Shift

    +

    Home

  • Extends the selection of cells to the last nonblank cell in the same column or row as the active cell

    Ctrl + Shift

    +

    →, ←, ↑, ↓

  • Extends the selection of cells to the last used cell on the worksheet (lower-right corner)

    Ctrl + Shift

    +

    End

  • Extends the selection of the cells by one cell right, left, up, down

    Shift

    +

    →, ←, ↓, ↑

  • In a selected row (column), select the cells that don't match the formula or static value in the active cell

    Ctrl

    +

    Shift

  • Select all cells directly or indirectly referenced by formulas in the selection

    Ctrl + Shift

    +

    [

  • Select cells that contain formulas that directly or indirectly reference the active cell

    Ctrl + Shift

    +

    ]

  • Select cells that contain formulas that directly reference the active cell

    Ctrl

    +

    ]

  • Selects an entire column in a worksheet

    Ctrl

    +

    Space

  • Selects an entire row in a worksheet

    Shift

    +

    Space

  • Selects the array containing the active cell

    Ctrl

    +

    /

  • Selects the current and next sheet in a workbook

    Ctrl + Shift

    +

    PgDn

  • Selects the current and next sheet in a workbook

    Ctrl + Shift

    +

    PgUp

  • Selects the entire worksheet. If the worksheet contains data, Ctrl+A selects the current region

    Ctrl

    +

    A

  • Sort Data

    Sorts the selection so that the highest (lowest) values are at the top of the column

    Alt

    +

    A,S,D (A)

  • Work With Formulas

    Calculate Data

    Calculates all worksheets in all open workbooks

    F9

  • Calculates the active worksheet

    Shift

    +

    F9

  • Check Formulas

    Alternates between displaying cell values and displaying formulas in the worksheet

    Ctrl

    +

    `

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

    Ctrl + Alt

    +

    Shift + F9

  • Toggle absolute and relative references

    F4

  • Fill Formulas

    Fills the selected cell range with the current entry

    Ctrl

    +

    Enter

  • Flash Fill - Automatically fills in values

    Ctrl

    +

    E

  • Insert Functions

    Displays the Insert Function dialog box

    Shift

    +

    F3

  • Insert an AutoSum function.

    Alt

    +

    =

  • Inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula

    Ctrl + Alt

    +

    A

  • Access Other Excel Features

    Creates a new, blank workbook

    Ctrl + Alt

    +

    N

  • Access Other Excel Features

    Displays the Excel Help task pane

    F1

  • Displays the Open dialog box to open or find a file

    Ctrl

    +

    O

  • Displays the Print dialog box

    Ctrl

    +

    P

  • Displays the Save As dialog box

    F12

  • Saves the active file with its current file name, location, and file format

    Ctrl

    +

    S

  • Send using email (as attachment)

    Alt

    +

    F,H,E