EXCEL a to z SHORTCUT KEYS

Posted by

EXCEL a to z SHORTCUT KEYS

ALT KEY SHORTCUT A to Z CTRL KEY SHORTCUT FUCTION KEY SHORTCUT
ALT +F1Insert chartCTRL+A Select all cellsF1Help
ALT +F2Save asCTRL +BBoldF2Edit Cells
ALT+F4ExitCTRL+CCopyF3Paste Name
ALT+F8Macro dialog boxCTRL+DFill downF4Repeat action
ALT +F11Visual Basic editorCTRL+EFlash fillF5Cells
ALT + TABSwitch programsCTRL+FFindF6Go to Special
ALT+`Format Style Dialog boxCTRL+ GGo to SpecialF7Next pane
ALT + ENTERAdd a line in cellCTRL+HFind and ReplaceF8Spell Check
ALT+E,S,TCopy FormatCTRL+IItalics textF9Extend Mode
ALT+H,O,R Change Tab NameCTRL+JNIAF10Recalculate Workbooks
ALT +H,O,1AutoFit Column widthCTRL+KInsert HyperlinkF11Activate Menu bar
CTRL KEY SHORTCUTCTRL+LCreate TableF12New Chart
CTRL+0Hide ColumnsCTRL+MN/AShift +F1Save As
CTRL +1 Format Cells Dialog Box CTRL+NNew WorkbookShift +F2What’s this
CTRL +2Bold textCTRL+OOpen FileShift+F3Insert Comment
CTRL +3Italics textCTRL+PPrintShift  +F4 Paste Function into
 CTRL+4Underline textCTRL +QData Analysis toolShift +F5Formula
CTRL+5StrikethroughCTRL+RFill RightShift +F6Find next
CTRL+6Show /Hide ObjectsCTRL+SSave workbookShift +F8Find
CTRL+7 Show/Hide ToolbarCTRL+TCreate tableShift +F9Previous Pane
CTRL +8Toggle Outline SymbolsCTRL+UUnderline textShift +F10Add to Selection
CTRL +9Hide RowsCTRL+VPasteShift +F11New Worksheet
CTRL + –Delete Row/ColumnCTRL+WClose WorkbookShift +F12Save
CTRL ++Insert Row/ColumnCTRL+XCutCtrl+F3Name Manager
CTRL
+;
Insert Current DateCTRL+YRedoCtrl + F4Close
CTRL+*Show FormulasCTRL+ZUndoCtrl+F9Minimize window
CTRL+ HOME Go to cell A1CTRL+ArrowsGo to end of rangeCtrl+F10Restore

Leave a Reply

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