Home / Computer / Microsoft Excel Keyboard Shortcuts

Microsoft Excel Keyboard Shortcuts

Last updated:
WhatsApp Channel Join Now
Telegram Channel Join Now

Microsoft Excel is a powerful spreadsheet application with many keyboard shortcuts to help you work more efficiently. Here are some commonly used Excel keyboard shortcuts:

Here are some commonly used Excel keyboard shortcuts in a tabular form:
Action Shortcut
Navigation Shortcuts
Move one cell up Arrow Up
Move one cell down Arrow Down
Move one cell left Arrow Left
Move one cell right Arrow Right
Move to the edge of data region Ctrl + Arrow Key (Up, Down, Left, Right)
Move to the beginning of the row Home
Move to the beginning of the worksheet Ctrl + Home
Move to the last cell of data region Ctrl + End
Move to the last cell of the worksheet Ctrl + Shift + End
Selection Shortcuts
Select the entire worksheet Ctrl + A
Select an entire row Shift + Space
Select an entire column Ctrl + Space
Select adjacent cells Shift + Arrow Key (Up, Down, Left, Right)
Extend the selection Shift + (Arrow Key or Click)
Editing Shortcuts
Cut selected cells Ctrl + X
Copy selected cells Ctrl + C
Paste copied/cut cells Ctrl + V
Undo Ctrl + Z
Redo Ctrl + Y (or Ctrl + Shift + Z)
Insert a new worksheet Shift + F11
Delete the selected cells/rows/columns Ctrl + – (minus key)
Fill down (copy cell value down) Ctrl + D
Fill right (copy cell value to the right) Ctrl + R
Formatting Shortcuts
Format cells dialog Ctrl + 1
Bold text Ctrl + B
Italicize text Ctrl + I
Underline text Ctrl + U
Apply number format Ctrl + Shift + ! (Exclamation Mark)
Increase font size Ctrl + Shift + > (Greater Than)
Decrease font size Ctrl + Shift + < (Less Than)
Miscellaneous Shortcuts
AutoSum (Sum selected cells) Alt + =
Toggle formula cell reference style F4 (when editing a formula)
Open the “Save As” dialog F12
Start a new line within a cell Alt + Enter
Toggle between worksheet tabs Ctrl + Page Up (Previous Tab) or Ctrl + Page Down (Next Tab)
Also Read:  Microsoft Word Keyboard Shortcuts

These are just a few of the many Excel keyboard shortcuts available. Learning and using keyboard shortcuts can significantly improve your productivity when working with Excel.

Basic Navigation:
  • Arrow keys: Move the active cell in the direction of the arrow key.
  • Tab: Move to the next cell to the right.
  • Shift + Tab: Move to the previous cell to the left.
  • Enter: Move to the cell below.
  • Shift + Enter: Move to the cell above.
  • Ctrl + Arrow keys: Jump to the edge of data regions.
  • Ctrl + Home: Go to the beginning of the worksheet.
  • Ctrl + End: Go to the last cell containing data.
Also Read:  What is Microsoft Word explain?
Selecting Cells:
  • Shift + Arrow keys: Select a range of cells.
  • Ctrl + Space: Select the entire column of the active cell.
  • Shift + Space: Select the entire row of the active cell.
  • Ctrl + A: Select the entire worksheet.
Editing Cells:
  • F2: Edit the active cell.
  • Ctrl + X: Cut selected cells.
  • Ctrl + C: Copy selected cells.
  • Ctrl + V: Paste copied or cut cells.
  • Ctrl + Z: Undo the last action.
  • Ctrl + Y: Redo the last undone action.
  • Delete: Clear the contents of selected cells.
  • Ctrl + Backspace: Clear the contents of the active cell.
  • Ctrl + \”-\” (minus key): Delete the selected cells.
Formatting:
  • Ctrl + B: Bold text.
  • Ctrl + I: Italicize text.
  • Ctrl + U: Underline text.
  • Ctrl + 1: Format cells dialog box.
  • Ctrl + 5: Apply or remove strikethrough.
  • Ctrl + Shift + L: Add or remove bullet points.
  • Ctrl + 9: Hide selected rows.
  • Ctrl + 0 (zero): Hide selected columns.
Also Read:  What is Database Management System (DBMS)?
Working with Worksheets:
  • Ctrl + Page Up: Move to the previous worksheet.
  • Ctrl + Page Down: Move to the next worksheet.
  • Alt + E, S, V: Paste special.
  • Ctrl + F6: Switch between open workbooks.
Formulas and Functions:
  • = (equals sign): Start a formula.
  • F4: Repeat the last action in a formula.
  • Ctrl + Shift + Enter: Enter an array formula.
  • Alt + Equals: AutoSum.
  • Ctrl + ` (backtick): Show or hide formula values.
Miscellaneous:
  • Ctrl + S: Save the workbook.
  • Ctrl + N: Create a new workbook.
  • Ctrl + O: Open an existing workbook.
  • Ctrl + P: Print the workbook.
  • Ctrl + F: Find text within the worksheet.
  • Ctrl + H: Replace text within the worksheet.

These are just a selection of the many keyboard shortcuts available in Excel. Using shortcuts can significantly speed up your work and make you more productive in Excel.

Leave a comment