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.

123: Paste value
% 123: Paste the value and number format
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!

Kareem Winters

Update 19 May 2020

You should read it

May be interested

How to Copy Formulas in Excel
the excel program has a feature that makes it easy for users to copy formulas for entire rows or columns, but you don't always get the results you want. when you receive results that are not as expected or encounter #ref and /div0 errors, you will definitely feel unhappy. don't worry, though - you don't need to edit every cell in a 5,000-line spreadsheet. this article will provide some simple ways to help you copy formulas to other cells.
MS Excel 2007 - Lesson 4: Working with data
excel allows you to move, copy and paste cells and text fields through cut and paste or copy and paste.
The way to sum the same codes in Excel
excel has developed a powerful and useful tool for adding values that satisfy one or more conditions, the sumif and sumifs functions. but which formula to find the sum of values with cells with the same code snippet? this is a very interesting question that many readers send to dexterity software. find out how in the following article.
Copy, copy data in Excel
with similar data or formats, instead of having to enter them all in turn, copying (copying) data in excel is very necessary. using the methods of copying data, you can quickly copy data, formulas, formatting ...
How to write fractional values in Excel $How to write fractional values in Excel$
sometimes you enter fractions into excel data cells but it shows the time format. you do not know how to handle the input data is displayed as a fraction.
Introducing how to use the CONVERT function in Excel in the most detail
when working in excel, you may encounter a situation where your spreadsheet has many blank cells and need to fill in values in those cells. don't worry, read the article below which will introduce the convert function in excel to learn how to quickly fill in values into blank cells in excel spreadsheets.
MINA and MAXA functions in Excel
use the mina () and maxa () functions to find the minimum and maximum values in a list of values that include logical values and numerical representations in text in a reference.
How to use PDF Anti-copy to protect PDF files
pdf anti-copy is software that protects pdf files, preventing the ability to copy all data, even when converting pdf files to word or excel.
MODE.MULT function - The function returns a vertical array of the most common values in Excel
mode.mult function: the function returns a vertical array of the most frequently occurring values, or repeating values in an array or data range. support functions from excel 2010 onwards. syntax: mode.mult ((number1, [number2], ...)
MS Excel - Lesson 5: Excel formulas and functions
the formula in excel is a program that performs calculations on data tables. these formulas perform very precise operations such as adding, multiplying, or comparing values in worksheets.