7 Favorite Microsoft Excel Keyboard Shortcuts

Keyboard Shortcuts, Microsoft Excel Tips & Tricks

Handy Excel Shortcuts

Microsoft Excel is loaded with lots of useful keyboard shortcuts for creating worksheets and formulas, formatting worksheets, and editing results, including these favorites:

  • Excel keyboard shortcuts, Excel tips and tricksCreate the SUM function: [Alt] + =
  • Insert a new worksheet: [Shift] + [F11]
  • Fill down (copy from cell above): [Ctrl] + ‘ (single quote) or [Ctrl] + D
  • Quick Print: [Ctrl] + P
  • Open the Format Cells dialog box: [Ctrl] + 1
  • Create a chart (in a chart sheet) from the selection: [F11]
  • Create a chart (embedded) from selection: [Alt] + [F1]

These are just a few of the handy tips and shortcuts you can use in Excel. Grab a handout of 100+ Excel keyboard shortcuts and find more Excel Tips & Tricks at TheSoftwarePro.com/Excel.

These Excel keyboard shortcuts work with Microsoft Excel 365, 2021, 2019, and Excel 2016.

© Dawn Bjork, MCT, MOSM, CSP®, The Software Pro®
Microsoft Certified Trainer, Productivity Speaker, Certified Speaking Professional

Excel shortcuts, Excel Tips & Tricks
Previous Post
Acrobat Comments: Reviewing Tips & Tricks for PDF Documents
Next Post
Microsoft Word: Working with the Navigation Pane

Related Posts

Categories