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 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, 2019, 2016, Excel 2013, and Excel 2010.

By Dawn Bjork, MCT, MOSM, The Software Pro®
Microsoft Certified Trainer, Productivity Speaker, Software Consultant

,
Previous Post
More Microsoft Excel ROUND Functions: Tools for Accurate Results
Next Post
Microsoft Word Tricks: 3 Simple Ways to Keep Text Together

Related Posts

Menu