Cart 0

Some Handy Excel Keyboard Shortcuts

Posted by Roger Hyttinen on

Many people find that once they learn some basic shortcut keys in Excel, they can fly through their work at a much faster pace. Having a few of these under your belt without having to remove your hands from the keyboard constantly to reach for your mouse, can make you much more productive. Try memorizing a few at a time to get started to see if they’ll make a difference in your workflow.

Here are a few of them that you might helpful:

Ctrl + Delete - deletes the current select or selection
F2 - places your cursor in the Formula bar
F11 - creates a chart from the selected data
Shift + F3 - opens a formula window
Ctrl + Shift + + - Inserts cells or selections
Ctrl + Space - selects the current column
Shift + Space - selects the current row
Ctrl + Arrow key - moves to the next occupied cell in the direction of the arrow
Alt + Enter - inserts a new line within a cell
Ctrl + K - inserts a hyperlink
Ctrl + F - inserts a search box from where you can search your worksheet for data

Here’s a few shortcuts to quickly format cells:

Ctrl + Shift + 1 - formats the cells as a number with commas and 2 decimal places
Ctrl + Shift + 4 - formats the cells as currency
Ctrl + Shift + 5 - formats the cells as a percentage
Ctrl + ; - inserts the current data in a cell in m/d/yyyy format.

Share this post

← Older Post Newer Post →