How to Use Paste Special in Excel & Google Sheets Read our tutorials on using Paste Special in Excel and Google Sheets. Paste Special Calculationyes Add Values to Cells and Columns Change the Signs of Values Divide Cells and Columns Multiply Cells and Columns Subtract Cells and Columns Commentsyes Copy Comments Conditional Formattingyes Apply Conditional Formatting Multiple Sheets Apply Conditional Formatting to Multiple Rows Copy Conditional Formatting Copy & Pasteyes Copy and Paste a Range or Object as a Picture Copy and Paste as Text or Value Copy and Paste Cells Copy and Paste With Skip Blanks Copy and Paste Without Borders Copy and Paste Without Changing the Format Copy Number Not Formula Excel Cannot Paste the Data Error Paste & Match Destination Formatting Paste Horizontal Data Vertically Transpose Rows to Columns Databaseyes Clean Up Data Duplicatesyes Show Only Duplicates Format Cellsyes Copy Cell Color Copy Column Widths Copy Row Height Linksyes Cross-Reference Number Formatsyes Move Decimal Places Organize Sheetsyes Pull Data From Multiple Sheets and Consolidate Save Asyes Create a Word Document Save a Table as an Image Shortcutsyes Excel Keyboard Shortcut For Paste Special Sort Datayes Sort IP Addresses Tablesyes Rotate Data Tables (Row to Column) Text to Columnsyes Split a Text Cell to Two or More Rows VBAyes Cut, Copy, & Paste from a Macro Excel VBA Ranges and Cells VBA Value Paste & PasteSpecial