Using Right-click Menu: Right Click in the cell where you want to paste, and then select paste special.Īll these three options would open a Paste Special dialogue box, as shown below:.Using Keyboard Shortcut: Use the Excel Paste Special Shortcut – Alt + E + S + V.

This will open the Excel Paste Special Dialogue box. Using the Ribbon: Go to Home –> Clipboard –> Paste –> Paste Special.Once you copy it, here are three different ways to access paste special in Excel: The first step is to copy the cells that you want to paste. There are a couple of ways you can access the Excel Paste Special features. You can’t do that with a simple copy paste but you can do that using Excel Paste Special functionality in Excel. It copies not only the content of the cell but also the format such as background color, font color, borders(as shown below).īut what if you want to copy only the cell contents and not the formatting, or only the formatting and not the values, or only the formula within it? What happens when you copy a cell in excel and paste it somewhere else? Understanding Excel Paste Special Dialogue Box.

Where is transpose button in excel