Scribd
Upload
6K views

50 MS-Excel Shortcut Key

Uploaded by

ravi254978
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
6K views

50 MS-Excel Shortcut Key

Uploaded by

ravi254978
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

1.

File and Workbook Operations


1. Ctrl + N – New Workbook
2. Ctrl + O – Open Workbook
3. Ctrl + S – Save Workbook
4. F12 – Save As
5. Ctrl + P – Print
6. Ctrl + W – Close Workbook
7. Alt + F4 – Close Excel
8. Ctrl + Z – Undo
9. Ctrl + Y – Redo

2. Navigation and Selection


10. Arrow Keys – Move One Cell
11. Ctrl + Arrow Keys – Jump to Edge of Data
12. Shift + Arrow Keys – Select Cells
13. Ctrl + Shift + Arrow Keys – Select Range to Edge
14. Ctrl + Home – Go to Beginning of Worksheet
15. Ctrl + End – Go to Last Used Cell
16. Page Up/Page Down – Move One Screen Up/Down
17. Alt + Page Up/Page Down – Move One Screen Left/Right

3. Editing Cells and Data


18. F2 – Edit Active Cell
19. Esc – Cancel Entry
20. Enter – Complete Entry
21. Ctrl + D – Fill Down
22. Ctrl + R – Fill Right
23. Alt + Enter – Insert New Line in Cell
24. Ctrl + ; (Semicolon) – Insert Current Date
25. Ctrl + Shift + : (Colon) – Insert Current Time

4. Formatting and Styles


26. Ctrl + B – Bold
27. Ctrl + I – Italic
28. Ctrl + U – Underline
29. Ctrl + 1 – Format Cells Dialog Box
30. Ctrl + Shift + $ – Apply Currency Format
31. Ctrl + Shift + % – Apply Percentage Format
32. Ctrl + Shift + # – Apply Date Format
33. Ctrl + Shift + ^ – Apply Scientific Format
34. Ctrl + Shift + & – Apply Border
35. Ctrl + Shift + _ – Remove Border

5. Working with Rows, Columns, and Sheets


36. Ctrl + Space – Select Entire Column
37. Shift + Space – Select Entire Row
38. Ctrl + Shift + + – Insert Cell/Row/Column
39. Ctrl + - – Delete Cell/Row/Column
40. Alt + H + O + R – Rename Sheet
41. Ctrl + Page Up/Page Down – Switch Sheets

6. Formulas and Functions


42. = – Start Formula
43. Alt + = – AutoSum
44. Ctrl + ` – Toggle Formula View
45. F4 – Toggle Absolute/Relative References
46. Shift + F3 – Insert Function

7. Data Management
47. Ctrl + T – Create Table
48. Alt + A + T – Filter Data
49. Alt + A + S + S – Sort Data

8. Miscellaneous
50. F7 – Spell Check

You might also like