Over 40 Excel Tips and Tricks

Useful Excel tips and tricks that you may find helpful:

1. Use Ctrl + S to save your work frequently.
2. Use the Fill Handle to quickly fill a series of cells with a pattern.
3. Use Ctrl + D to copy the contents of the cell above into the current cell.
4. Use Ctrl + R to copy the contents of the cell to the left into the current cell.
5. Use F4 to repeat the last action performed.
6. Use Alt + Enter to insert a line break within a cell.
7. Use Ctrl + Shift + L to apply or remove filters.
8. Use Ctrl + Home to go to the top-left cell of your spreadsheet.
9. Use Ctrl + End to go to the last cell in the used range of your spreadsheet.
10. Use Ctrl + Shift + Arrow Key to select a range of cells.
11. Use Ctrl + Space to select the entire column of the active cell.
12. Use Shift + Space to select the entire row of the active cell.
13. Use Ctrl + Shift + + to insert a new row or column.
14. Use Ctrl + – to delete a selected row or column.
15. Use Ctrl + Shift + $ to apply currency formatting to selected cells.
16. Use Ctrl + Shift + % to apply percentage formatting to selected cells.
17. Use Ctrl + Shift + # to apply date formatting to selected cells.
18. Use Ctrl + Shift + @ to apply time formatting to selected cells.
19. Use Ctrl + 1 to open the Format Cells dialog box.
20. Use Ctrl + Shift + ~ to apply General formatting to selected cells.
21. Use Ctrl + Shift + ^ to apply Scientific formatting to selected cells.
22. Use Ctrl + Shift + ! to apply Number formatting to selected cells.
23. Use Ctrl + Shift + * to select the current region around the active cell.
24. Use Ctrl + Shift + O to select all cells with formulas that reference the active cell.
25. Use Ctrl + Shift + { to select all cells that contain precedents of the active cell.
26. Use Ctrl + Shift + } to select all cells that contain dependents of the active cell.
27. Use F2 to edit the contents of the active cell.
28. Use F9 to calculate the selected formula.
29. Use Ctrl + ` to toggle between displaying formulas and displaying cell values.
30. Use Ctrl + H to open the Find and Replace dialog box.
31. Use Ctrl + F to open the Find dialog box.
32. Use Ctrl + G to open the Go To dialog box.
33. Use Alt + = to insert a SUM formula for the selected range of cells.
34. Use Ctrl + ; to insert the current date.
35. Use Ctrl + Shift + : to insert the current time.
36. Use Ctrl + K to insert a hyperlink.
37. Use Ctrl + F3 to open the Name Manager.
38. Use Ctrl + Shift + F3 to open the Create Names dialog box.
39. Use Ctrl + Shift + F6 to switch between open workbooks.
40. Use Ctrl + Tab to switch between open worksheets.
41. Use Alt + F11 to open the Visual Basic Editor.
42. Use F7 to check the spelling of the active cell.
43. Use Ctrl + Shift + U to convert