To copy the contents and the formatting, choose All merging conditional formats. To combine your copied formats with existing conditional formats in the paste area, click the Merge Conditional ...

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.

With Paste Special in Microsoft Excel, you can copy and paste more than a cell's contents or formatting. Indeed, you can also duplicate a cell's comment or note in another cell.