Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Simple Sample - Moving Item# Column. Double-click the downloaded file to extract all files.
  2. Open the template "simple-invoice-template-moving-item-id-column.xlsx" or "simple-invoice-template-moving-item-id-column-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.

Simple Sample - Moving Item# Column

Simple Sample - Moving Item# Column (c4049)

c4049 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open simple-invoice-template-moving-item-id-column-uis.xlsx.

Simple Sample - Moving Item# Column (UIS Edition)

Simple Sample - Moving Item# Column - UIS edition

Download Simple Sample - Moving Item# Column (c4049)

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.

293 KBDownload

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

2.79 MBDownload

Detail

This simple invoice template demonstrates how to move out the Item# (or Product #) column from the printable invoicing form. The result template still has the item# column but it is not printable.

The default invoice template shipped with Uniform Invoice Software setup program (See Free Sales Invoicing Template), as well as its customized version c5075 Simple Sample Invoicing Template - Moving Cells, both have the Item# column put on the printable form.

The Item# or Product# column is not useful if they are just short codes for your business internal use only. For example, if you are running a service business, you can save the description of each service item, each with a shortcut as item#, to the "Product" database. So that when you need to enter the description text of a service, you can just enter the short code in the item# cell. This feature, provided by Uniform Invoice Software, is called in-cell lookup. Uniform Invoice Software has built-in support of in-cell lookup for 3 main database tables - customers, invoices and products. This means that, if you enter a value into the invoice# (or customer#, or product#) cell, all the related data will be retrieved and displayed on the invoice form.

The behavior of the in-cell lookup feature of Uniform Invoice Software could be controlled on the "In-Cell Lookup" tab of the Settings window. To open the Settings window, click the Settings button on the "Invoice" ribbon tab. Uniform Invoice Software must be installed in order to have this ribbon tab created when you open a template.

In this tutorial, we'll detail the steps of moving out the item# (product#) column out of the printable form. The result of this simple customization is a simple invoice template that shows only 4 columns on the printed invoice - Description, Unit Price, Quantity, and Line Total. But you can still use the in-cell lookup feature in to the Item# cells which are located outside the printable billing form.

First, make a backup copy of the template that you want to customize. In this case, we use c5075 Simple Sample - Moving Balance and Payment Cells.

  1. Open the invoice template as usual.
  2. Switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab.
  3. Drag your mouse to select the "To create an invoice" section, as well as the short advertisement section "Need a different invoice layout? Visit our invoice template collection" section. Move the entire selected area (N6:R46) several columns right. In this sample, we put this on $R$6.
  4. On the printable form, select the entire "Description" column, including the heading row, ranging from F21 to H33. Click the "Merge and Center" command on the "Home" ribbon tab. This unmerges the selected area.
  5. Now select the entire column "#/Taxable". The range address should be D21:D33. Move the selected area to the new location starting from $O$21.
  6. Now selected the unmerged "Description" column, ranging from F21 to F33. Move the selected area to the new location starting from $D$21.
  7. Select all the cells that will comprise the new column heading of the Description column, ranging from D21 to H21. Click "Merge and Center" command on the "Home" ribbon tab.
  8. Select all the cells that will comprise the new oknProductName_1 cell (the top-most product description cell), ranging from D22 to H22. Click "Merge and Center" command on the "Home" ribbon tab.
  9. Repeat the above step for all the other description cells.
  10. The "Merge and Center" command set text alignment to be "Center". We have to set this to "Left". To do this, select all the product description cells (excluding the heading cell), ranging from D22 to H33. Click the "Align Left" button on the "Home" ribbon tab / "Alignment" group.
  11. In Excel 2010 / Excel 2013 / Excel 2016, click File / Print to preview the result of a printed invoice.
  12. Exit print preview mode and go back to normal view. Add up borders and set colors to fine turn the printable invoicing form.
  13. Once finished, exit design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab.

That it! You now have a simple invoice template that was created by moving out the item# column. You can still use the item# column on creating invoices - what we do is just put it outside printable form.

Like other form designs here on InvoicingTemplate.com, Simple Invoicing Template - Moving Item# Column is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.

Format and Specification

Template#c4049
NameSimple Sample - Moving Item# Column
CategorySales Invoice Template
Release DateSunday, January 24, 2016
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Columns4
Lines12
Line Height (Points)18.00
Print Area$D$2:$K$46
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Sample Templates