Current location - Information Consultation Platform - Information Consulting - Is there any other way to copy a large amount of data in excel besides dragging with the mouse to select and then copy?

Is there any other way to copy a large amount of data in excel besides dragging with the mouse to select and then copy?

Method 1. Double-click fill handle to fill it. If the previous column has multiple rows, it will be the same.

Method 2: first enter the formula to be filled, press SHIFT+CTRL+ Arrow keys, and then press Ctrl+D. ..

Method 3: press SHIFT+CTRL+ arrow keys, enter the formula in the edit field, and then press CTRL+ ENTER.

Method four. Enter the range to be filled in the name box (for example, A 1:A54000). Enter the formula to be copied in the formula editing field and press CTRL+ ENTER.

Method 5: Select the grid to be filled, press CTRL+C (copy the first cell with formula), then move the mouse to the name box, directly enter the column interval, such as B3:B 10000, press ENTER, and then press CTRL+V (click location-right-click paste).

Related articles