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. The following table displays the shortcut key to select the desired option from a Paste Special dialogue box: Shortcut Key After the dialogue box is displayed, we can select the desired options from the box via a specific keyboard button instead of using a mouse. Understanding Excel Paste Special Options and Shortcut KeysĪs we discussed above, we can access all the Paste Special options directly from the Paste Special dialogue box via keyboard shortcut Ctrl + Alt + V. The following is the image of the Paste Special dialogue box: Note: We can also access right-click menu options by using the keyboard shortcut Shift + F10. The Paste Special dialogue box contains many options that we can select either by using the mouse buttons or via the associated keyboard shortcut key. The best part is that we can hover over any of the options on the popup window to see a live preview of the contents, like how they will be pasted on the selected cell with the corresponding option.Īll three shortcuts typically launch a Paste Special dialogue box. This will instantly open a small popup window with almost 14 paste special options. To access more, we need to hover on the Paste Special option on the list. In the above image, we can see that some of the commonly used options (such as Paste everything, Paste values, Paste Formulas, Transpose, Paste formatting, and Paste link) appear directly in the right-click menu above the Paste Special option. Next, we must select the Paste Special from the list to access all the relevant options of pasting. We need first to select a specific cell where we want to paste the content and then right-click on it. Specifically, we need to navigate to the Home tab, click on the drop-down icon under the Paste tool, and then select the Paste Special option from the list.Īlternately, we can use the Paste Special shortcut directly from the right-click menu list. Alt + E, then S (works with all Excel versions)Īnother simple method of using the Paste Special feature involves the use of shortcuts present on the ribbon.Ctrl + Alt + V (works with Excel 2007 and higher).To access Paste Special feature and paste a specific aspect of contents from the clipboard, we can use any of the following two shortcuts: Excel has a wide range of keyboard shortcuts. The best and quickest method to access Paste Special feature is to use the keyboard shortcuts. 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. 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. The Paste Special Feature typically extends the operations when pasting anything in Excel. It allows us to choose which formatting (source or destination) style we want to keep, or we only need the values or formulas rather than any formatting. It is not just limited to copy-pasting using the simple shortcuts Ctrl + C and Ctrl + V.Įxcel Paste Special is the feature in Excel that helps us make the pasting operation more useful. Although copy-paste in Excel is easy, it has many additional options too for pasting. Copying and pasting are among the most used tasks in MS Excel as it helps use data from different sheets or the web instantly. MS Excel is one of the widely used spreadsheet programs that helps organize and manipulate vast amounts of data. Next → ← prev Excel Paste Special Shortcut
0 kommentar(er)
