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 ...

How to Paste From PDF Format to Excel. The PDF extension is a file format used by Adobe Reader, a free software program. However, PDF files are read-only, which means you cannot edit them.

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