The printed version.
Tutorial for Adding New Line to Template (c5124)
c5124 now includes the customized invoice template for the latest version of Invoice Manager for Excel. This is what you will see when you open tutorial-for-adding-new-line.xlsx
.
Tutorial for Adding New Line to Template - IMFE edition
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.
Description | Size | Download |
---|---|---|
Download this if you want this design to be set as the default template by the installer program. | 3.41 MB | Download |
Without database file. How to download and use | 95 KB | Download |
Download this if you have already installed IMFE, but are looking for additional customized templates. | 422 KB | Download |
This sample shows the detailed steps required when adding new lines to an existing template, by using the default invoice template shipped with Invoice Manager for Excel (namely Uniform Invoice Software) as the starting point.
The standard invoice template shipped with Invoice Manager for Excel (namely Uniform Invoice Software) has 12 lines (or 12 rows) on the detailed section. But the number of lines on the detail section isn't necessary to be 12.
For example, Invoice Template with Long Product Description includes only 6 lines, which enables you to enter long text into the "Description" field. On multiple-page invoice templates, you can find samples that has 36 lines (two-page), 60 lines (three-page), 84 lines (four-page).
Reducing the number of lines could be archived by hiding some bottom lines of an existing invoice design, but increase the number of lines is not as easy as reducing lines.
First, all cells that need to be saved to database must be correctly named, including those put into hidden columns. Secondly, you have to modify the Excel formulas that calculate totals and taxes. Finally, if you find many lines, you have to adjust the page breaks if the template should be printed using multiple pages.
In the following step by step tutorial, we'll add only one new line. So it does not involve the adjustment of page layout and printing. Please refer to printable invoice templates for more samples on this topic.
This step by step tutorial is based on Windows 10 and Excel 2016.
Please refer to How to name an Excel cell / range.
The Excel cell names map to database file name. So for example in the name "oknProductID_13", "okn" is the prefix that must be added to all names that indicate cells saved to / loaded from database; "ProductID" is the database field name in the "Invoice Body" database table; "13" is line number.
=oknTaxable_13
{=SUM(oknTaxable_1:oknTaxable_12*oknLineTotal_1:oknLineTotal_12)}
On the formula bar click to edit the formula, change the numbers from "12" to 13", and then press keyboard key CTRL + SHIFT + ENTER to create the array formula. The result should look like this:
{=SUM(oknTaxable_1:oknTaxable_13*oknLineTotal_1:oknLineTotal_13)}
=ROUND(oknQuantity_13*oknPrice_13,2)
=SUM(oknLineTotal_1:oknLineTotal_13)
Since we add only one new line to the template, it is still printable one a single A4 or letter paper. In practical situations you may want to add several lines. In this case, you may need to click Excel menu "File" and then "Print" to verify how many pages needed to print the form.
Adding a new line is not as easy as hiding a line. Fortunately you can download ready-to-use templates at templates with multiple pages without going through all these steps.
Like other form designs here on InvoicingTemplate.com, Tutorial for Adding New Line to Invoice Form 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.
Template# | c5124 |
Name | Tutorial for Adding New Line to Template |
Category | Sales Invoice Template |
Release Date | Saturday, October 28, 2017 |
Format (XLS or XLSX) | .xlsx |
Excel Version | Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016 |
Feature Gallery | |
Columns | 5 |
Lines | 13 |
Line Height (Points) | 18.00 |
Print Area | $D$3:$K$47 |
Papaer Size / Orientation | Portrait |
Default Margins (Points) | |
Left | 18.00 |
Right | 18.00 |
Top | 75.60 |
Bottom | 75.60 |