Excel in the flexible use of the right button drag to complete a very fast copy

Source: Internet
Author: User

In an Excel worksheet, we often copy data from one cell or range to another location. There are many ways to replicate Excel tabular data, most fundamentally by using the Copy/Paste command in the Edit menu or right mouse button, or by using the shortcut keys CTRL + C and CTRL + V. In fact, there is a little-known way, so that we can use the most time-saving and labor-saving operation to achieve rapid data replication. The following example introduces this technique to you.

1. For example, we want to copy the contents of the a13:e21 shown in Figure 1 to the a1:e9. First select A13:e21.

Figure 1

2. Move the mouse pointer over the black border of the selected area until the mouse pointer changes to the shape shown in Figure 2.

Figure 2

3. Then press the right mouse button to drag the mouse, when moved to A1:e9, release the right button, appear as shown in Figure 3 menu, click "Link here."

Figure 3

This enables a quick copy of the selection, as shown in Figure 4.

Figure 4

Extrapolate: Careful readers will notice that, as shown in Figure 3, there are many other commands in the right-click menu that are related to replication and movement, and can be implemented using the methods described above if you want to implement these related operations later.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.