Use Paste Special to selectively paste only parts of what was copied.

On the Mac, Ctrl + X also works

The videos below demonstrate this shortcut.

Video thumbnail for Shortcuts to cut copy paste

Video thumbnail for Why VLOOKUP is better than nested IFs

Video thumbnail for How to move data in Excel

Video thumbnail for How to make an exact copy of a formula

Video thumbnail for 10 pivot table problems and easy fixes