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.
This video shows how you can replace formulas with the results they return, a useful way to stop Excel from calculating new results.
In this video, we look at how to combine the FIND function with the LEFT function to extract the first name from a full name using a formula.
In this video, we’ll look at a couple ways to use the FILTER function to extract data between dates.
Pivot tables are very easy to create, but they still present challenges. In this video, we look at how to identify and fix 10 common pivot table problems.
This video shows you how to use two text functions, CLEAN and TRIM, to strip extra spaces and remove line breaks from text.