Useful Microsoft Excel Shortcut Keys

Useful Microsoft Excel Shortcut Keys

ShortcutDescription
Ctrl+ASelect all contents of a sheet.
Ctrl+BBold Text
Ctrl+CCopy selected cells.
Ctrl+DFill Down
Ctrl+FFind
Ctrl+GGoto
Ctrl+HReplace
Ctrl+IItalic
Ctrl+KInsert Hyperlink
Ctrl+NNew Workbook
Ctrl+OOpen
Ctrl+PPrint
Ctrl+RFill Right
Ctrl+SSave
Ctrl+UUnderline
Ctrl+VPaste
Ctrl WClose
Ctrl+XCut
Ctrl+YRepeat
Ctrl+ZUndo
F1Help
F2Edit
F3Paste Name
F4Repeat last action
F5Goto
F6Next Pane
F7Spell check
F8Extend mode
F9Recalculate all workbooks
F10Activate Menubar
F11New Chart
F12Save As
Ctrl+:Insert Current Time
Ctrl+"Copy Value from Cell Above
Ctrl+’Copy Fromula from Cell Above
ShiftHold down shift for additional functions in Excel’s menu
Shift+F1What’s This?
Shift+F2Edit cell comment
Shift+F3Paste function into formula
Shift+F4Find Next
Shift+F5Find
Shift+F6Previous Pane
Shift+F8Add to selection
Shift+F9Calculate active worksheet
Shift+F10Display shortcut menu
Shift+F11New worksheet
Shift+F12Save
Ctrl+F3Define name
Ctrl+F4Close
Ctrl+F5XL, Restore window size
Ctrl+F6Next workbook window
Shift+Ctrl+F6Previous workbook window
Ctrl+F7Move window
Ctrl+F8Resize window
Ctrl+F9Minimize workbook
Ctrl+F10Maximize or restore window
Ctrl+F11Inset 4.0 Macro sheet
Ctrl+F12File Open
Alt+F1Insert Chart
Alt+F2Save As
Alt+F4Exit
Alt+F8Macro dialog box
Alt+F11Visual Basic Editor
Ctrl+Shift+F3Create name by using names of row and column labels
Ctrl+Shift+F6Previous Window
Ctrl+Shift+F12Print
Alt+Shift+F1New worksheet
Alt+Shift+F2Save
Alt+=AutoSum
Ctrl+`Toggle Value/Formula display
Ctrl+Shift+AInsert argument names into formula
Alt+Down arrowDisplay 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+1Format cells dialog box
Ctrl+2Bold
Ctrl+3Italic
Ctrl+4Underline
Ctrl+5Strikethrough
Ctrl+6Show/Hide objects
Ctrl+7Show/Hide Standard toolbar
Ctrl+8Toggle Outline symbols
Ctrl+9Hide rows
Ctrl+0Hide columns
Ctrl+Shift+(Unhide rows
Ctrl+Shift+)Unhide columns
Alt or F10Activate the menu
Ctrl+TabIn toolbar: next toolbar
Shift+Ctrl+TabIn toolbar: previous toolbar
Ctrl+TabIn a workbook: activate next workbook
Shift+Ctrl+TabIn a workbook: activate previous workbook
Tab

Next tool

Shift+TabPrevious tool
EnterDo the command
Shift+Ctrl+FFont Drop Down List
Shift+Ctrl+F+FFont tab of Format Cell Dialog box
Shift+Ctrl+PPoint size Drop Down List

loading…

1 thought on “Useful Microsoft Excel Shortcut Keys

Leave a Reply

Your email address will not be published. Required fields are marked *