Mass multiply in excel

Question: I have some data in a excel sheet (see below), and want to multiply 10000 to each number in this sheet, how?

Answer: Use the function “Paste special” is the easiest way. See the pictures below, then you should grasp the method.

Any question, please let me know.

Copy the soruce data
xls_1.gif

In a new sheet, fill every grid with 1000 (or other number if you want)
xls_2.gif

Right click mouse, select “Paste special” (or access it by menu-edit-paste special)
xls_3.gif

Everything is OK
xls_4.gif


——
·本文由 iamcj 原创，采用“CC创作共用”方式共享
5月 15, 2006 | Filed Under Computer 

Comments

4 Responses to “Mass multiply in excel”

  1. Yidiot on 5月 17th, 2006 17:57

    Useful tips :)

  2. Alan on 6月 12th, 2006 13:21

    Good. Thanks CJ.

  3. Khalil on 12月 20th, 2006 4:38

    where to download excel add-ins?
    I don't have the microsoft office disks to install this function.
    Have tried searching on Microsoft online website but in vain.
    Thanks a million.

  4. iamcj on 12月 20th, 2006 14:54

    this is not a function of plugin but excel itself. In ur situation I suggest to find a office install disk (or try to find somewhere to download).

Leave a Reply