Home Tutorials Videos Q&A MCQ Shortcuts Exercises Appointment Login
Lesson 12 of 22 – MS Excel Shortcut Keys
60%

MS Excel Shortcut Keys

MS Excel shortcut keys help users work faster by reducing mouse usage and improving productivity while creating and managing spreadsheets.

Note: Most Excel shortcut keys work in Microsoft Excel 2016, 2019, 2021, and Microsoft 365.
What are MS Excel Shortcut Keys?

MS Excel shortcut keys are keyboard combinations used to perform tasks such as editing data, formatting cells, and navigating worksheets quickly.

  • Save time.
  • Increase productivity.
  • Reduce mouse usage.
  • Easy spreadsheet management.
Common MS Excel Shortcuts
Shortcut Function
Ctrl + N Create a new workbook.
Ctrl + O Open a workbook.
Ctrl + S Save workbook.
Ctrl + P Print workbook.
Ctrl + W Close workbook.
Ctrl + F Find data.
Editing Shortcuts
Shortcut Function
Ctrl + C Copy selected cells.
Ctrl + X Cut selected cells.
Ctrl + V Paste copied cells.
Ctrl + Z Undo last action.
Ctrl + Y Redo action.
Ctrl + A Select entire worksheet.
Navigation and Formatting Shortcuts
Shortcut Function
F2 Edit the active cell.
F4 Repeat last action or toggle absolute references.
Ctrl + Home Go to the beginning of the worksheet.
Ctrl + End Go to the last used cell.
Ctrl + Arrow Keys Move to the edge of a data region.
Ctrl + Shift + L Turn filters on or off.
Ctrl + 1 Open Format Cells dialog box.
Alt + = Insert AutoSum formula.
Advantages of MS Excel Shortcut Keys
  • Work faster with spreadsheets.
  • Improve accuracy and efficiency.
  • Reduce dependence on the mouse.
  • Quickly navigate large worksheets.
  • Simplify calculations and formatting.
  • Increase productivity in office work.
  • Save valuable time.
Key Points
  • Ctrl + S saves the workbook.
  • F2 edits the active cell.
  • Ctrl + Home moves to the first cell.
  • Ctrl + End moves to the last used cell.
  • Ctrl + Shift + L applies filters.
  • Alt + = inserts AutoSum.
  • Ctrl + 1 opens the Format Cells dialog.
  • Excel shortcuts improve speed and productivity.

🧠 Quiz

Which shortcut key is used to insert the AutoSum formula in MS Excel?



← Previous Next →