How to Copy Values in Excel

This guide explains how to copy Values in Excel, with clear steps, practical tips, and important checks before you begin.

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.

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.

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

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) .

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

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

• 123: Paste value
• % 123: Paste the value and number format
• Pen 123: Paste values and source formats

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

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