Once the desired cell is selected, we must use the shortcut key Ctrl + Alt + V to launch Paste Special dialogue. It is important to note that we can also select the same cell that we copied to remove the formula and keep only the resultant values.
To paste the formulas and number formats like the currency, date formats, symbols, etc. To only paste the column width from the copied source. To paste all the cell contents without the borders. To paste all the contents in the same theme formatting as per the source cell. To only paste the data validation configurations. To paste only comments associated with a cell. To copy or paste the cell formats without the values. To only paste the values without formulas. To paste the cell contents with formatting. Once we have the copied data in the clipboard, we can use the following shortcuts and use Paste Special feature in Excel: However, we must have copied something to paste. That means that we can access the Excel Paste Special feature by using different shortcuts.
#EXCEL SHORTCUT KEYS PASTE SPECIAL VALUES HOW TO#
How to use Paste Special in Excel?Įxcel offers multiple ways to access any feature, which is also the same for the Excel Paste Special. However, Excel Paste Special feature allows us many more options like this while pasting data in the sheet.Īlso, one of the main advantages of using the Paste Special feature is that we can use all the Paste Special options within a single sheet or in different sheets and workbooks if needed. For example, we can copy contents with formulas and paste only the values in any specific cell without formulas in it. We can either paste only desired elements of the copied contents or perform a specific mathematical operation with the copied contents accordingly. The Paste Special feature in Excel offers a wide range of options to help users paste data differently. This article discusses the Excel Paste Special feature and corresponding Excel Paste Special Shortcuts with examples.