Microsoft Office Excel shortcut keys

By: Prof. Dr. Fazal Rehman Shamil | Last updated: February 17, 2024

Microsoft Office Excel shortcut keys

Short KeyDescription
Alt+EnterNext line
Shift+F3Open the formula window.
Shift+F5Show search box.
Ctrl+Shift+;Current time.
Ctrl+;Curernt date.
Alt+Shift+F1Insert New Worksheet.
F2Edit the cell as selected.
F4Repeat the last action.
F5Move to a specific cell. 
F7Spelling checking
F11Create chart from the selected data.
Ctrl+1Show Format Cells window.
Ctrl+ASelect all full contents
Ctrl+BBold the text
Ctrl+IItalic the text
Ctrl+KInsert the link.
Ctrl+STo save
Ctrl+UUnderlining the text.
Ctrl+DFill down.
Ctrl+RFills the cell to the right with the contents of the selected cell.
Ctrl+1Change the format of selected cells.
Ctrl+5Strikethrough the  text
Ctrl+PTo print
Ctrl+ZUndo the last action.
Ctrl+F9Minimize the current window.
Ctrl+F10Maximize currently selected window.
Ctrl+F6Switch between windows or open workbooks.
Ctrl+Shift+1Format the number in comma format.
Ctrl+Shift+4Format the number in currency format.
Ctrl+Shift+3Format the number in date format.
Ctrl+Shift+5Format the number in a percentage format.
Ctrl+Shift+6Format the number in scientific format.
Ctrl+Shift+2Format the number in time format.
Ctrl+TabMove between 2 or more open Excel files.
Alt+=Create a formula to sum all of the above cells.
Ctrl+’Insert the value of the above cell into the cell currently selected.
Ctrl+Arrow keyMove to next section of text.
Shift+Space
Select entire row.
Ctrl+HomeMove to cell A1.
Ctrl+~Switch between showing Excel formulas or their values in cells.
Ctrl+-Delete the selected column or row.
Ctrl+Shift+=Insert a new column or row.
Ctrl+~Switch between showing Excel formulas or their values in cells.
Ctrl+HomeMove to cell A1.
Ctrl+SpaceSelect entire column.
Ctrl+Page upMove between worksheets in the same document.
Ctrl+Page downMove between worksheets in the same document.

Read More 

  1. Microsoft Word MCQs
  2. Microsoft Excel MCQs

  3. Microsoft Office shortcut keys

  4. Microsoft access Solved MCQ’s

  5. MS Access MCQs

  6. Microsoft PowerPoint MCQs

  7. Microsoft Word MCQs

  8. Microsoft Windows and Office MCQs

  9. Microsoft Windows MCQs

  10. Basic MS Office MCQs

  11. Ctrl+A short key  use in MS Word
  12. Difference between Ionic Bonds and Covalent Bonds
  13. Difference between Acids and Bases
  14. Ctrl+N short key  use in MS Word
  15. Ctrl+C short key  use in MS Word
  16. Ctrl+O short key  use in MS Word
  17. Ctrl+S short key  use in MS Word
  18. Ctrl+W short key  use in MS Word
  19. Ctrl+X short key use in MS Word 
  20. Ctrl+B short key  use in MS Word
  21. Ctrl+E short key  use in MS Word
  22. Ctrl+I short key  use in MS Word
  23. Ctrl+L short key use in MS Word
  24. Ctrl+Left bracket ([) short key  use in MS Word
  25. Alt+Shift+C short key use in MS Word
  26. Ctrl+Alt+S short key  use in MS Word
  27. Ctrl+R short key  use in MS Word
  28. Ctrl+Right bracket (]) short key  use in MS Word
  29. Ctrl+U short key  use in MS Word
  30. Ctrl+V short key  use in MS Word
  31. Ctrl+Y short key  use in MS Word
  32. Ctrl+Z short key  use in MS Word
  33. Esc short key  use in MS Word
  34. alt a-short-key-use-in-ms-excel
  35. Alt+H short key use in MS Excel
  36. Alt+M short key use in MS Excel
  37. Alt+N short key  use in MS Excel
  38. Alt+P short key use in MS Excel
  39. Alt+W short key use in MS Excel
  40. Ctrl+ W short key  use in MS Excel
  41. Ctrl+0 short key use in MS Excel
  42. ctrl9-short-key-use-in-ms-excel
  43. Ctrl+B short key use in MS Excel
  44. Ctrl+C short key use in MS Excel
  45. Ctrl+O short key  use in MS Excel
  46. Ctrl+S short key  use in MS Excel
  47. Ctrl+V short key use in MS Excel
  48. Ctrl+X short key  use in MS Excel
  49. Ctrl+Zshort key  use in MS Excel
  50. Delete short key  use in MS Excel
  51. Shift+F10 short key use in MS ExcelComputer Science Repeated MCQs Book Download

Leave a Reply