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 short video, we look at how to replace a typical nested IF formula with a VLOOKUP formula. Compared to nested IF statements, VLOOKUP is simpler and more transparent. It's also easier to adjust later.
In this video, we look at how to use VLOOKUP to lookup values in an Excel Table.
In this video, we'll look at how to sort with SORTBY function using a custom list. We use the custom list to specify a custom order.
In this video, we'll show how to select visible cells only.
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.