Excel removes a formula that retains a value

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.