Skip to main content
InvoicingTemplate.com main content

Sample Service Invoice Template: Using Line Number Instead of Item# - Screenshots and Images

The printed version.

Sample Service Invoice Template: Using Line Number Instead of Item#

Sample Service Invoice Template: Using Line Number Instead of Item# (c5037)

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

Sample Service Invoice Template: Using Line Number Instead of Item# - freeware edition

Sample Service Invoice Template: Using Line Number Instead of Item# - freeware edition

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

Sample Service Invoice Template: Using Line Number Instead of Item# - Uniform Invoice Software V3 edition

Sample Service Invoice Template: Using Line Number Instead of Item# - Uniform Invoice Software V3 edition

Download

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

Without database file. How to download and use

76 KBDownload

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

364 KBDownload

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

2.84 MBDownload

Detail

Sample Service Invoice Template: Using Line Number Instead of Item# is a variant of Sample Sales Invoice Template: Using Line Number Instead of Item#. It is the service edition of the original invoice template.

The difference between sales and service here on InvoicingTemplate.com is simple - if a template contains the "Ship To" section on the printable section, we call it sales invoice. If it does not contain the "Ship To" section, it is categorized as service invoice. If the form has a very special design in its layout, such as Tax bill for Printing Shop, which moves the "Ship To" section (titled with "Delivery To") to the body of the spreadsheet form, we add the template to both the sales and service category. Sample Service Invoice Template: Using Line Number Instead of Item# adheres to this rule too.

If you know Microsoft Excel, creating this sample invoice template from the original sample sales invoice template should be easy. If you are not, but interesting in how to do the customization, here are the processes involved in creating the sample service invoice template. The detailed tutorial on creating the sample sales invoice template can also be found at Sample Invoice Template: Using Line# as Product IDs,

Like what we do to all the customized invoice templates here on InvoicingTemplate.com, we start by unprotecting the Invoice worksheet, and then display gridlines and row/column headers, and then drag the shipping fields, including the related labels, out of the printable invoice form.

The protection of the "Invoice" worksheet in Sample Service Invoice Template: Using Line Number Instead of Item# 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 Sample Service Invoice Template: Using Line Number Instead of Item#.

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.

Moving a cell or a group of cells is easy in Excel. First, you click to select the cell or drag your mouse to select all the cells you want to move. And then, drag the border of the selected area to move it to the new location where you want to place the cell or cells. The moving content will overwrite the content in the target location, so make sure the target range is empty (not used) in Sample Service Invoice Template: Using Line Number Instead of Item# before doing the movement. And, if the target location contains merged cells, sometimes the movement fails. So it is also helpful to make sure the target location does not contain merged cell. If the target location Sample Service Invoice Template: Using Line Number Instead of Item# is overlapping the original range and the original range contains merged cells, the movement could also fail because you cannot change part of merged cell - if this happens, you need to first move the cells to a temporal location in Sample Service Invoice Template: Using Line Number Instead of Item# that are empty (i.e. not used), unmerge cells, and then move the cells from the temporal location to the desired location. If you need to unmerge a cell, first select it and then click the "Merge and Center" command on the Format toolbar in Excel 2003; or click the "Merge and Center" command on the Home ribbon tab in Excel 2007, 2010 and Excel 2013.

Sample Service Invoice Template: Using Line Number Instead of Item# demonstrates how easy it is to customize an invoice template in the way you like by using various tools provided by Excel. Regular data, such as your daily invoices, customers, items and payments, will be much easier to manipulate in the backend by using a database. So feel free to try the Uniform Invoice Software version of Service Template with Line Number, which provides all the features you need in management of customers, products, invoices and payments.

Like other form designs here on InvoicingTemplate.com, Service Template with Line Number 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#c5037
NameSample Service Invoice Template: Using Line Number Instead of Item#
CategoryService Invoice Template
Release DateWednesday, December 18, 2013
Format (XLS or XLSX).xls
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns5
Lines12
Line Height (Points)19.50
Print Area$F$2:$N$40
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35