• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Tip on using Paste Values to copy data in Excel

0 Comments

Tip on using Paste Values to copy data in Excel: Excel provides users with a variety of tools for copying data. Paste Values is one of the most commonly used copy types in Excel. In this article, Buffcom.net will introduce you to how to use Paste Values to copy data in Excel.

For example, we have a data table as shown below. You can see that the Unit Price column is a function that shows the result of Sales / Quantity. At this point, if we change the value of the elements in the Sales or Quantity column, the value of the corresponding Unit Price column will also change.

Tip on using Paste Values to copy data in Excel

Tip on using Paste Values to copy data in Excel

To solve this problem, we can copy and paste the value of the data in the Unit Price column by selecting the entire Unit Price column, then pressing Ctrl + C to copy the data. Then right-click and select Paste Value to paste the data value.

The result will be the Unit Price column converted into numerical values rather than a function.

Tip on using Paste Values to copy data in Excel

Tip on using Paste Values to copy data in Excel

 

Alternatively, you can right-click and select Paste Special.

Tip on using Paste Values to copy data inThe Paste Special dialog box appears. Select Values and press OK to complete. Just like that, the cells in the Unit Price column will be converted from a function to a value.

Tip on using Paste Values to copy data inThus, the above article has instructed you on how to use Paste Values to copy data in Excel. Wish you success!

Rate this post
26
256 Views
Tip for converting column data to row data in ExcelPrevTip for converting column data to row data in ExcelApril 13, 2023
Quick tips for calculating table data in ExcelApril 14, 2023Quick tips for calculating table data in ExcelNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Internet Security 2021 1 year 5 devices key Global Kaspersky Internet Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $45.00
  • Windows Server 2022 Datacenter Key Global Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $7.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • Avast Ultimate Suite 2021 1 Year 10 Devices Global Avast Ultimate Suite 2021 1 Year 10 Devices Global
    Rated 5.00 out of 5
    $54.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
Products
  • Windows 10 Enterprise Key Global Windows 10 Enterprise Key Global
    Rated 4.82 out of 5
    $9.00
  • Windows Server 2012 Remote Desktop Services 50 USER Connections Key Global Windows Server 2012 Remote Desktop Services 50 USER Connections Key Global
    Rated 4.69 out of 5
    $25.00
  • Office 2016 Home and Student for PC Key CD Key Global Office 2016 Home and Student for PC Key CD Key Global
    Rated 4.96 out of 5
    $14.00
  • Microsoft Visio Standard 2016 Key 1PC Microsoft Visio Standard 2016 Key 1PC $9.00
  • Office 2024 Home and Student Office 2024 Home and Student $88.00
  • Windows 10 Home OEM Key Global Windows 10 Home OEM Key Global
    Rated 4.80 out of 5
    $6.00
  • Microsoft Visio 2019 professional Key Global Bind to your Microsoft Account Microsoft Visio 2019 professional Key Global Bind to your Microsoft Account
    Rated 4.96 out of 5
    $12.00
  • Microsoft SQL Server 2019 Enterprise Microsoft SQL Server 2019 Enterprise $39.00
  • Microsoft Project 2019 professional Key Global Bind to your Microsoft Account Microsoft Project 2019 professional Key Global Bind to your Microsoft Account
    Rated 4.93 out of 5
    $12.00
  • SQL Server 2019 Standard SQL Server 2019 Standard $20.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.