Excel shortcuts

The Best Excel Shortcuts You're Not Using

If you're like most people, you probably use the same handful of Excel shortcuts over and over again. But there are plenty of other shortcuts that can save you time and make your work easier. Here are some of the best Excel shortcuts you're not using.

1. Ctrl + Shift + #

This shortcut formats a number as a date. For example, if you have a cell with the value 42117, this shortcut will format it as 4/21/17. This is a great shortcut for quickly formatting dates that are entered as numbers.

2. Ctrl + Shift + $

This shortcut formats a number as currency. For example, if you have a cell with the value 42117, this shortcut will format it as $42,117. This is a great shortcut for quickly formatting numbers as currency.

3. Ctrl + Shift + %

This shortcut formats a number as a percentage. For example, if you have a cell with the value 0.42117, this shortcut will format it as 42.117%. This is a great shortcut for quickly formatting numbers as percentages.

4. Ctrl + Shift + ^

This shortcut formats a number as exponential. For example, if you have a cell with the value 42117, this shortcut will format it as 4.2E+04. This is a great shortcut for quickly formatting numbers in exponential notation.

5. Ctrl + Shift + &

This shortcut formats a number as text. This is a great shortcut for quickly formatting numbers as text, which can be useful for concatenating numbers with other text.

6. Ctrl + Shift + _

This shortcut removes the formatting from a cell. This is a great shortcut for quickly removing unwanted formatting from a cell.

7. Ctrl + Shift + +

This shortcut inserts a new row above the current row. This is a great shortcut for quickly inserting new rows of data.

8. Ctrl + Shift + -

This shortcut inserts a new column to the left of the current column. This is a great shortcut for quickly inserting new columns of data.

9. Ctrl + Shift + *

This shortcut selects the entire worksheet. This is a great shortcut for quickly selecting all of the data in a worksheet.

10. Ctrl + Shift + /

This shortcut selects the entire column. This is a great shortcut for quickly selecting all of the data in a column.

11. Ctrl + Shift + ?

This shortcut selects the entire row. This is a great shortcut for quickly selecting all of the data in a row.

12. Ctrl + Shift + <

This shortcut decreases the font size. This is a great shortcut for quickly making text smaller.

13. Ctrl + Shift + >

This shortcut increases the font size. This is a great shortcut for quickly making text larger.

14. Ctrl + Shift + B

This shortcut makes text bold. This is a great shortcut for quickly making text bold.

15. Ctrl + Shift + I

This shortcut makes text italic. This is a great shortcut for quickly making text italic.

16. Ctrl + Shift + U

This shortcut makes text underlined. This is a great shortcut for quickly making text underlined.

17. Ctrl + Shift + ~

This shortcut applies the General format. This is a great shortcut for quickly applying the General format to a cell.

18. Ctrl + Shift + !

This shortcut applies the Number format. This is a great shortcut for quickly applying the Number format to a cell.

19. Ctrl + Shift + @

This shortcut applies the Time format. This is a great shortcut for quickly applying the Time format to a cell.

20. Ctrl + Shift + #

This shortcut applies the Date format. This is a great shortcut for quickly applying the Date format to a cell.

21. Ctrl + Shift + $

This shortcut applies the Currency format. This is a great shortcut for quickly applying the Currency format to a cell.

22. Ctrl + Shift + %

This shortcut applies the Percentage format. This is a great shortcut for quickly applying the Percentage format to a cell.

23. Ctrl + Shift + ^

This shortcut applies the Exponential format. This is a great shortcut for quickly applying the Exponential format to a cell.

24. Ctrl + Shift + &

This shortcut applies the Text format. This is a great shortcut for quickly applying the Text format to a cell.

25. Ctrl + Shift + +

This shortcut applies the AutoSum function. This is a great shortcut for quickly summing a range of cells.

26. Ctrl + Shift + -

This shortcut applies the Average function. This is a great shortcut for quickly averaging a range of cells.

27. Ctrl + Shift + *

This shortcut applies the Count function. This is a great shortcut for quickly counting a range of cells.

28. Ctrl + Shift + /

This shortcut applies the Max function. This is a great shortcut for quickly finding the maximum value in a range of cells.

29. Ctrl + Shift + ?

This shortcut applies the Min function. This is a great shortcut for quickly finding the minimum value in a range of cells.

30. Ctrl + Shift + <

This shortcut applies the If function. This is a great shortcut for quickly applying the If function to a cell.

31. Ctrl + Shift + >

This shortcut applies the And function. This is a great shortcut for quickly applying the And function to a cell.

32. Ctrl + Shift + B

This shortcut applies the Or function. This is a great shortcut for quickly applying the Or function to a cell.

33. Ctrl + Shift + I

This shortcut applies the Not function. This is a great shortcut for quickly applying the Not function to a cell.

34. Ctrl + Shift + U

This shortcut applies the Concatenate function. This is a great shortcut for quickly concatenating a range of cells.

35. Ctrl + Shift + ~

This shortcut applies the Left function. This is a great shortcut for quickly extracting the leftmost characters from a cell.

36. Ctrl + Shift + !

This shortcut applies the Right function. This is a great shortcut for quickly extracting the rightmost characters from a cell.

37. Ctrl + Shift + @

This shortcut applies the Mid function. This is a great shortcut for quickly extracting characters from the middle of a cell.

38. Ctrl + Shift + #

This shortcut applies the Len function. This is a great shortcut for quickly finding the length of a cell.

39. Ctrl + Shift + $

This shortcut applies the Find function. This is a great shortcut for quickly finding a value in a cell.

40. Ctrl + Shift + %

This shortcut applies the Substitute function. This is a great shortcut for quickly replacing a value in a cell.

41. Ctrl + Shift + ^

This shortcut applies the Search function. This is a great shortcut for quickly finding a value in a cell.

42. Ctrl + Shift + &

This shortcut applies theTranspose function. This is a great shortcut for quickly transposing a range of cells.

43. Ctrl + Shift + +

This

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.