Microsoft Excel Shortcut keys of Ctrl Key, Shift key with navigation keys (delete, arrow, home, end, pageup, pagedown)
| Tab key | Tab + Shift Key |
| Goto Right Cell | Goto Left Cell |
| Up Arrow Key/ Shift + Enter | Down Arrow Key/ Enter key |
| Goto up Cell | Goto Down Cell |
| Ctrl + Left | Ctrl + Up |
| Goto First Cell of Row/Content | Goto First Cell of Column/Content |
| Ctrl + Right | Ctrl + Down |
| Goto Last Cell of Row/Content | Goto Last Cell of Column/Content |
| Ctrl + shift + Left | Ctrl + Shift + Up |
| Selects the left side row from the cursor | Selects the up side row from the cursor |
| Ctrl + Shitf + Right | Ctrl + Shift + Down |
| Selects the right side row from the cursor | Selects the down side row from the cursor |
| Home | Ctrl + Home |
| Goto first cell of the row | Goto A1 cell |
| Ctrl + End | Ctrl + Shift + End |
| Move to last Content of Cell | Select Content Cells After the cursor |
| Ctrl + Shift + Home | Ctrl + Shift + End |
| Selects from cursor to A1 Cell | Selects from cursor to the last content of the cell Or if blank selcts from cursor to A1 cell |
| Pagedown / Shift + Pagedown | Pageup/ Shift + Pageup |
| Goto down next screen | Goto up next screen |
| Alt + Pagedown/ Shift + Alt + Pagedown | Alt + Pageup/ Shift + Alt + Pageup |
| Goto right next screen | Goto left next screen |
| Ctrl + Pagedown | Ctrl + Pageup |
| Move to next right sheet | Move to next left sheet |
| Delete | Backspace |
| Deletes to right side | Deletes to leftside |
| Ctrl + Delete | Ctrl + Backspace |
| Delete one word to right side | Delete one word to left side |
Microsoft Excel Shortcut keys of Ctrl Key from A to Z
Here we discuss about the microsoft excel shortcuts. Though there are many microsoft excel short cuty keys in excel. Here in this table we list shortcut key of Ctrl + (From A to Z).
| Ctrl + A | Ctrl + B | Ctrl + C | Ctrl + D |
| Select All | Bold Txt | Copy | Fill down |
| Ctrl + F | Ctrl + G | Ctrl + H | Ctrl + I |
| Find | Goto | Find and Replace | Italics |
| Ctrl + K | Ctrl + L | Ctrl + N | Ctrl + O |
| Insert Hyperlink | Create Table | Create new Workbook | Open Workbook |
| Ctrl + P | Ctrl + R | Ctrl + S | Ctrl + T |
| Fill Right | Save | Create Table | |
| Ctrl + U | Ctrl + V | Ctrl + W | Ctrl + X |
| Underline | Paste | Close Current Workbook | Cut |
| Ctrl + Y | Ctrl + Z | ||
| Redo | Undo |
Note :
Ctrl + E
Ctrl + J
Ctrl + M
Ctrl + Q
These four keys are unassigned keys in Excel Shortcuts. Microsoft Excel Shortcut keys of Ctrl and Shift Key from 0 to 9
| Ctrl + ~ (tile) | Ctrl + Shift + ~ (tile) | Ctrl +1 | Ctrl + Shift + 1 |
| Show Formula | Apply General Number Format | show Format Cell Window | Apply to Number format |
| Ctrl + 2 | Ctrl + Shift + 2 | Ctrl + 3 | Ctrl + Shift + 3 |
| Bold | Show custom time | Italics | Show Date |
| Ctrl + 4 | Ctrl + Shift + 4 | Ctrl + 5 | Ctrl + Shift + 5 |
| Underline | Apply Currency $ format | Strike | Apply Percentage format |
| Ctrl + 6 | Ctrl + Shift + 6 | Ctrl + 7 | Ctrl + Shift + 7 |
| Hide/Show Object | Apply Scientific Format | Not assigned | Outline border |
| Ctrl + 8 | Ctrl + Shift + 8 | Ctrl + 9 | Ctrl + Shift + 9 |
| Show/hide outline of subtotal | Show/hide outline of subtotal | Hide Row | Show Row |
| Ctrl + 0 | Ctrl + Shift + 0 | Ctrl + – | Ctrl + Shift + _ |
| Hide Column | Not assigned | Delete Row Cell | Remove all border |
| Ctrl + + | Ctrl + Shift + + | Ctrl + ‘ | Ctrl + Shift + ‘ |
| — | Insert Row | Fill down value | Fill down value |
| Ctrl + ; | Ctrl + Shift + : | ||
| Current Date | Current Time |
Microsoft Excel Shortcut keys of Function Key from F1 to F12
| F1 | Ctrl + F1 | Shitf + F1 | Shift + Alt + F1 |
| Help | Hide/Unhide Ribbon | Create Chart in Same sheet | Add New Sheet |
| F2 | Ctrl + F2 | Shift + F2 | Shift + Alt + F2 |
| Edit Mode | Print Preview | Insert/Create New Comment | Save As |
| Alt + F2 | Alt + F2 | Ctrl+Alt+F2 | |
| Save As | Open Window | ||
| F3 | Ctrl + F3 | Shift + F3 | Ctrl+ Shift+F3 |
| Paste Name Manager | Open Name Manager | Insert Function | Create Name manager from row and column level |
| Ctrl +Alt + F3 | |||
| Create New Name Manager | |||
| F4 | Ctrl + F4 | Alt + F4 | |
| i. Change reference to $ (locks the cell) ii. Repeat Action of Copy Paste for once iii. Repeat the color action done in chart | Close One Work book | Exit/Close Whole Excel | |
| F5 | Ctrl + F5 | Shift + F5 | |
| Goto Dialog Box | Restore current window | Find and Replace in selected cell | |
| F6 | Ctrl +F6 | Ctrl +Shift + F6 | |
| Move to Different Pane | Switch between different workbook without mouse | Same as F6 | |
| F7 | Ctrl + F7 | Shift + F7 | |
| Check Spelling Error | Move different Work book | Thesarus/ Research | |
| F8 | Ctrl + F8 | Shift + F8 | Alt + F8 |
| Extend Selection –> Press Esc for escaping | To activate the restore move sign | Extend Selection as needed | Open Macro if exist |
| F9 | Ctrl + F9 | Shift + F9 | |
| Update Manual Work | Only minimize workbook | Update Manual Work | |
| F10 | Ctrl + F10 | Alt + F10 | |
| Activate Menu | Restore Workbook | Open dialog box of Selection Shapes | |
| F11 | Ctrl + F11 | Shift + F11 | Alt + F11 |
| Make New Chart in New Sheet | Add Macro Sheet | Add new Work Sheet | Acive Visual Basic |
| F12 | Ctrl + F12 | Shift + F12 | Ctrl + Shift + F12 |
| Save As | Open Dialog Box | Save As |
1,518 total views, 7 views today