Keyboard Shortcuts

Even if you’re familiar with Microsoft Excel, you might be surprised by the number and variety of keyboard shortcuts you can use to speed up your work and generally make things more convenient.

Now, does anyone expect you to memorize all these keyboard combos? Of course not! Everyone’s needs are different, so some will be more useful to you than others. And even if you pick up a few new tricks, it’s worth it. The following list is clean and simple, and is divided by four categories of useful shortcuts: Basic, Moving, Selecting, and Formula Shortcuts.

All of the following enable you to execute your tasks more efficiently with your keyboard instead of your mouse.

Basic

 

Select cells

1. To select the entire range, press CTRL + a (if you press CTRL + a one more time Excel selects the entire sheet).

2. To copy the range, press CTRL + c (to cut a range, press CTRL + x).

3. Select cell A6 and press CTRL + v to paste this range.

4. To undo this operation, press CTRL + z

Moving

 

1. To quickly move to the bottom of the range, hold down CTRL and press ↓

2. To quickly move to the right of the range, hold down CTRL and press →

Try it yourself. Hold down CTRL and press the arrow keys to move from edge to edge.

Selecting

1. To select cells while moving down, hold down SHIFT and press ↓ a few times.

2. To select cells while moving to the right, hold down SHIFT and press → a few times.

Formulas

 

1. To quickly insert the SUM function, press ATL + =, and press Enter.

2. Select cell, hold down SHIFT and press ↓ two times.

3. To fill a formula down, press CTRL + d (down).

Note: in a similar way, you can fill a formula right by pressing CTRL + r (right).