Excel shortcuts

25 essential Excel shortcuts for data analysis

If you work with data in Excel, these 25 shortcuts will help you get your work done faster and more efficiently. From basic navigation and selection to more advanced data analysis features, these shortcuts will help you get the most out of Excel.

1. Ctrl + Arrow keys - Move to the edge of the data in any direction

2. Shift + Arrow keys - Select a range of cells

3. Ctrl + A - Select all cells in the worksheet

4. Ctrl + Space - Select the entire column

5. Ctrl + F - Open the Find dialog box

6. Ctrl + H - Open the Replace dialog box

7. Ctrl + G - Open the Go To dialog box

8. F5 - Open the Go To dialog box

9. Ctrl + P - Open the Print dialog box

10. Alt + F11 - Open the Visual Basic Editor

11. Ctrl + ` - Display the formulas in the worksheet

12. F9 - Calculate all worksheets in all open workbooks

13. Shift + F9 - Calculate the active worksheet

14. F7 - Check spelling

15. Alt + = - Insert the AutoSum formula

16. Ctrl + Shift + ' - Copy the value from the cell above

17. Ctrl + D - Fill down

18. Ctrl + R - Fill right

19. Ctrl + ' - Copy the formula from the cell above

20. Ctrl + Shift + : - Insert the current time

21. Ctrl + Shift + ; - Insert the current date

22. Ctrl + Shift + ~ - Apply the General number format

23. Ctrl + Shift + $ - Apply the Currency format

24. Ctrl + Shift + % - Apply the Percent format

25. Ctrl + Shift + ^ - Apply the Exponential number format

These are just a few of the essential shortcuts that every Excel user should know. For a more complete list of shortcuts, check out the Microsoft Office website.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.