We put together this list based on a survey of more than 800 Excel users.
Another very useful shortcut you’ll see me use often in this video is undo, control Z.
On a Mac, add the function key.
To cut instead of copy, use control X.
Before we try it, let’s first check the formulas on this worksheet using control + grave.
The shortcut toggles the worksheet to show all formulas, and numbers without any formatting.
Just use the same shortcut again to toggle off formulas.
Most often, paste special is used to strip out formulas and formatting.
To do that, use paste special with values.
The result is just values without formatting or formulas.
There are lots of things you’re able to do with paste special.
you might keep number formatting, but get rid of formulas.
you could keep formulas and number formats, but strip everything else.
To do this, just select a row with the formatting you want.
Copy, and use paste special with formats.
To move to the last cell in a worksheet, use control + the END key.
In this way, I can move quickly to all four corners.
To select data with these same shortcuts, just hold down the shift key.
This allows you to easily select rows, columns, and even an entire table.
When you’re in a table, you’re able to also select everything with control A.
To select entire rows, use shift plus the spacebar.
To select entire columns, use control plus the spacebar.
Again, you’ve got the option to use shift to extend the selection as needed.
Excel also has keyboard shortcuts for inserting and deleting rows and columns.
control - does the same thing with the delete dialog.
This lets you delete and insert without a dialog.
As before, control A will choose the entire table but now it won’t include the headers.
Autosum Alt = in windows and command shift equals on a Mac.
you’re able to use autosum to sum both rows and columns.
it’s possible for you to even autosum an entire table in one step.
it’s possible for you to even use fill down on multiple columns at the same time.
control enter works fine for formulas as well.
The relative cell references will update normally.
So, speaking of formulas, let’s look at a shortcut for togglingabsoluteandrelativereferences.
In this worksheet, I want to summarize sales by color, so I can use theSUMIF function.
To do that, I’ll need to enter a range and criteria, and then some range.
So to prevent this I need to lock the ranges by making them absolute.
Now when I copy the formula down, the range references are fixed properly.
Excel also has dedicated shortcuts for hiding and showing rows and columns.
Then copy and paste normally.
Just use the shortcut twice in a row.
Okay next, two shortcuts useful for formatting.
The first is format cells, or you could think of it as format anything.
Just use control 1 in Windows, or command 1 on a Mac.
you might use this shortcut to access formatting for almost anything.
And it works great for objects and charts as well so not just for cells.
So, for example, the last thing I did was apply a border.
So I can use repeat to apply the same border to the second table.
On Windows, use alt enter and on a Mac use control option return.
If you have any trouble, check that that wrap text is enabled.
