Quickly copy formulas in the WPS table

Source: Internet
Author: User

I believe many friends know that you can copy formulas by dragging the fill handle. If you want to copy fewer rows, it is acceptable to copy the formula by dragging the fill handle, which is inconvenient if you want to copy too many rows. Let me introduce you to a convenient and quick way to copy a formula by double-clicking the fill handle to copy the formula.

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, as shown in Figure 1:

Figure 1

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

Figure 2

It's very convenient and quick.

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.

Figure 3

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.