35 Best Excel Keyboard Shortcuts
Excel is a powerful program. While its interface has evolved and gone through many changes over the years, there have always been two ways to work in Excel. You can use your mouse or you can use Excel keyboard shortcuts.
In the current version of Excel, most commands are accessible via the Ribbon but, if you really want to work efficiently, you need incorporate a few keyboard shortcuts into your repertoire.
File Management Shortcuts
Knowing how to create a new workbook, save a file, or print the active worksheet using keyboard shortcuts will save a lot of time over the course of each day.
|CTRL + N||Create a new workbook|
|CTRL + O||Open a workbook|
|CTRL + S||Save the current workbook|
|F12||Display the Save As dialog box|
|CTRL + P||Print the active worksheet|
|CTRL + F4||Close the current workbook|
|ALT + F4||Close Excel|
Using keyboard commands whenever possible will help you stay focused on your data and boost speed and accuracy.
|TAB||Move one cell to the right|
|SHIFT + TAB||Move one cell to the left|
|ENTER||Move down one cell|
|SHIFT + ENTER||Move up one cell|
|RIGHT ARROW||Move one cell to the right|
|LEFT ARROW||Move one cell to the left|
|DOWN ARROW||Move down one cell|
|UP ARROW||Move up one cell|
|PgDn||Move one screen down|
|PgUp||Move one screen up|
|ALT + PgDn||Move one screen right|
|ALT + PgUp||Move one screen up|
|CTRL + PgDn||Go to next worksheet|
|CTRL + PgUp||Go to previous worksheet|
|CTRL + HOME||Move to cell A1|
|CTRL + END||Move to last cell in worksheet|
|F5||Display Go To dialog box|
Modifying data in your worksheet is fast and easy using these Excel keyboard shortcuts. If you’re like me, you’ll likely use these shortcuts on a daily basis.
|CTRL + A||Select entire worksheet|
|CTRL + Z||Undo|
|CTRL + Y||Redo|
|CTRL + X||Cut|
|CTRL + C||Copy|
|CTRL + V||Paste|
|CTRL + F||Find|
|CTRL + H||Replace|
Excel Keyboard Shortcuts Make a Difference
I hope you find my list of Excel keyboard shortcuts useful. I didn’t want to include every shortcut available. These are just the Excel shortcuts I use every day. At first glance, the list may seem overwhelming but try to incorporate one or two shortcuts at a time.
When you enter data into an Excel worksheet, instead of clicking with your mouse to select the next cell, press TAB or ENTER. If you make a mistake, press SHIFT + TAB or SHIFT + ENTER to go back. The next time you need to copy data from one workbook to another, use CTRL + C to copy and CTRL + V to paste. Need to save your workbook? Press CTRL + S. Any effort that you put into learning these shortcuts will pay big dividends over time. You’ll work more efficiently in Excel and your confidence will soar!
Let me know how you’re doing with your new newfound Excel expertise. Have these keyboard shortcuts saved you any time? Are there any Excel keyboard shortcuts I should add to my list? Answer in the comments below!