Excel Yourself/Excel Keyboard Shortcuts

Excel Keyboard Shortcuts

Yes you may be really good with the mouse, but sometimes it is quicker to use the keyboard.

When I ran some face to face training sessions recently I was reminded how much people LOVE keyboard shortcuts. So I thought I would update my keyboard shortcut session.

Using the mouse isn’t always the quickest way to perform tasks in Excel. Keyboard shortcuts can speed up your work and save you hunting through screens and dialogs. Some of the keyboard shortcuts you will learn in this session are:
  • wrap text and other useful formats
  • applying row and column grouping
  • selecting a table quickly
  • copying visible cells only
  • apply and remove Freeze Panes
  • returning after following a hyperlink
  • how to avoid an annoying feature of formula and reference dialogs when you press an arrow key to move around
  • get the most out of the Tab key
There will be lots of other shortcuts as well. Even if you prefer using the mouse you might learn a few useful new techniques.

  • Free

Excel Keyboard Shortcuts

Speed up your Excel work with better keyboard shortcuts.

Contents

Excel Keyboard Shortcuts

Yes you may be really good with the mouse, but sometimes it is quicker to use the keyboard.

When I ran some face to face training sessions recently I was reminded how much people LOVE keyboard shortcuts. So I have updated my keyboard shortcut session.

Using the mouse isn’t always the quickest way to perform tasks in Excel. Keyboard shortcuts can speed up your work and save you hunting through screens and dialogs. Some of the keyboard shortcuts you will learn in this session are:
  • wrap text and other useful formats
  • applying row and column grouping
  • selecting a table quickly
  • copying visible cells only
  • apply and remove Freeze Panes
  • returning after following a hyperlink
  • how to avoid an annoying feature of formula and reference dialogs when you press an arrow key to move around
  • get the most out of the Tab key
There will be lots of other shortcuts as well. Even if you prefer using the mouse you might learn a few useful new techniques.
Contents

    Course Materials

     The session materials
    • a pdf manual which you can print out and make notes in
    • Excel file to work through during the session
    • the completed file to review if you need to
    Excel keyboard shortcuts 2020.pdf
    • 271 KB
    Excel Keyboard Shortcuts 2020.xlsx
    • 122 KB
    Excel Keyboard Shortcuts 2020 completed.xlsx
    • 127 KB

    Course Videos

    I added an extra video to cover two shortcuts that i missed in the session.
    Excel Keyboard Shortcuts Video
    • (1h 01m 22s)
    • 245 MB

    Course Quiz

    Excel Keyboard Shortcuts: Quiz