How to bulk modify data on rows and columns on an Excel table

Source: Internet
Author: User

Step one, you need to modify a column of data minus 20, first in a blank column to enter 20 values, For example, insert 20 on the G1 column. Then move the mouse off the marker to the lower-right corner of the 20 cell, and a small cross will appear, and then drag directly down after it becomes a cross, which automatically enters the value of a column that is all 20. As shown in the figure:

Step two, the mouse right click G column, pop-up window select "Copy", the list of G all copied up. As shown in the figure:

Computer Tutorials

Step three, after the completion of the copy, such as you need to the F1 list of all the data minus 20, the right mouse click on the f column, in the pop-up window select "Paste", as shown in the picture:

After the step four, will pop up the selective Pasting dialog box, under the operation clicks selects "The subtraction", then clicks "OK" can. As shown in the figure:

Step five, and then to compare the previous F of the value of the above is found in the list above the value of all minus 20, and finally delete the G1 item. Of course, there are other settings on the Paste option, which can be set according to the user's needs. As shown in the figure:

How to bulk modify data on rows and columns on the
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: and provide relevant evidence. A staff member will contact you within 5 working days.