How to enable paste special in excel

Copying and Pasting data is one of the most performed actions in Excel. There is a lot more to copy-pasting than a simple Control + C and Control + V.

In this tutorial, you will learn all about the Excel Paste Special feature and useful Excel Paste Special Shortcuts.

What is Excel Paste Special?

What happens when you copy a cell in Excel and paste it somewhere else?

It copies not only the content of the cell but also the format, such as background color, font color, and borders (as shown below).

But 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?

You can’t do that with a simple copy-paste, but you can do that using Excel Paste Special functionality in Excel.

Accessing Excel Paste Special Options?

There are a couple of ways you can access the Excel Paste Special features.

The first step is to copy the cells that you want to paste.

Once you copy it, here are three different ways to access Paste Special in

how to copy paste values in excel with filter

how to copy paste values in excel using keyboard