Excel
Shortcuts
Cheat Sheet
Microsoft Excel is extensively used across the globe to store and analyze data. Despite
a variety of new data analysis tools on the market, Excel is still the preferred software for
working with data.
The shortcut keys in Excel help you work on data and perform tasks faster and more
effectively. However, it’s not possible to memorize every Excel shortcut. To develop your
expertise in Excel, it’s crucial to go beyond the basic cut (Ctrl+X), copy (Ctrl+C), and paste
(Ctrl+V) shortcuts.
Let’s explore the top important shortcuts, which you should know when working with
Microsoft Excel.
Editing
Description PC Mac
1. Copy Ctrl+C Ctrl+C
2. Paste Ctrl+V Ctrl+V
3. Undo Ctrl+Z Ctrl+Z
4. Redo Ctrl+Y Ctrl+Y
File
Description PC Mac
5. Open Ctrl+O Ctrl+O
6. New Ctrl+N Ctrl+N
7. Print Ctrl+P Ctrl+P
8. Save Ctrl+S Ctrl+S
9. Save as F12 ⌘+Shift+S
10. Go to next workbook Ctrl+Tab ⌘+~
11. Close file Ctrl+F4 Ctrl+W
12. Close all open Excel files Alt+F4 Ctrl+Q
Formatting
Description PC Mac
13. Open Format dialog Ctrl+1 ⌘+1
14. Bold Ctrl+B ⌘+B
15. talic
I Ctrl+I ⌘+I
16. Underline Ctrl+U ⌘+U
17. Number format Ctrl+Shift +! Ctrl+Shift +!
18. Percent format Ctrl+Shift+% Ctrl+Shift+%
19. Date format Ctrl+Shift+# Ctrl+Shift+#
20. nsert/edit comment
I Shift+F2 Shift+F2
21. ncrease font size
I Alt h fg ⌘+Shift+>
22. Decrease font size Alt h fk ⌘+Shift+<
23. ncrease indent
I Alt h 6 Ctrl+M
24. Decrease indent Alt h 5 ⌘+Shift+M
Paste special
Description PC Mac
25. Paste Special formats Ctrl+Alt+Vt Ctrl+⌘+Vt
26. Paste Special values Ctrl+Alt+V v Ctrl+⌘+V v
27. Paste Special formulas Ctrl+Alt+V f Ctrl+⌘+V f
28. Paste Special comments Ctrl+Alt+V c Ctrl+⌘+V c
G etting around the w orksheet
Description PC Mac
29. Move from cell to cell Arrows Arrows
30. Go to end of contiguous range
Ctrl+Arrows ⌘+Arrows
31. Move one screen up Pgup Fn+Up
32. Move one screen down Pgdn Fn+Down
33. Move one screen left Alt+Pgup Fn+Option+Up
34. Move one screen right Alt+Pgdn Fn+Option+Down
35. Go to cell A1 Ctrl+Home Fn+Ctrl+Left
36. Go to beginning of row Home Fn+Left
37. Go to last cell in worksheet Ctrl+End Fn+Ctrl+Right
38. Display the Go To dialog box F5 F5
Selecting data in a worksheet
Description PC Mac
39. Select a cell range Shift+Arrows Shift+Arrows
40. Highlight a contiguous range Ctrl+Shift+Arrows ⌘+Shift+Arrows
41. Extend selection up one screen Shift+Pgup Fn+Shift+Up
42. Extend selection down one screen Shift+Pgdn Fn+Shift+Down
43. Extend selection left one screen Alt+Shift+Pgup Fn+Shift+⌘+Up
44. Extend selection right one screen Alt+Shift+Pgdn Fn+Shift+⌘+Down
45. Select all Ctrl+A ⌘+A
Editing data
Description PC Mac
46. Fill down from cell above Ctrl+D Ctrl+D
47. Fill right from cell left Ctrl+R Ctrl+R
48. Find and replace Ctrl+F Ctrl+F
Editing data when inside a cell
Description PC Mac
49. Edit the active cell (edit mode) F2 F2
50. While editing cell, allow use of F2 F2
arrow keys to create reference
51. nsert line break within cell
I Alt+Enter Option+Enter
52. Highlight within a cell Shift+Left/Right Shift+Left/Right
53. Highlight contiguous items Ctrl+Shift+Left/ Ctrl+Shift+Left/
Right Right
54. Referencing a cell from another Ctrl+Pgup/Pgdn Ctrl+Fn+Down/Up
worksheet Arrows Arrows
Calculations
Description PC Mac
55. Start a formula = =
56. nsert autosum formula
I Alt+ = ⌘+Shift+T
57. Recalculate all worksheets F9 F9
$$
58. Anchor cells (A 1 ), toggle F4 F4
anchors (edit mode
59. nsert a function
I Shift+F3 Shift+F3
60. Enter array formula (edit mode) Shift+Ctrl+Enter Shift+Ctrl+Enter
Ro w and column shortcuts
Description PC Mac
61. Select column Ctrl+Spacebar Ctrl+Spacebar
62. Select row Shift+Spacebar Shift+Spacebar
63. Delete row(s)/column(s) Ctrl+ – Ctrl+ –
64. Add row(s)/column(s) Ctrl+Shift++ Ctrl+Shift++
65. Group rows/columns Alt+Shift+Right Option+Shift+Right
66. Ungroup rows/columns Alt+Shift+Left Option+Shift+Left
