Quick, clean, and to the point

Copy selected cells

Windows shortcut 
Mac shortcut 

Copy puts everything on the clipboard: text, formulas, formatting, borders, fills, etc. Use Paste Special to selectively paste only parts of what was copied.

On the Mac, Ctrl + C also works

Related videos

The videos below demonstrate this shortcut.
One of the cool things you can do with Paste Special is make "in place" changes to numbers. This is a handy way to quickly change things like dates, prices, and times without using formulas.
In this video, we'll introduce the idea of a dynamic range and show you why you might want to use one. Spoiler: they adjust formulas automatically when data changes.
In this video, we’ll look at a couple ways to use the FILTER function to extract data between dates.
In this video, we'll look at how to create a list of random dates with the RANDARRAY function.
In this video, we'll look at a way to quickly add missing data to a worksheet. It's a simple technique using a very basic formula, and a cool example of relative cell references.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.