Excel keyboard shortcuts

Microsoft Excel shortcuts are one of the best ways to increase your efficiency when modelling. Some modellers even place their mouse out of reach to force themselves to learn shortcuts, and many end up shunning the mouse completely. We believe there is merit to both methods.

Here are some of our favourite shortcuts used by our consultants.

1. Apply absolute referencing ($)
2. AutoFilter
3. Clear All
4. Copy
5. Cut
6. Edit the active cell
7. Extend the selection of cells by one cell
8. Fill Down
9. Group Selected Rows/Columns
10. Highlight precedent cells
11. Insert AutoSum
12. Move to the beginning of a Worksheet
13. Move to the edge of selected row/column
14. Move up, down, left or right respectively
15. New Sheet
16. New Workbook
17. Open Go To dialog
18. Paste
19. Paste Special
20. Redo
21. Select an entire column
22. Select an entire row
23. Select continues range to the last non-blank cell
24. Switch Workbooks
25. Undo
26. Ungroup Selected Rows/Columns

1. Apply absolute referencing ($) = F4

2. AutoFilter = Ctrl + Shift + L

3. Clear All = Alt + H + E + A

4. Copy = Ctrl + C

5. Cut = Ctrl + X

6. Edit the active cell = F2

7. Extend the selection of cells by one cell = Shift + Arrow keys

8. Fill Down = Ctrl + D

9. Group Selected Rows/Columns = Alt + Shift + Right Arrow

10. Highlight precedent cells = Ctrl + [

11. Insert AutoSum = Alt + =

12. Move to the beginning of a Worksheet = Ctrl + Home

13. Move to the edge of selected row/column = Ctrl + Arrow keys

14. Move up, down, left or right respectively = Arrows

15. New Sheet = Shift + F11

16. New Workbook = Ctrl + N

17. Open Go To dialog = F5

18. Paste = Ctrl + V

19. Paste Special = Ctrl + Alt + V

20. Redo = Ctrl + Y

21. Select an entire column = Ctrl + Spacebar

22. Select an entire row = Shift + Spacebar

23. Select continues range to the last non-blank cell = Ctrl + Shift + Arrow

24. Switch Workbooks = Ctrl + Tab

25. Undo = Ctrl + Z

26. Ungroup Selected Rows/Columns = Alt + Shift + Left Arrow