You can Cut or Copy Paste Columns and Rows in Excel spreadsheet - and keep the formulas and formatting using this step-by-step guide.

Excel's Linked Picture tool lets you take a snapshot of some data and paste it as an image—handy if you're compiling a dashboard of the key metrics from across your workbook.