Over 100 Excel Shortcut Keys Just For You

By | October 5, 2024

There are over 100 Excel shortcut keys available for you to learn. Make your work faster by learning these amazing shortcut keys for your spreadsheet application.

Using the mouse can be faster jumping from one place in a spreadsheet to the other, but sometimes it gets annoying if you have to line up the cursor right before moving.

Sometimes, it is not just the mouse line up but you just don’t know where to locate certain tools.

I will be using lots of spreadsheet terms in my presentation. If you are not familiar with Excel, quickly check my previous article on Excel terms.

Watch and read this article guide here carefully about on over 100 Excel Shortcut Keys Just For You available in 2022.

Ctrl Excel Shortcut Keys Combination

  1. Ctrl + A – Select All
  2. Ctrl + B – Bold
  3. Ctrl + C – Copy
  4. Ctrl + D – Fill
  5. Ctrl + F – Find
  6. Ctrl + G – Find next instance of text
  7. Ctrl + H – Replace
  8. Ctrl + I – Italic
  9. Ctrl + K – Insert a hyperlink
  10. Ctrl + N – New workbook
  11. Ctrl + O – Open
  12. Ctrl + P – Print
  13. Ctrl + R – Nothing right
  14. Ctrl + S – Save
  15. Ctrl + U – Underlined
  16. Ctrl + V – Paste
  17. Ctrl + W – Close
  18. Ctrl + X – Cut
  19. Ctrl + Y – Redo
  20. Ctrl + Z – Undo
  21. Ctrl + : – Insert the current time
  22. Ctrl + ; – Insert the current date
  23. Ctrl + “ – Copy the value of the cell above
  24. Ctrl + ‘ – Copy the formula from the cell above
  25. Ctrl + ` – Change views to display formulas
  26. Ctrl + – – Delete selected column or row
  27. Ctrl + F3 – Set name
  28. Ctrl + F4 – Close
  29. Ctrl + F5 – XL, size of the restore window
  30. Ctrl + F6 – Next Workbook Window
  31. Ctrl + F7 – Move window
  32. Ctrl + F8 – Resize Window
  33. Ctrl + F9 – Minimize the workbook
  34. Ctrl + F10 – Maximize or Restore Window
  35. Ctrl + F11 – Inset 4.0 Macro sheet
  36. Ctrl + F1 – Open File
  37. Ctr + 0 – Hide column
  38. Ctrl + 1 – Format cell contents
  39. Ctrl + 5 – Strikethrough
  40. Ctrl + 8 – Show outline symbol
  41. Ctrl + 9 – Hide row
  42. Ctrl + ` – Toggle value / display of the formula
  43. Ctrl + Shift + A – Insert the argument names in the formula
  44. Ctrl + Shift + F3 – Create a name using the names of row and column labels
  45. Ctrl + Shift + F6 – Previous Window
  46. Ctrl + Shift + F12 – Printing
  47. Ctrl + Shift + = – Insert columns and rows
  48. Ctrl + Shift + ~ – General Format
  49. Ctrl + Shift + 0 – Unhide Column
  50. Ctrl + Shift + 1 – Apply comma formatting
  51. Ctrl + Shift + 2 – Apply time formatting
  52. Ctrl + Shift + 3 – Apply date formatting
  53. Ctrl + Shift + 4 – Apply currency formatting
  54. Ctrl + Shift + 5 – Apply percentage formatting
  55. Ctrl + Shift + 7 – Thicken border of selected cell
  56. Ctrl + Shift + 9 – Unhide row

Shift Excel shortcut Keys Combination

  1. Shift – Offset Adjustment for Additional Functions in the Excel Menu
  2. Shift + F1 – What is it?
  3. Shift + F2 – Edit cell comment
  4. Shift + F3 – Paste the function into the formula
  5. Shift + F4 – Search Next
  6. Shift + F5 – Find
  7. Shift + F6 – Previous Panel
  8. Shift + F8 – Add to the selection
  9. Shift + F9 – Calculate the active worksheet
  10. Shift + F10 – Popup menu display
  11. Shift + F11 – New spreadsheet
  12. Shift + F12 – Save
  13. Shift + Ctrl + F6 – Previous Workbook Window

Alt Key combination

  1. Alt + A – Select Data tab
  2. Alt + H – Select Home tab
  3. Alt + M – Select Formulas tab
  4. Alt + N – Sletct Inert tab
  5. Alt + P – Select Page Layout tab
  6. Alt + Q – Jump to search
  7. Alt + R – Select Review tab
  8. Alt + W – Select View tab
  9. Alt + Y – Select Help tab
  10. Alt + Enter – Start New line
  11. Alt + F1 – Insert a graph
  12. Alt + F2 – Save As
  13. Alt + F4 – Output
  14. Alt + F8 – Macro dialog
  15. Alt + F11 – Visual Basic Editor
  16. Alt + Shift + F1 – New spreadsheet
  17. Alt + Shift + F2 – Save
  18. Alt + = – AutoSum
  19. Alt + down arrow – automatic view list
  20. Alt + ‘ – Format Style Dialog
  21. Alt + 1 – Autosave on
  22. Alt + 2 – Save work
  23. Alt + F + C – Save and close
  24. Alt + F + E – Export
  25. Alt + F + Z – Share workbook
  1. Use Arrow keys to move Left, Right, Up, or Down.
  2. Tab – Move Right
  3. Shift + Tab – Move left
  4. Enter – Move down
  5. Shift + Enter – move up
  6. Ctrl + Arrow keys will move to the end of the page

Function Keys

  1. F1 – Help
  2. F2 – Edition
  3. F3 – Paste the name
  4. F4 – Repeat the last action
  5. F4 – When entering a formula, switch between absolute/relative references
  6. F5 – Go to
  7. F6 – Next Pane
  8. F7 – Spell Check
  9. F8 – Extension of the mode
  10. F9 – Recalculate all workbooks
  11. F10 – Activate Menubar
  12. F11 – New graph
  13. F12 – Save As

Conclusion

These are not all the shortcut keys in Excel. But these ones will help you go a bit faster.

Since the online version of Excel works in a browser, it is likely some of the shortcuts will work for the browser instead of Excel.

Thanks for reading our useful guide about Over 100 Excel Shortcut Keys Just For You in 2022.

There are also combinations that demand that you have data on your sheet before they will work.

Leave a Reply

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