EXCEL a to z SHORTCUT KEYS
ALT KEY SHORTCUT | A to Z CTRL KEY SHORTCUT | FUCTION KEY SHORTCUT | |||
ALT +F1 | Insert chart | CTRL+A | Select all cells | F1 | Help |
ALT +F2 | Save as | CTRL +B | Bold | F2 | Edit Cells |
ALT+F4 | Exit | CTRL+C | Copy | F3 | Paste Name |
ALT+F8 | Macro dialog box | CTRL+D | Fill down | F4 | Repeat action |
ALT +F11 | Visual Basic editor | CTRL+E | Flash fill | F5 | Cells |
ALT + TAB | Switch programs | CTRL+F | Find | F6 | Go to Special |
ALT+` | Format Style Dialog box | CTRL+ G | Go to Special | F7 | Next pane |
ALT + ENTER | Add a line in cell | CTRL+H | Find and Replace | F8 | Spell Check |
ALT+E,S,T | Copy Format | CTRL+I | Italics text | F9 | Extend Mode |
ALT+H,O,R | Change Tab Name | CTRL+J | NIA | F10 | Recalculate Workbooks |
ALT +H,O,1 | AutoFit Column width | CTRL+K | Insert Hyperlink | F11 | Activate Menu bar |
CTRL KEY SHORTCUT | CTRL+L | Create Table | F12 | New Chart | |
CTRL+0 | Hide Columns | CTRL+M | N/A | Shift +F1 | Save As |
CTRL +1 | Format Cells Dialog Box | CTRL+N | New Workbook | Shift +F2 | What’s this |
CTRL +2 | Bold text | CTRL+O | Open File | Shift+F3 | Insert Comment |
CTRL +3 | Italics text | CTRL+P | Shift +F4 | Paste Function into | |
CTRL+4 | Underline text | CTRL +Q | Data Analysis tool | Shift +F5 | Formula |
CTRL+5 | Strikethrough | CTRL+R | Fill Right | Shift +F6 | Find next |
CTRL+6 | Show /Hide Objects | CTRL+S | Save workbook | Shift +F8 | Find |
CTRL+7 | Show/Hide Toolbar | CTRL+T | Create table | Shift +F9 | Previous Pane |
CTRL +8 | Toggle Outline Symbols | CTRL+U | Underline text | Shift +F10 | Add to Selection |
CTRL +9 | Hide Rows | CTRL+V | Paste | Shift +F11 | New Worksheet |
CTRL + – | Delete Row/Column | CTRL+W | Close Workbook | Shift +F12 | Save |
CTRL ++ | Insert Row/Column | CTRL+X | Cut | Ctrl+F3 | Name Manager |
CTRL +; | Insert Current Date | CTRL+Y | Redo | Ctrl + F4 | Close |
CTRL+* | Show Formulas | CTRL+Z | Undo | Ctrl+F9 | Minimize window |
CTRL+ HOME | Go to cell A1 | CTRL+Arrows | Go to end of range | Ctrl+F10 | Restore |
Leave a Reply