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

To take a snapshot of a range not formatted as an Excel table using the Linked Picture tool, select the data, press Ctrl+C to copy it, and click "Linked Picture" in the Paste drop-down menu.

If you have a bunch of rows or columns in Excel that need to be updated with a math operation, instead of applying a formula or editing each cell, save some time by using Paste Special. The ...