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.
In this video, we look at how to simulate a random drawing to pick winners in a contest with Excel, using the RAND and RANK functions together.
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 how to build a 100% stacked column chart that shows the percentages in each bar.
In this video, we'll look at how to copy and lock structured references in a formula. Structured references are a special syntax used by Excel Tables.
In this video, we'll look at how to use the HLOOKUP function. HLOOKUP works like VLOOKUP, but is meant for data in a horizontal arrangement.