Blog

Over and over again, students in my classes ask for a list of keyboard shortcuts and I?ve never seen the need to write them out. I mean, [CTRL]+B for Bold, and [CTRL]+I for Italic? Easy, right? In fact, most Microsoft Office users know those standard formatting and text editing shortcuts.

But, I did find a few keyboard shortcuts that ?WOW? students in every Excel class.

AutoSum [ALT] + =
Copy Data Above [CTRL] + ? (apostrophe)
Create a Chart F11
Display a Drop-Down List [ALT] + Down Arrow Key
Insert Current Date [CTRL] + ;
Increment a Single Number [CTRL] + Drag AutoFill Handle
Insert a Line Break in a Cell [ALT] + [ENTER]
Move One Worksheet Tab (right) [CTRL] + Page Down
Move One Worksheet Tab (left) [CTRL] + Page Up

I hope you enjoy these shortcuts. There are, of course, hundreds of additional keyboard shortcuts, but these few will definitely enhance your Excel productivity.

Subscribe to the KeyStone OnDemand blog to be the first to learn about future Microsoft Excel training tips.