Microsoft Excel keyboard shortcuts everyone should know

If you use 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 some basic keyboard shortcuts you 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 these Windows 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 can 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 these tips 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 these Excel tricks that can also improve your workflow.