Microsoft Excel Shortcut Keys

    Updated: Oct 3

    Below is a list of Microsoft Excel Shortcuts that can help you perform functions more quickly.


    MICROSOFT EXCEL SHORTCUTS

    Key Description

    Ctrl+A Select All

    Ctrl+B Bold

    Ctrl+C Copy

    Ctrl+D Fill Down

    Ctrl+F Find

    Ctrl+G Goto

    Ctrl+H Replace

    Ctrl+I Italic

    Ctrl+K Insert Hyperlink

    Ctrl+N New Workbook

    Ctrl+O Open

    Ctrl+P Print

    Ctrl+R Fill Right

    Ctrl+S Save

    Ctrl+U Underline

    Ctrl+V Paste

    Ctrl W Close

    Ctrl+X Cut

    Ctrl+Y Repeat

    Ctrl+Z Undo

    Ctrl+" Copy Value from Cell Above

    Ctrl+’ Copy Formula from Cell Above

    F7 Spell check

    F1 Help

    F2 Edit

    F3 Paste Name

    F4 Repeat last action

    F4 While typing a formula, switch between absolute/relative refs

    F5 Goto

    F6 Next Pane

    F8 Extend mode

    F9 Recalculate all workbooks

    F10 Activate Menubar

    F11 New Chart

    F12 Save As

    Ctrl+: Insert Current Time

    Ctrl+; Insert Current Date

    Shift Hold down shift for additional functions in Excel’s menu

    Shift+F1 What’s This?

    Shift+F2 Edit cell comment

    Shift+F3 Paste function into formula

    Shift+F4 Find Next

    Shift+F5 Find

    Shift+F6 Previous Pane

    Shift+F8 Add to selection

    Shift+F9 Calculate active worksheet

    Shift+F10 Display shortcut menu

    Shift+F11 New worksheet

    Shift+F12 Save

    Ctrl+F3 Define name

    Ctrl+F4 Close

    Ctrl+F5 XL, Restore window size

    Ctrl+F6 Next workbook window

    Shift+Ctrl+F6 Previous workbook window

    Ctrl+F7 Move window

    Ctrl+F8 Resize window

    Ctrl+F9 Minimize workbook

    Ctrl+F10 Maximize or restore window

    Ctrl+F11 Insert Macro worksheet

    Ctrl+F12 File Open

    Alt+F1 Insert Chart

    Alt+F2 Save As

    Alt+F4 Exit

    Alt+F8 Macro dialog box

    Alt+F11 Visual Basic Editor

    Ctrl+Shift+F3 Create name by using names of row and column labels

    Ctrl+Shift+F6 Previous Window

    Ctrl+Shift+F12 Print

    Alt+Shift+F1 New worksheet

    Alt+Shift+F2 Save

    Alt+= AutoSum

    Ctrl+` Toggle Value/Formula display

    Ctrl+Shift+A Insert argument names into formula

    Alt+Down arrow Display AutoComplete list

    Alt+’ Format Style dialog box

    Ctrl+Shift+~ General format

    Ctrl+Shift+! Comma format

    Ctrl+Shift+@ Time format

    Ctrl+Shift+# Date format

    Ctrl+Shift+$ Currency format

    Ctrl+Shift+% Percent format

    Ctrl+Shift+^ Exponential format

    Ctrl+Shift+& Place outline border around selected cells

    Ctrl+Shift+_ Remove outline border

    Ctrl+Shift+* Select current region

    Ctrl++ Insert

    Ctrl+- Delete

    Ctrl+1 Format cells dialog box

    Ctrl+2 Bold

    Ctrl+3 Italic

    Ctrl+4 Underline

    Ctrl+5 Strikethrough

    Ctrl+6 Show/Hide objects

    Ctrl+7 Show/Hide Standard toolbar

    Ctrl+8 Toggle Outline symbols

    Ctrl+9 Hide rows

    Ctrl+0 Hide columns

    Ctrl+Shift+( Unhide rows

    Ctrl+Shift+) Unhide columns

    Alt or F10 Activate the menu

    Ctrl+Tab In toolbar: next toolbar

    Shift+Ctrl+Tab In toolbar: previous toolbar

    Ctrl+Tab In a workbook: activate next workbook

    Shift+Ctrl+Tab In a workbook: activate previous workbook

    Tab Next tool

    Shift+Tab Previous tool

    Enter Do the command

    Shift+Ctrl+F Font Drop Down List

    Shift+Ctrl+F+F Font tab of Format Cell Dialog box

    Shift+Ctrl+P Point size Drop Down List


    12 views

    © 2018 JIL Software Solutions

    • JIL on Twitter
    • JIL on LinkedIn
    • JIL on Twitter
    • JIL on LinkedIn