Excel removes a formula that retains a value

Excel removes a formula that retains a value

The author gives a simple example of a simple formula data, after the first two columns, of course, we will have more copies of the formula, but the principle is the same.

We select and then click on the right button to copy, we use the shortcut key to copy also can, as shown.

After copying, we click on the right button, paste it, paste selectively, select the properties of the data value paste, as shown. This removes the formula and retains only the data.

In addition to the right button, we can also from the start-"paste the following small arrows, optional to paste, as shown." Simply select the attribute icon that we want.

Optionally, select Paste below, as shown in the figure.

Then select the value and click OK, as shown in figure.

This pasted data, the pure value, there is no formula. As pictured.