#393 10 Excel Shortcuts You Should Know

If you know me, you know I am a huge fan of keyboard shortcuts.  If you do any work at all in Excel here are 10 great ones that will save you time.

1. CTRL+1 – Format

Need to format something? Just press CTRL + 1 and you’ll be instantly transported to the formatting options you need. The best part is this trick works for just about everything including cells, charts and more!

2.  F2 – Edit a cell

No need to leave the keyboard to double-click a cell for editing. F2 is all you need.

3. CTRL+Arrow keys – Navigate your worksheet

There’s no need for endless scrolling when you can use the CTRL+arrow key trick. Using this keyboard combo will jump you to the last populated cell in that direction.

You can also use CTRL+SHIFT+arrow keys to quickly select a whole range of cells.

4. F4 – Toggle cell references between relative and absolute

This one let’s you skip manually typing in the $ when you need an absolute cell reference. Keep hitting the F4 key to cycle through relative, mixed and absolute cell reference options.

5. ALT+ES – Paste Special > Values

When copying data from another source using Paste Special – Values will leave all the unwanted formatting, formulas, etc behind and keep your data nice and clean. Here are loads more things you can do with copy & paste tricks like this.

6. F3 – Show Names

If you ever use range names in your workbooks you’ll like this one. Just press F3 and you get a list of all the defined names. Pick one and press ok to add it to the formula you are typing. Super fast and handy.

7. CTRL+K – Add Hyperlink

Select a cell, shape, etc press CTRL+K to open the hyperlink box then enter the destination URL or location. This one also works in Word and PowerPoint.

8. CTRL+T – Insert Table

Excel Tables are awesome and they can make things much easier in Excel. Just select any cell in a range of related data, and press CTRL+T to make it table.  If you’re not familiar with them go here now and see what you’re missing. You’ll be glad  you did!

9. CTRL+S – Save

From the better safe than sorry department, use CTRL + S to quickly save your work.

10. CTRL+SHIFT+L – Turn on/ off filters

I love filters but sometimes clearing each filter can be a pain. This shortcut lets you turn-off and turn-on the filters super fast.

Did you learn any news ones from this list? Which of your favorites did I miss? Leave a comment and let me know.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s