How to make waybill printing and printing template with EXCEL?

1. Scan the original board of the form into a picture, cut off the redundant part of the picture with the picture viewing software, and then adjust the picture pixels. Measure the height and width of the original paper of the form. The wide pixel is calculated as 1 cm = 37.86 pixels, and the high pixel is calculated as 1 cm = 37.86× 0.95 pixels.

2. The made pictures are imported into WORD or EXCEL as the background. The operation of WORD is "format-background-filling effect-picture" in turn, and the operation of EXCEL is "format-worksheet-background" in turn.

3. The remaining work is to tabulate and adjust the position as needed.

First, the grid line display is removed from the settings, and then according to your own needs, you can make the content and position you need by merging cells and setting borders. You have to find several scrap express orders to test repeatedly and meet your requirements through constant adjustment.