How to make sales list with excel

1. First, create and open an Excel table, as shown in the figure, and enter the title and text of the sales list. The font of the title "Commodity Sales Details" is set to Song Ti, with a font size of 20, and the merged cell is centered. Center the body text and pull the column width to the appropriate position.

2. Then select column A where the date is located, right-click the selected column A, and click Cell Format in the pop-up menu. In the small window in cell format, select the date in the number and the appropriate date on the right, and then click the OK button at the bottom of the small window.

3. Next, enter the formula "= unit price * discount" in the cell under the discount price, and then drop down the cell under the discount to make the formula fill other cells under the discount.

4. After that, enter the formula "= quantity * discount price" in the cell under the amount, and then drop down the cell under the amount to make the formula fill other cells under the amount.

5. Finally, select the column where the discount price and amount are located at the same time, right-click, click Set Cell Format, select the currency in the number into the appropriate currency form in the small window of cell format, and then click OK.