Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Shipping Invoice Template (2). Double-click the downloaded file to extract all files.
  2. Open the template "shippinginvoicetemplate2.xls" or "shippinginvoicetemplate2-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

Shipping Invoice Template (2)

Shipping Invoice Template (2) (c5048)

This is how the template looks like when you open the freeware template in Microsoft Excel.

Shipping Invoice Template (2) - freeware edition

Shipping Invoice Template (2) - freeware edition

The following template was designed for Uniform Invoice Software version 3.

Shipping Invoice Template (2) - Uniform Invoice Software V3 edition

Shipping Invoice Template (2) - Uniform Invoice Software V3 edition

Download Shipping Invoice Template (2) (c5048)

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

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

336 KBDownload

Download this if you want this design to be set as the default template by the installer program.

2.82 MBDownload

Detail

Shipping Invoice Template (2) is a variant of Shipping Invoicing Sample. This customized format differs from the original template in that the shipping invoices created by this template is printable on A4 paper with Landscape paper orientation.

All Excel-formatted templates created and hosted here on InvoicingTemplate.com are based on the default template shipped with Uniform Invoice Software, which is our invoicing software that is able to turn a simple Excel spreadsheet template into a powerful invoicing program.

If you are interesting in how we created this customized shipping invoice format from the original shipping invoicing sample, here are the steps: unprotect the Invoice worksheet, switch to design mode, display row headings and gridlines of the Excel spreadsheet, resize columns to make it printable on A4 paper in Landscape orientation.

The protection of the "Invoice" worksheet in Shipping Invoice Template (2) prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the worksheet. However for the purpose of this sample, we should firstly unprotect the worksheet in Shipping Invoice Template (2).

In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Shipping Invoice Template (2). Note that if you have our invoicing program installed, and you are running Excel 2007, Excel 2010 and Excel 2013, it already provides a Design Mode button on the ribbon tab, so that you don't have to switch to design mode manually. Our invoicing software is able to turn a simple spreadsheet into a powerful invoicing system, with the ability to manage customers, products, bills and payments, it also includes various tools that could help you configure the layout of your form, such as the number of taxes and tax names and rates. If you don't have our invoicing program installed, here are how you can switch to design mode manually.

  • In Excel 2003 click the Design Mode button on the Control Toolbox toolbar. Tip: If the Control Toolbox toolbar is invisible, click Excel menu View > Toolbars > Control Toolbox.
  • In Excel 2007, Excel 2010 and Excel 2013, click the Design Mode button in the Controls group of the Developer tab.

    TIP: If the Developer tab is not available in Excel 2007, do the following to display it: a) Click Microsoft Office Button, and then click Excel Options; b) In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

    Or in Excel 2010 and Excel 2013 to display the Developer tab: a) Click File > Options > Customize Ribbon; b) In the area on the right, ensure that the box next to Developer is checked; c) When you click OK, the Developer tab will appear in the ribbon.

Once you have finished your design work for Shipping Invoice Template (2), click the Design Mode button again to exit design mode.

To show gridlines and row/column headers in Excel 2000 - 2003:

  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. On the Tools menu, click Options, and then click the View tab.
  3. Under Window options, check the Gridlines and Row & Column Headers check boxes.

After your customization, go back to the Tools menu, Options, View tab. Under Window options, REMOVE the checks you previously placed by the two check boxes to hide gridlines and row/column headers. This will restore the appearance of your template.

To show/hide gridlines and row/column headers in Excel 2007, Excel 2010 and Excel 2013:

  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. Go to the View tab of the Ribbon.
  3. Click Show/Hide, and then check or uncheck the Gridlines and Headings options.

The gridlines and row/column headings could help a lot when design the layout of the form.

Resizing columns is easy in Microsoft Excel. For example, let's say you want to change the width of column A. Make sure Shipping Invoice Template (2) is unprotected. First Place the mouse pointer on the line between columns A and B in the column header. The pointer will change to a double - headed arrow. Click with the left mouse button and drag the double - headed arrow to the right to widen column A or to the left to make it narrower. Follow these same steps to change the width of other columns.

Since the paper is now in landscape orientation, we need to hide some rows to make the shipping invoicing layout be printable on a single page.

Before you can hide a row, make sure the "Invoice" worksheet of Shipping Invoice Template (2) is unprotected and row / column headings are shown. To hide a single row in Shipping Invoice Template (2), first right click on the row header of the row to be hidden; Choose Hide from the menu; The selected row and the row number will be hidden from view. To hide adjacent rows in the worksheet, for example, you want to hide rows 14, 15, and 16 in the Shipping Invoice Template (2): In the row header drag select to highlight all of the rows you want to hide; Right click on the selected rows; Choose Hide from the menu; The selected rows and row numbers will be hidden from view. To hide separated rows in Shipping Invoice Template (2), for example, you want to hide rows 3, 5, and 7: In the row header left click on the first row to be hidden; Press and hold down the CTRL key on the keyboard; Continue to hold down the CTRL key and left click on the rest of rows to be hidden; Right click on one of the selected rows; Choose Hide from the menu; The selected rows and row numbers will be hidden from view of Shipping Invoice Template (2).

If you are looking for a Shipping Invoicing Sample in Microsoft Word format, we recommend this Excel Shipping Invoicing Format instead. As you can see from the above customization procedure, it is easier to create and format the shipping invoice form in Microsoft Excel.

Like other form designs here on InvoicingTemplate.com, Freight Invoice Format (2) is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2003, 2007, 2010, 2013 or 2016.

Format and Specification

Template#c5048
NameShipping Invoice Template (2)
CategorySales Invoice Template
Release DateWednesday, January 15, 2014
Format (XLS or XLSX).xls
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns5
Lines16
Line Height (Points)15.00
Print Area$F$2:$O$53
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Landscape
Default Margins (Points)
Left22.68
Right22.68
Top28.80
Bottom28.80

Sample Templates