Microsoft Office Excel shortcut keys

Microsoft Office Excel shortcut keys

Short Key Description
Alt+Enter Next line
Shift+F3 Open the formula window.
Shift+F5 Show search box.
Ctrl+Shift+; Current time.
Ctrl+; Curernt date.
Alt+Shift+F1 Insert New Worksheet.
F2 Edit the cell as selected.
F4 Repeat the last action.
F5 Move to a specific cell. 
F7 Spelling checking
F11 Create chart from the selected data.
Ctrl+1 Show Format Cells window.
Ctrl+A Select all full contents
Ctrl+B Bold the text
Ctrl+I Italic the text
Ctrl+K Insert the link.
Ctrl+S To save
Ctrl+U Underlining the text.
Ctrl+D Fill down.
Ctrl+R Fills the cell to the right with the contents of the selected cell.
Ctrl+1 Change the format of selected cells.
Ctrl+5 Strikethrough the  text
Ctrl+P To print
Ctrl+Z Undo the last action.
Ctrl+F9 Minimize the current window.
Ctrl+F10 Maximize currently selected window.
Ctrl+F6 Switch between windows or open workbooks.
Ctrl+Shift+1 Format the number in comma format.
Ctrl+Shift+4 Format the number in currency format.
Ctrl+Shift+3 Format the number in date format.
Ctrl+Shift+5 Format the number in a percentage format.
Ctrl+Shift+6 Format the number in scientific format.
Ctrl+Shift+2 Format the number in time format.
Ctrl+Tab Move 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 key Move to next section of text.
Shift+Space Select entire row.
Ctrl+Home Move 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+Home Move to cell A1.
Ctrl+Space Select entire column.
Ctrl+Page up
Move between worksheets in the same document.
Ctrl+Page down Move 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

Add a Comment