Microsoft Excel keyboard shortcuts

Before you proceed, note that the list is pretty long but it is by no means a complete list consisting of all the Excel shortcuts. However, we have picked out some of the most useful shortcuts, and we hope this would be worth your time.


1. Ctrl + N: To create a new workbook.

2. Ctrl + O: To open a saved workbook.

3. Ctrl + S: To save a workbook.

4. Ctrl + A: To select all the contents in a workbook.

5. Ctrl + B: To turn highlighted cells bold.

6. Ctrl + C: To copy cells that are highlighted.

7. Ctrl + D: To fill the selected cell with the content of the cell right above.

8. Ctrl + F: To search for anything in a workbook.

9. Ctrl + G: To jump to a certain area with a single command.

10. Ctrl + H: To find and replace cell contents.

11. Ctrl + I: To italicise cell contents.

12. Ctrl + K: To insert a hyperlink in a cell.

13. Ctrl + L: To open the create table dialog box.

14. Ctrl + P: To print a workbook.

15. Ctrl + R: To fill the selected cell with the content of the cell on the left.

16. Ctrl + U: To underline highlighted cells.

17. Ctrl + V: To paste anything that was copied.

18. Ctrl + W: To close your current workbook.

19. Ctrl + Z: To undo the last action.

20. Ctrl + 1: To format the cell contents.

21. Ctrl + 5: To put a strikethrough in a cell.

22. Ctrl + 8: To show the outline symbols.

23. Ctrl + 9: To hide a row.

24. Ctrl + 0: To hide a column.

25. Ctrl + Shift + :: To enter the current time in a cell.

26. Ctrl + ;: To enter the current date in a cell.

27. Ctrl + `: To change the view from displaying cell values to formulas.

28. Ctrl + ‘: To copy the formula from the cell above.

29. Ctrl + -: To delete columns or rows.

30. Ctrl + Shift + =: To insert columns and rows.

31. Ctrl + Shift + ~: To switch between displaying Excel formulas or their values in cell.

32. Ctrl + Shift + @: To apply time formatting.

33. Ctrl + Shift + !: To apply comma formatting.

34. Ctrl + Shift + $: To apply currency formatting.

35. Ctrl + Shift + #: To apply date formatting.

36. Ctrl + Shift + %: To apply percentage formatting.

37. Ctrl + Shift + &: To place borders around the selected cells.

38. Ctrl + Shift + _: To remove a border.

39. Ctrl + -: To delete a selected row or column.

40. Ctrl + Spacebar: To select an entire column.

41. Ctrl + Shift + Spacebar: To select an entire workbook.

42. Ctrl + Home: To redirect to cell A1.

43. Ctrl + Shift + Tab: To switch to the previous workbook.