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