These options enable you to paste selectively. So let’s learn more about these options: Paste Options in the Paste Special Dialogue Box: If you have a good grip on these Excel Paste Special options, it can save you a lot of time (and you know time is money!).
However, when you go through these, it makes a lot of sense to have these options available. It could be overwhelming to see so many options for something as simple as copying and pasting in Excel. Understanding Excel Paste Special Dialogue Box
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.