There are over 200 Excel shortcuts for both Mac and PC (you could download a PDF here).

To reverse direction, add the shift key: Control + Shift + Tab.

At that point, you’ll need to choose the throw in of paste you want to perform.

There are so many things you could do with paste special; it’s a topic in itself.

It’s all there.

But the best part is toggling off the autofilter will clear any filters that have been set.

This is far faster than fiddling with each filter manually.

Select all

Many people know the shortcut for “select all”: Control + A.

However, in Excel, this shortcut behaves differently in different contexts.

If the cursor is in an empty cell, Control + A selects the entire worksheet.

The behavior changes again when the cursor is in an Excel Table.

The first time you use Control + A, the table data is selected.

The second time, both the table data + table header are selected.

Finally, the third time you use Control + A, the entire worksheet is selected.

Modern Excel has more than 1 million rows.

You’re never going to beat it scrolling.

The best part about using Shift + Control + Arrow is that your selections are perfectly accurate.

This will bring you straight back to cell A1, no matter how far you’ve wandered.

What is the last cell?

In this case, it’s likely that there’s extra data somewhere in the worksheet.

This is a nice way to step through matches in a worksheet methodically.

By the way: to activate Find, use Control + F (Mac: Command + F).

On Windows, this will fire up the find and replace dialog with Replace selected.

Select row / select column

Both rows and columns can be selected with keyboard shortcuts.

To select a row, use Shift + Space.

To select a column, use Control + Space.

This is easily done using Control + Click (Mac: Command + Click).

Did you know you might use Go To Special to select only formulas?

you could do all that and a lot more.

Chandoo has a good article that explains Go To Special in detailhere.

Use Control + Enter when you want to enter the same value in multiple cells at once.

you’re able to even use Control + Enter to enter data into non-contiguous cells.

(See the previous shortcut for selecting non-adjacent cells.)

you’ve got the option to then apply date or time formatting as you like.

The trick is to select both the source cells and target cells before you use the shortcut.

grab the source row and the next 6 target rows.

After all, you could just select all that bling-bling in the ribbon right?

If you have data bars selected, the shortcut will pop pop the Format Data Series dialog.

it’s possible for you to also use this shortcut when working with shapes and smart art.

Each shortcut follows the same pattern: Control + Shift + [symbol].

Conspicuously absent: the Accounting format.

Then press F4 (Mac: Command + T).

Each time you apply the shortcut, Excel will “rotate” one step through relative and absolute options.

Excel will guess the range you are trying to sum and insert the SUM function in one step.

To sum multiple columns, select a range of empty cells below the columns.

Then use this shortcut.

In the world of Excel shortcuts, it doesn’t get much better than that.

By using Control + ‘, you’re able to display all formulas in a worksheet at once.

This gives you a fast way to audit a worksheet.

you could see where formulas are used and to check for consistency at the same time.

Insert function arguments

This shortcut is a bit of a sleeper.

You don’t see it mentioned much, but it’s pretty cool.

you might then double-click each argument and change it to the address or value you need.

With this shortcut F3 (no Mac equivalent so far as I know, sorry!)

you don’t need to.

The trick is to use the tab key.

With an entire row selected, this shortcut will insert a rowabovethe selected row.

With an entire column selected, this shortcut will insert a column to therightof the selected column.

you’re free to also insert multiple rows and columns.

Just grab the number of rows or columns you want to insert before using the shortcut.

With this same shortcut, you’re able to also delete multiple rows and columns.

Just choose the number of rows or columns you want to delete, then use Control + -.

Working with entire rows and columns has benefits.

Excel doesn’t care how many rows or columns you delete.

It will just silently replace deleted rows and columns with fresh copies.

Any columns that intersect the current selection will be hidden.

If you prefer, you could also first select entire columns before using this shortcut.

Note that column letters on either side of hidden columns will appear in blue.

Then use the keyboard shortcut Control + Shift + 0.

Note that you are just adding Shift to the shortcut for hiding a column.

Any rows that intersect the current selection will be hidden.

you might also first select one more entire row if you prefer.

Note that row numbers on either side of hidden rows will appear in blue.

Then use the keyboard shortcut Control + Shift + 9.

Note that you are just adding Shift to the shortcut for hiding a row.

Then use the keyboard shortcut Alt + F1 (Mac: Fn + Alt + F1).

Excel will create a new chart on the same worksheet, using your current chart’s default configs.

Then use the keyboard shortcut F11 (Mac: Fn + F11).

Excel will create a chart in a new sheet based on your current chart default parameters.

This is a great way to sanity-check data in your worksheet.

Resources to help you with Excel shortcuts: