How to copy values ​​in Excel

In Excel software, the company has provided a lot of Functions so that users can calculate quickly and accurately. But the use of functions and formulas makes it very difficult for users to copy values ​​in Excel. In this article, the Software Tips will guide you how to copy values ​​in Excel.

How to copy values ​​in Excel Picture 1

1. Copy the function in Excel

In Excel, if we use the usual Copy-Paste method (Ctrl + C - Ctrl + V) , you will copy the entire contents of that cell including the function.

For example , the software tips will copy cell E4 using the Product function.

How to copy values ​​in Excel Picture 2

When we paste it, there is no value but only a function. This is because when Excel Copy only copies each function and applies it to the next cell.

How to copy values ​​in Excel Picture 3

And when the function is applied to the next cell but has no content, it has no value.

How to copy values ​​in Excel Picture 4

2. How to copy values ​​in Excel

To copy values ​​in Excel you need to do the following:

Step 1: First, you just need to use the normal Copy operation (Ctrl + C) .

How to copy values ​​in Excel Picture 5

Step 2: Then when you paste (Ctrl + V) , you will see there is an Options icon (Options Paste) next to it.

How to copy values ​​in Excel Picture 6

Step 3: Here you are interested in the Paste Values section ( Paste Values ). You choose the option according to your needs.

1. 123: Paste value
2. % 123: Paste the value and number format
3. Pen 123: Paste values ​​and source formats

How to copy values ​​in Excel Picture 7

When selecting the Paste Values mode , we will paste the correct value as required.

How to copy values ​​in Excel Picture 8

So in this article, the Software Tips showed you how to copy values ​​in Excel. Good luck!