1. First, tidy up the table. For example, sort out the cost price in the table and multiply it by 1.5. Let's talk about using functions first.

2. In the column after the price, in the top cell D2, enter the symbol equal to "=", and then click the C2 cell or enter C2.

3. Enter C2 and multiply it by "*" symbol. This is flexible. You can add, subtract, multiply and divide according to the price adjustment requirements. Just enter the corresponding symbol.

4. After inputting the corresponding symbols, just fill in the interval you want to adjust at the back. For example, now we need to adjust 1.5 times, and after multiplication, just fill in 1.5.

5. After the price adjustment function is completed, click Enter directly to get the result.

6. So far, a price adjustment has been completed. The following is very simple. Just put it down. Note that the mouse is placed at the small black dot in the lower right corner of the cell.

7, the mouse will appear solid cross, and then directly drop down, the function will automatically fill in, so the price of a column is adjusted.