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 .
The article shows some ways to copy data in Excel, you can refer.
Data copy
In addition to copying data cells in Excel, use the Copy command (Ctrl + C) and the Paste command (Ctrl + V). You can use the mouse to copy data cells quickly.
1. Use the left mouse button.
Step 1: Select the data area to be copied.
Step 2: Move the cursor to the bottom right corner of the selected data area, there appears a + sign .
Step 3: Hold down the left mouse button and drag them to the locations to copy.
Then release the mouse cursor.
2. Use the right mouse button.
Step 1: Select the data area to be copied.
Step 2: Move the mouse pointer to the bottom right corner of the selected data area so that the cursor becomes a + sign .
Step 3: Hold down the right mouse button and drag the mouse to the position to copy then release the mouse cursor.
Step 4: After releasing the mouse cursor, a dialog box will appear giving you the option to copy.
Copy cells: copy data cells (data and format).
Fill Series: increase the order of numeric data contained in the data series in the copied cell.
Fill Formatting Only: only copy the format of the cell.
Fill Without Formatting: copy data without copying the format.
Copy the formula
To copy the formula you use the most common way is to select the formula to copy and press Copy and then paste (Ctrl + P).
You can also use the mouse to copy the formula, the formula will be changed arguments according to the position you paste. For example:
After using the mouse to copy the formula, you will get the same formulas and the arguments in the formula will be changed accordingly.
Copy the data being displayed
For example, you have hidden data ranges from row 6 to row 9, you just want to copy the data shown in the Sheet Sheet and hidden data does not copy. You do the following:
Step 1: Select the data area being displayed to be copied.
Step 2: Press the key combination Alt + ; (Alt key and semicolon).
Step 3: Press Ctrl + C to copy data.
Step 4: Select the mouse where you want to paste the data and press Ctrl + P to paste the data, so only the displayed data is copied.
Hopefully the above data copying methods will be useful to you, with the requirements you can apply how to copy the data accordingly. Good luck!
You should read it
- How to copy data from Excel to Word?
- how to fix error cannot copy data in Excel files
- Instructions on how to copy formulas in Excel
- Instructions for copying or moving Worksheet in Excel 2013
- MS Excel 2007 - Lesson 4: Working with data
- How to copy Word data to Excel keeps formatting
- How to copy data on a laptop?
- How to copy values in Excel
- How to copy sheet from Excel file to another Excel file
- How to use PDF Anti-copy to protect PDF files
- Instructions to copy data from Excel to Word retain the format
- Tools to speed up data copying on Windows for free
Maybe you are interested
How to get data from web into Excel
What information does a VPN hide? How does it protect your data?
How to transfer data between 2 Google Drive accounts
6 Data Collecting Apps You Need to Delete for Better Privacy
How to master numerical data in Google Sheets with the AVERAGE function
How to delete white space in a table in Word - Appears right below the data