How to make orders, invoices and warehouse inventory with excel?

Using excel to make purchase orders, invoices, warehouse inventory and other forms can refer to the following operation methods:

1. Open the table, and the mouse can select 7 columns and 7 rows at will (generally about 10 rows). Right-click and click all wireframes;

2. Enter the data of the warehouse delivery note, such as date, single number, unit, name, amount and quantity. This can be filled in as needed.

3. After filling in the data, use the mouse to select the cell to be merged, and select the cell-click the "Merge" command in the menu bar, and then check whether there are any errors after setting.

4. Adjust the height and width of columns and rows. Font size, font setting, click the inverted triangle in the upper left corner of the table to select all cells-menu bar start-center-font size setting, and the table name warehouse delivery list needs to be set separately, bold, large and centered.

5. Check the form after setting. You can view the table in the view menu bar-turn off the display of grid lines.

6. There is nothing wrong with the form. Click Print Preview for final confirmation. Click print (shortcut Ctrl+P) table. If the problem cannot be solved, it is recommended to repeat the above steps and try again.