WPS Table Double-click the fill handle to copy the formula

Source: Internet
Author: User

Friends who often use the WPS form should use the drag fill handle to copy the formula, which can be used to cope with the smaller number of replicated rows, but if there are too many duplicate rows, consider another method. Here is a small compilation of how to quickly copy formulas.

I share this technique with my friends by using an example of a simple quick copy formula.


A, B, C represent a group of numbers, each group of 100, in the form of a, B, c the number represented by the formula "A+B-C" calculated, and displayed. Enter the number of a, B, and C you want to calculate in the table first, and then enter the formula "=A2+B2-C2" at Cell D2, and then use any other location with the mouse when you enter the formula, and the results are displayed at cell D2.

What about the remaining numbers to be calculated according to the formula "A+b-c"? One input to the corresponding formula, which is too troublesome and the stupidest method; Drag the fill handle at the cell D2, but with so many groups, it's cumbersome. A simpler and quicker way to do this is to double-click the fill handle at the cell D2.

With cell D2 selected, move the mouse over the padding handle at the lower-right corner of the cell.

The mouse turns black cross, double click, look, the remaining number of all according to the formula "A+b-c" calculate well.

In fact, double-click the mouse can not only quickly copy the formula, can be used to quickly fill the column, and the left key drag fill handle effect, just in the column to fill the previous column to have content, the previous column of the contents to which row, double-click the fill handle will be automatically filled to the line. Looking at the 3,d column is the data that is automatically populated by double-clicking the fill handle at the cell D1, and the same row in column C is no longer populated.

The above is a small series for you to introduce another way to copy a formula, double-click the fill handle to copy the formula. I believe that after the above study, in the operation of the formula table, more or less can encounter this kind of situation. I hope the above content is helpful to you.

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.