Paste or apply the same column width that you have copied from the selected cells. Paste all the contents without borders that you have copied the contents with borders. Paste all the contents along with source theme formatting from the selected data in the cells, which are applied with theme format from the layout tab. Paste only data validation that you have applied to the contents from the Data tab, in the Data Tools group. Paste only comments which are applied to the cells.
Paste only formatting (not content) that you have copied from the selected data. Paste the content without the formula that you have copied the contents from the selected range. Paste the unformatted content with formulas that you have copied the contents from the selected range.
Paste all data with all formatting that you have copied the contents from the selected range. Paste Special in MS-Excel | Paste Special Shortcuts in Excel Paste Special Option Right click on the worksheet, then select the Paste Special after copying the selected content from the cell.Īfter opening the Paste Special dialogue box as in the picture above, use the shortcut keys given below to paste any content format that you have copied the content from the range of cells.On the Home tab, in the clipboard group, Click the expand arrow of the Paste and then, select the Paste Special after copying the selected content from the cell.Press CTRL + Alt + V, after copying the selected content from the cell.To Launch the Paste Special Feature Dialogue Box in excel, do one of the following. Or use the table of contents to navigate easily (given below the picture). Paste Special in MS-Word is explained after completion of the Paste Special and its Shortcuts in excel. To use Paste Special feature in excel, follow the shortcut keys given below the picture. Also, you can add, multiply, subtract, or divide a specific number to the selected range of cells in a worksheet. Using this feature, you can paste several formats like formulas, values, comments, data validation, number formats. The Paste special is a feature, used to paste the copied contents in a specific format.