Print all Excel Keyboard Shortcuts

November 04, 2021 - by Bill Jelen

Problem: Is there a complete list of keyboard shortcuts?

Strategy: There are many lists floating around the Internet, but the easiest source is right in Excel help.

Press F1 to open Excel Help. Search Excel help for “Keyboard Shortcuts”. The resulting article lists all of the keyboard shortcuts. Scroll to the bottom and choose Open in Browser. You can then print with Ctrl+P.

Or, copy and paste to Excel. After adjusting column widths, you will have a worksheet of the shortcuts.

Problem: I have to do a certain command 20 times in a row. Even with keyboard shortcut keys, it is several keystrokes over and over.

Strategy: Most people know F4 as the shortcut to toggle dollar signs within a reference while you are editing a formula. When you are not editing a formula, F4 will repeat the last command. Use the shortcut keys to perform the first command, and then use F4 to repeat the command. In some cases, you can use the arrow key to move to the next cell, then press F4 to apply the same formatting as the previous command.

This article is an excerpt from Power Excel With MrExcel

Title photo by Juan Gomez on Unsplash