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!
You should read it
- Instructions on how to copy formulas in Excel
- How to copy data from Excel to Word?
- How to copy Word data to Excel keeps formatting
- Instructions for copying or moving Worksheet in Excel 2013
- Filter data that doesn't overlap in Excel - Filter for unique values in Excel
- Instructions on how to copy charts from Excel to Word
- How to copy sheet from Excel file to another Excel file
- How to automatically calculate and copy formulas in Excel
- how to fix error cannot copy data in Excel files
- How to convert a CSV file to Excel
- How to Copy Formulas in Excel
- MS Excel 2007 - Lesson 4: Working with data
May be interested
How to fix font errors in Word when downloading documents online
How to make a border frame in Word
How to put pages in Word, collapse text in Word
How to number a PDF page, add pages to the PDF file
How to add and insert non-symbols in Word (Ø symbol in Word)
Shortcuts Save As in Word, Excel, Powerpoint