If youuse Microsoft Excel, you know that this robust spreadsheet application offers tons of features and functions. By using keyboard shortcuts for the most common actions, you have more time to focus on the formulas, calculations, and other data you’re working with.
These lists give you shortcuts for everyday actions you’d perform. Plus, they use simple key combinations that are easy to remember.
Common Excel keyboard shortcuts
For the most common actions you may perform in an Excel workbook, these keyboard shortcuts are good ones to keep in mind. And they work in other Microsoft Office applications on Windows like Word and PowerPoint.
Navigating an Excel workbook
There are somebasic keyboard shortcutsyou can use in Microsoft Excel for navigating your active sheet and the workbook. These can save you time from having to grab your mouse or use your trackpad.
Tip: Interested in more ways to work faster? Check out theseWindows shortcuts you might not know about.
Moving around a spreadsheet
Zipping around your current worksheet is much easier with these keyboard shortcuts. Whether you want to move up and down or zoom in and out, you’ll do it quickly.
Selecting cells and sheets
When you want to work with selections, you may use the following shortcuts. Not only can you select columns and rows, but you can also extend your selections with key combinations.
Tip: Want to become an Excel pro? Look at thesetips and tricks to master your Excel spreadsheets.
Formatting cells and data
After you use the above shortcuts to make selections, you can format the cells with the list below. You can manipulate text, data, and cells, open the formatting dialogue boxes, and more.
Using the Function keys
One more list of shortcuts that you should check out is for the Functions keys. Without remembering a key combination, you can perform quick actions with a simple click.
Hopefully, these lists of keyboard shortcuts for Excel have you on your way to doing things quicker in your workbooks and spreadsheets. For more, check out theseExcel tricks that can also improve your workflow.
