Buzz
When dealing with similar data or formats, instead of manually entering each piece, the importance of copying data in Excel cannot be overstated. Utilizing various data copying techniques allows you to quickly copy data, formulas, and formats.
Explore various methods for copying data in Excel through this article.
Copying Data
In addition to using the Copy (Ctrl + C) and Paste (Ctrl + V) commands to copy data in Excel, you can swiftly copy data using the mouse.
1. Use the left mouse button.
Step 1: Select the data range you want to copy.
Step 2: Move the mouse pointer to the bottom right corner of the selected data range, and the + sign will appear.
Step 3: Hold down the left mouse button and drag them to the positions you want to copy.
Afterward, release the mouse pointer.
2. Use the right mouse button.
Step 1: Select the data range you want to copy.
Step 2: Move the mouse pointer to the bottom right corner of the selected data range, ensuring the mouse pointer turns into a + sign.
Step 3: Hold down the right mouse button and drag the mouse to the desired position to copy, then release the mouse pointer.
Step 4: After releasing the mouse pointer, a dialog box will appear for you to choose the copy options.
Copy cells: copy both data and formatting of the selected cells.
Fill Series: increase the numerical order of data type within the copied cell's data sequence.
Fill Formatting Only: only copy the formatting of the cell.
Fill Without Formatting: copy the data without copying the formatting.
Copy formulas
To copy formulas, use the most common method by selecting the formula you want to copy and pressing Copy, then paste (Ctrl + P).
You can also use the mouse to copy formulas, and the formula will adjust parameters based on where you paste it. For example:
After using the mouse to copy formulas, you'll have similar formulas, and the parameters within the formula will adapt accordingly.
Copy displayed data
For instance, suppose you have a data range hidden from row 6 to row 9, and you only want to copy the displayed data in the Sheet, excluding the hidden data. Follow these steps:
Step 1: Select the displayed data range you want to copy.
Step 2: Press the Alt + ; keys (Alt key and semicolon key).
Step 3: Press Ctrl + C to copy the data.
Step 4: Click the mouse at the desired paste location and press Ctrl + P to paste the data, ensuring only the newly displayed data is copied.
Hope these methods of copying data above will be helpful to you. With the specified requirements, you can apply data copying techniques as needed. Wish you success!
