MS Excel Updated Shortcut Key list

• Save it and it will be very Helpful in office work.

Ctrl + Alphabet: For Basics font Formats

Note: Ctrl + alphabet bassically used for more common and basics work done

1. Ctrl+A – Select All
2. Ctrl+B – Bold
3. Ctrl+C – Copy
4. Ctrl+D – Fill Down
5. Ctrl+F – Find
6. Ctrl+G – Goto
7. Ctrl+H – Replace
8. Ctrl+I – Italic
9. Ctrl+K – Insert Hyperlink
10. Ctrl+N – New Workbook
11. Ctrl+O – Open
12. Ctrl+P – Print
13. Ctrl+R – Fill Right
14. Ctrl+S – Save
15. Ctrl+U – Underline
16. Ctrl+V – Paste
17. Ctrl W – Close
18. Ctrl+X – Cut
19. Ctrl+Y – Repeat
20. Ctrl+Z – Undo

Function Key

1. F1 – Help
2. F2 – Edit
3. F3 – Paste Name
4. F4 – Repeat last action
5. F4 – While typing a formula, switch between absolute/relative refs
6. F5 – Goto
7. F6 – Next Pane
8. F7 – Spell check
9. F8 – Extend mode
10. F9 – Recalculate all workbooks
11. F10 – Activate Menubar
12. F11 – New Chart
13. F12 – Save As

Other work done

1. Ctrl+: – Insert Current Time
2. Ctrl+; – Insert Current Date
3. Ctrl+” – Copy Value from Cell Above
4. Ctrl+’ – Copy Formula from Cell Above

Shift + Function Key

1. Shift – Holddown shift for additional functions in Excel’s menu
2. Shift+F1 – What’s This?
3. Shift+F2 – Edit cell comment
4. Shift+F3 – Paste function into formula
5. Shift+F4 – Find Next
6. Shift+F5 – Find
7. Shift+F6 – Previous Pane
8. Shift+F8 – Add to selection
9. Shift+F9 – Calculate active worksheet
10. Shift+F10 – Display shortcut menu
11. Shift+F11 – New worksheet
12. Shift+F12 – Save

Ctrl + Function Key

1. Ctrl+F1 – File Open
2. Ctrl+F3 – Define name
3. Ctrl+F4 – Close
4. Ctrl+F5 – XL, Restore window size
5. Ctrl+F6 – Next workbook window
6. Shift+Ctrl+F6 – Previous workbook window
7. Ctrl+F7 – Move window
8. Ctrl+F8 – Resize window
9. Ctrl+F9 – Minimize workbook
10. Ctrl+F10 – Maximize or restore window
11. Ctrl+F11 – Inset 4.0 Macro sheet

Alt + Function Key

Note: Alt’s basics work with windows, so whenever you use alt, be shore

1. Alt+F1 – Insert Chart
2. Alt+F2 – Save As
3. Alt+F4 – Exit
4. Alt+F8 – Macro dialog box
5. Alt+F11 – Visual Basic Editor

Ctrl/Alt + Shift + Functoin Key

1. Ctrl+Shift+F3 – Create name by using names of row and column labels
2. Ctrl+Shift+F6 – Previous Window
3. Ctrl+Shift+F12 – Print
4. Alt+Shift+F1 – New worksheet
5. Alt+Shift+F2 – Save

Others

1. Alt+= – AutoSum
2. Ctrl+` – Toggle Value/Formula display
3. Ctrl+Shift+A – Insert argument names into formula
4. Alt+Down arrow – Displayy AutoComplete list
5. Alt+’ – Format Style dialog box

Ctrl + Shift + Symbolls

Note: Ctrl + Shift + symbols is used mostly for changing format

1. Ctrl+Shift+~ – General format
2. Ctrl+Shift+! – Comma format
3. Ctrl+Shift+@ – Time format
4. Ctrl+Shift+# – Date format
5. Ctrl+Shift+$ – Currency format
6. Ctrl+Shift+% – Percent format
7. Ctrl+Shift+^ – Exponential format
8. Ctrl+Shift+& – Place outline border around selected cells
9. Ctrl+Shift+_ – Remove outline border
10. Ctrl+Shift+* – Select current region

Ctrl + Numbers

1. Ctrl++ – Insert
2. Ctrl+- – Delete
3. Ctrl+1 – Format cells dialog box
4. Ctrl+2 – Bold
5. Ctrl+3 – Italic
6. Ctrl+4 – Underline
7. Ctrl+5 – Strikethrough
8. Ctrl+6 – Show/Hide objects
9. Ctrl+7 – Show/Hide Standard toolbar
10. Ctrl+8 – Toggle Outline symbols
11. Ctrl+9 – Hide rows
12. Ctrl+0 – Hide columns
13. Ctrl+Shift+( – Unhide rows
14. Ctrl+Shift+) – Unhide columns

Others Important

• Alt or F10 – Activate the menu
• Ctrl+Tab – In toolbar: next toolbar
• Shift+Ctrl+Tab – In toolbar: previous toolbar
• Ctrl+Tab – In a workbook: activate next workbook
• Shift+Ctrl+Tab – In a workbook: activate previous workbook
• Tab – Next tool
• Shift+Tab – Previous tool
• Enter – Do the command
• Shift+Ctrl+F – Font Drop Down List
• Shift+Ctrl+F+F – Font tab of Format Cell Dialog box
• Shift+Ctrl+P – Point size Drop Down List

Book-Mark this page, and read daily so you memorized and make your work easy