Easily pack items with details by using our shipping packing list template. Packing list is available for Microsoft Word and Excel. Invoice and Packing List on Same Form. A shipping packing list is also called delivery docket, it shows what goods included on shipment, also serve as a bill of lading. Web%20docs/Packing%20List.png' alt='Packing List For Shipment Template' title='Packing List For Shipment Template' />It is naturally close related to invoices. In this sample template we demonstrates how to create a packing list and an invoice within one same form. The packing slip template here on Invoicing Template shows you how to create a standalone pack list template. With the help of Uniform Invoice Software, you can easily loaded an existing invoice using the packing list template, and thus to print the packing list for shipment using the packing list template. Simple Packing List TemplateIf you always have the need to print both an invoice and a packing list at the same time, then consider to have both documents invoice and packing list, on the same form, as shown in this sample. In this template sample, we will use c. Simple Invoice Template for Letterhead Paper as the basic template, and add a packing list to the same form on the Invoice worksheet, so that when an invoice is printed a corresponding packing list will be printed too. To archive this goal, we first have to copy the existing invoice design to create a new form, and then modify the new form to make it suitable for packing lists. And finally, we modify the definition of the printable form, to have Excel print both documents the invoice and the packing list at the same time. Lets see the detailed procedures and steps involved in this customization. Commercial Packing List TemplateFirst, backup the template that you want to customize. It seems redundant that we repeat this in every tutorials targeted to simple invoice template customizations. But it is important and highly recommended that you do so. Baking up data frequently saves you a lot time and efforts when the newest version of data is lost. Open the template. Switch to design mode by clicking the Design Mode button on the Invoice worksheet. Fill Packing List Template, download blank or editable online. Sign, fax and printable from PC, iPad, tablet or mobile with PDFfiller Instantly No software. Pull down the name box located on the left end of the formula bar. Dyna Bomb Blaster Game. On the end of the name list youll find PrintArea. Click to select it. Excel select all the cell defined by the PrintArea name. This is the printable area that is printed when you print the current worksheet. On Excel Home ribbon tab, click Copy in the Clipboard group. This copies the entire printable invoice form to the clipboard. Choose an empty area underneath the existing printable form. In this sample, our original printable area is defined at D2 L4. D5. 0, this will be our starting cell of the new packing list form. On Excel Home ribbon tab, pull down Paste in the Clipboard group and then choose Paste All. Now the key step pull down Paste in the Clipboard command group again, chose Paste Link in the Other Paste Option section. This will create a simple formula for each cell in the paste destination section. The simple formula retrieves data from the original printable form the invoice form, fill it in the packing list section. This way, if we you fill in the invoice data, either manually or loading an existing invoice from database by using Uniform Invoice Software, the data of the packing list is automatically filled. Till now our new packing list form has exactly the same format and content as the invoice. Modify it to make it meets your requirements of packing slip. For example, change the title from Tax Invoice to Delivery Docket. In this sample, we also clear the Price and Amount column, and then expand the Description column. With this sample template, we also cleared the bottom section that details Freight, GST, Total Incl. GST etc., as they are usually not required on a packing list. Add your notes and declarations to the form, usually bottom of the form. It is also common to add fields for manually singed. For example, we added Signed, Sign Date, Print Name and Print Date. Once the design of the packing list is finished, select all the cells inside the packing list. Lock all the cells. Now once again, select PrintArea from the name box on the left end of the formula bar. This selects the original printable area. Now push down the CTRL key on the keyboard, drag mouse to select the new packing list area in this sample, it is D5. L9. 2. Release keyboard CTRL key. With both the invoice and packing list form selected, from Excel Page Layout ribbon choose Print Area, and then Set Print Area. This define the new printable form. As you can see, the print area could be discrete area that contains multiple ranges. Go to Excel menu File Print Preview. Make sure the worksheet will be printed on 2 pages. Exit design mode once you have done the customization. Save the template. Now when you click Print to print an invoice, Uniform Invoice Software will print two documents, one invoice and one packing list. However the Extract feature will encounter problems if you choose the exact an Excel format worksheet but the PDF formatted invoice and packing list work just fine. Feel free to take a look of our pdf invoice template gallery too. To overcome the drawback of having to always print the two documents invoice and packing list at the same time well, someone see this as drawback, others may find it handy, place the packing list on another worksheet. This way, the packing list worksheet can have its own PrintArea definition, and thus could be printed separately. Well address this with another tutorial. Like other form designs here on Invoicing. Template. com, Invoice and Packing Slip on Same Form is free offered to you at a price of 0. USD. It works on Windows XP and all newer versions of Windows, and Excel 2.