Excel shortcuts

Excel shortcuts | Keyboard shortcuts in Excel

Here, I can provide you with some Excel shortcuts that can help you work more efficiently:

Keyboard shortcuts in Excel

Excel shortcuts | Keyboard shortcuts in Excel

Sure, here is a comprehensive list of Excel keyboard shortcuts:

  1. Ctrl + A: Select all cells in the current worksheet
  2. Ctrl + B: Bold selected cells or text
  3. Ctrl + C: Copy selected cells or text
  4. Ctrl + D: Fill down from the selected cell
  5. Ctrl + E: Flash fill based on the selected examples
  6. Ctrl + F: Open the “Find” dialog box to search for specific content in your worksheet
  7. Ctrl + G: Open the “Go To” dialog box to jump to a specific cell or range
  8. Ctrl + H: Open the “Replace” dialog box to replace specific content in your worksheet
  9. Ctrl + I: Italicize selected cells or text
  10. Ctrl + K: Create a hyperlink
  11. Ctrl + N: Create a new workbook
  12. Ctrl + O: Open an existing workbook
  13. Ctrl + P: Print the current worksheet
  14. Ctrl + R: Fill right from the selected cell
  15. Ctrl + S: Save the current workbook
  16. Ctrl + U: Underline selected cells or text
  17. Ctrl + V: Paste copied cells or text
  18. Ctrl + W: Close the current workbook
  19. Ctrl + X: Cut selected cells or text
  20. Ctrl + Y: Redo previous action
  21. Ctrl + Z: Undo previous action
  22. Ctrl + 1: Open the “Format Cells” dialog box
  23. Ctrl + 9: Hide selected rows
  24. Ctrl + 0: Hide selected columns
  25. Ctrl + Shift + #: Apply date formatting to the selected cells
  26. Ctrl + Shift + $: Apply currency formatting to the selected cells
  27. Ctrl + Shift + %: Apply percentage formatting to the selected cells
  28. Ctrl + Shift + &: Apply border to the selected cells
  29. Ctrl + Shift + _: Remove the border from the selected cells
  30. Ctrl + Shift + ~: Apply the default number format to the selected cells
  31. Ctrl + Shift + F: Open the “Find and Replace” dialog box
  32. Ctrl + Shift + P: Open the “Format Cells” dialog box for the selected cells
  33. Ctrl + Shift + L: Toggle the “Filter” command for the current range
  34. Ctrl + Shift + O: Select all cells with comments
  35. Ctrl + Shift + U: Expand or collapse the formula bar
  36. Alt + =: Insert a sum formula for the selected cells
  37. Alt + Enter: Insert a line break within a cell
  38. Alt + F1: Create a chart of the selected data
  39. Alt + F4: Close Excel
  40. F2: Edit the content of the selected cell
  41. F4: Repeat the last action
  42. F5: Open the “Go To” dialog box
  43. F7: Spell-check the selected text or cell range
  44. F11: Create a new chart based on the selected data
  45. Ctrl + F2 : Print Preview

These are just a few of the many Excel shortcuts available, but they should help you get started with increasing your productivity.

Fore More Post

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

Your email address will not be published. Required fields are marked *