Essential Keyboard Shortcuts for Excel To Save You Time

Learning keyboard shortcuts for Excel might feel slower at first if you’re used to a mouse, but it’s worth the effort. These shortcuts can make your work faster and more efficient over time.

Here are some useful Excel shortcuts to help you work smarter on your Excel spreadsheets.

What are Keyboard Shortcuts?

Keyboard shortcuts are key combinations that let you complete tasks quickly without using a mouse. They make it easier to work faster and cut down on repetitive actions. For Excel users, learning shortcuts is a smart way to speed up common tasks and improve workflow.

Essential Microsoft Excel Shortcuts

Essential Microsoft Excel Shortcuts

Here are the Excel shortcuts cheat sheet every user should know to work faster.

Navigating a Workbook

  • Move to the top or bottom cell of current area – Ctrl + up/down arrow
  • Move to the next non-blank cell in a row – Control + left/right arrow
  • Previous/next worksheet – Ctrl + Page Up/Page Down
  • Go To specific cell reference – Ctrl + G
  • Jump to cell A1/first non-frozen cell – Ctrl + Home
  • Jump to last used cell – Ctrl + End
  • Redo last action – Ctrl+Y

Selecting Cells

  • All cells containing data above or below the current cell – Ctrl + Shift + up/down arrow
  • All cells containing data to the left or right of the current cell – Ctrl + Shift + left/right arrow
  • All cells in a current region – Ctrl + Shift + 8
  • Current column – Ctrl + Space
  • Current row – Shift + Space

Working with Worksheets

  • Add new worksheet – Shift + F11
  • Duplicate worksheet – Hold Ctrl + drag sheet left or right
  • Copy cell contents – Ctrl+C
  • Move data to another sheet – Hold Alt + drag data to another sheet
  • Insert row/column (depending on selection) – Ctrl + (or Ctrl + Shift =)
  • Delete row/column (depending on selection) – Ctrl –
  • Group consecutive worksheets – Click first; Shift + click last
  • Group non-consecutive worksheets – Click first; Ctrl + click next
  • Unhide a hidden row – Ctrl+Shift+(

Working with Data or Formatting Data

  • Open cell for editing – F2
  • AutoSum numbers before current cell – Alt=
  • Add/remove filters – Ctrl + Shift + L
  • Insert current date (static) – Ctrl ;
  • Insert current time (static) – Ctrl + Shift ;
  • Underline text or remove underline – Ctrl + 4

Benefits of Using Shortcuts in Excel

Benefits of Using Shortcuts in Excel

Using shortcuts in Excel can significantly improve efficiency and streamline workflows.

  • Reducing time using functions
  • Navigating easily to different tabs or cells
  • Creating new elements quickly
  • Removing or adding formatting or characters easily
  • Adding formulas and other elements with ease

Take a Course to better your Excel Knowledge and Get Certified

Improve your Excel skills with Vantage 365 Training. Microsoft Excel foundation course focuses on shortcuts, advanced functions, and data management techniques to help you work smarter.

Sign up today and get certified to stand out in the workplace.

FAQs

How do I see all keyboard shortcuts in Excel?

To see all keyboard shortcuts in Excel, press Alt to display shortcut hints on the ribbon. You can also find a full list of shortcuts on the Microsoft Excel support page or press Ctrl + / in some versions of Excel. This gives you a clear overview of useful shortcuts to save time and work smarter.

What are F1 to F12 in Excel?

The F1 to F12 keys in Excel offer useful shortcuts to speed up your work:

  • F1: Opens the Help pane.
  • F2: Edits the active cell.
  • F3: Opens the “Paste Name” box (if names are defined).
  • F4: Repeats the last action or locks cell references in formulas.
  • F5: Opens the “Go To” box.
  • F6: Switches between worksheet panes or open workbooks.
  • F7: Checks spelling.
  • F8: Turns on “Extend Selection” mode.
  • F9: Recalculates all worksheets in open workbooks.
  • F10: Activates the menu bar or ribbon shortcuts.
  • F11: Creates a chart from selected data.
  • F12: Opens the “Save As” box.

What is Ctrl + F8 in Excel?

Shift + F8 lets you add a non-adjacent cell or range to your current selection using the arrow keys. Handy when working with scattered data that needs selecting without losing what you’ve already highlighted.

How can I create my own Excel shortcuts?

To create your own Excel shortcuts, use the Quick Access Toolbar or macros. To add a command to the Quick Access Toolbar, right-click the command in the ribbon and select “Add to Quick Access Toolbar.” For more advanced tasks, create a macro by going to the “View” tab, selecting “Macros,” and then “Record Macro.” Assign a shortcut key during this process, and once recorded, your shortcut will perform the actions set in the macro. This can save time and make repetitive tasks easier.

How do I manage shortcuts in Excel?

To manage shortcuts in Excel, you can adjust the Quick Access Toolbar or Ribbon to include the commands you use most often. To change the Quick Access Toolbar, click the dropdown arrow at the end of it and select “More Commands.” From there, you can add or remove commands. To customise the Ribbon, right-click it and select “Customise the Ribbon.” This lets you add tabs, groups, or commands to suit your workflow. Setting up Excel in this way makes it easier to access shortcuts and work more efficiently.

How many Excel shortcuts are there?

Microsoft provides a full list of keyboard shortcuts for both Windows and macOS. While basics like Ctrl+C (copy) and Ctrl+V (paste) are widely used, others like Ctrl+Shift+L to toggle filters or F4 to repeat the last action can be real time-savers. The number of shortcuts depends on your Excel version and operating system, but there are plenty to help make your workflow more efficient.

Shopping Basket