Teach you how to increase the data in an Excel table by 20%

Just came to the office in the morning, service manager Guo found me, said that the work of printing yesterday needs to be readjusted, each unit price is up 20%, because the type of car more than 200 pages, more than waste ink. I asked the boss, he said that the increase in the work is approved by the boss, since the boss agreed, I have no reason to not reprint a good work.

Since my computer was bought in 2000, regardless of the speed and other aspects are relatively slow, with the marketing department just bought the computer, so the efficiency may be high, in the process of setting up the table, the marketing department of Linda asked me how this increase 20% is set, she asked to write down this setup process, In order to forget the good to have a query information emergency. I simply write down the process of the increase, although relatively simple, but this is just engaged in the form of personnel, after the need to raise prices or cut prices or anything can be used as a reference.

1. Add the number 1.20 to the right margin of each cell in the Excel table that you want to raise data uniformly. As shown in Fig. 1

(Note: The data in the back cell must be 1.20, not 1.2.) Must be consistent with the number of digits following the decimal point that you want to raise the data before. If it's not 1.20, select the cell with the Uniform add number, right-click-Set cell format-numeric-ok (Figure 2)

As shown in Fig. 2