Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
682 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.

Screenshot

screenshot for Excel Shipping Invoice with Printable Truck Background Image

Detail

This template is based on the Shipping Invoice Template (1) (c5013). It adds a truck image as a watermark that will be shown on the printed invoice and the PDF invoice generated with our app.

Here are the brief steps to adding an image as the watermark of the form:

  1. Open the "Page Setup" dialog box in Excel.
  2. Go to the "header / Footer" tab.
  3. Check "Scale with document" and "Align with paper margins", and then click "Custom Header".
  4. On the "Header" dialog box, click to activate the "Center Section" box.
  5. Click the "Insert Picture" button on the toolbar.
  6. Specify the image you want to use.
  7. Once the picture has been specified, Excel inserts a "&[picture]" placeholder into the "Center Section" box.
  8. Click to select the "&[Picture]" symbol, then click the "Format Picture" button on the toolbar. This opens the "Format Picture" dialog box.
  9. In the "Size and rotate" section, set the height and width of the picture to the proper values. In this case, the target paper is standard A4 paper (8.27 inch X 11.69 inch), so we set the image size to 6.89 inch (height) and 8 inch (width). This makes the truck image appear in the center of the printed form.
  10. Go to the "Picture" tab. In the "Image Control" section, set "Brightness" to 85% and contrast to 30%.
  11. Click the "Compress" button to make the inserted image smaller in file size.
  12. Close the "Format Picture" dialog box.
  13. Click OK to close the "Header" dialog box.
  14. Click "Print Preview" on the "Page Setup" dialog box.
  15. Excel shows the document in preview mode.
  16. You may need to go back and adjust the size, brightness, and contrast to get a better effect.
  17. Once everything is done, click the "Design Mode" button on the ribbon tab to exit design mode.
  18. Save the template.

Format and Specification

Template#c5087
Belongs to

Sales

Format (XLS or XLSX).xlsx
Columns5
Lines16
Line Height (Points)16.50
Print Area$F$3:$N$57
Papaer OrientationPortrait
Default Margins (Points)
Left18.00
Right18.00
Top75.60
Bottom75.60
PriceFree