50 excel shortcuts


SUBMITTED BY: tyk786

DATE: June 19, 2022, 5:21 a.m.

FORMAT: Text only

SIZE: 2.8 kB

HITS: 400

  1. 1. Ctrl + N: To create a new workbook.
  2. 2. Ctrl + O: To open a saved workbook.
  3. 3. Ctrl + S: To save a workbook.
  4. 4. Ctrl + A: To select all the contents in a workbook.
  5. 5. Ctrl + B: To turn highlighted cells bold.
  6. 6. Ctrl + C: To copy cells that are highlighted.
  7. 7. Ctrl + D: To fill the selected cell with the content of the cell right above.
  8. 8. Ctrl + F: To search for anything in a workbook.
  9. 9. Ctrl + G: To jump to a certain area with a single command.
  10. 10. Ctrl + H: To find and replace cell contents.
  11. 11. Ctrl + I: To italicise cell contents.
  12. 12. Ctrl + K: To insert a hyperlink in a cell.
  13. 13. Ctrl + L: To open the create table dialog box.
  14. 14. Ctrl + P: To print a workbook.
  15. 15. Ctrl + R: To fill the selected cell with the content of the cell on the left.
  16. 16. Ctrl + U: To underline highlighted cells.
  17. 17. Ctrl + V: To paste anything that was copied.
  18. 18. Ctrl + W: To close your current workbook.
  19. 19. Ctrl + Z: To undo the last action.
  20. 20. Ctrl + 1: To format the cell contents.
  21. 21. Ctrl + 5: To put a strike through in a cell.
  22. 22. Ctrl + 8: To show the outline symbols.
  23. 23. Ctrl + 9: To hide a row.
  24. 24. Ctrl + 0: To hide a column.
  25. 25. Ctrl + Shift + :: To enter the current time in a cell.
  26. 26. Ctrl + ;: To enter the current date in a cell.
  27. 27. Ctrl + `: To change the view from displaying cell values to formulas.
  28. 28. Ctrl + ‘: To copy the formula from the cell above.
  29. 29. Ctrl + -: To delete columns or rows.
  30. 30. Ctrl + Shift + =: To insert columns and rows.
  31. 31. Ctrl + Shift + ~: To switch between displaying Excel formulas or their values in cell.
  32. 32. Ctrl + Shift + @: To apply time formatting.
  33. 33. Ctrl + Shift + !: To apply comma formatting.
  34. 34. Ctrl + Shift + $: To apply currency formatting.
  35. 35. Ctrl + Shift + #: To apply date formatting.
  36. 36. Ctrl + Shift + %: To apply percentage formatting.
  37. 37. Ctrl + Shift + &: To place borders around the selected cells.
  38. 38. Ctrl + Shift + _: To remove a border.
  39. 39. Ctrl + -: To delete a selected row or column.
  40. 40. Ctrl + Spacebar: To select an entire column.
  41. 41. Ctrl + Shift + Spacebar: To select an entire workbook.
  42. 42. Ctrl + Home: To redirect to cell A1.
  43. 43. Ctrl + Shift + Tab: To switch to the previous workbook.
  44. 44. Ctrl + Shift + F: To open the fonts menu under format cells.
  45. 45. Ctrl + Shift + O: To select the cells containing comments.
  46. 46. Ctrl + Drag: To drag and copy a cell or to a duplicate worksheet.
  47. 47. Ctrl + Shift + Drag: To drag and insert copy.
  48. 48. Ctrl + Up arrow: To go to the top most cell in a current column.
  49. 49. Ctrl + Down arrow: To jump to the last cell in a current column.
  50. 50. Ctrl + Right arrow: To go to the last cell in a selected row.

comments powered by Disqus