Microsoft Excel Shortcut Keys

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


10 views

© 2018 JIL Software Solutions