Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Simple Sample - Changing Paper Size. Double-click the downloaded file to extract all files.
  2. Open the template "simple-invoice-template-changing-paper-size.xlsx" or "simple-invoice-template-changing-paper-size-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 - Changing Paper Size

Simple Sample - Changing Paper Size (c4052)

c4052 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-changing-paper-size-uis.xlsx.

Simple Sample - Changing Paper Size (UIS Edition)

Simple Sample - Changing Paper Size - UIS edition

Download Simple Sample - Changing Paper Size (c4052)

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.

303 KBDownload

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

2.78 MBDownload

Detail

Most templates here are targeted to be printable on A4 paper, as the default template shipped with Uniform Invoice Software. This simple invoice template shows you how to change the paper size.

While A4 paper is common in many business documents, you may decide to choose another paper type and size for your invoices.

In this tutorial we'll create a simple invoice template that changes the paper type from "A4 8.27 X 11.69" to "B5 7.17 X 10.12 inch". The base template used in this sample is c4051 Simple Invoice Template - Discount Amount Field. The result of this customization, a simple invoice template that is printable on the B5 paper size, could be downloaded for free from InvoicingTemplate.com.

The reason for changing to this new paper type is that it is common and also similar to the original paper size. Changing to other paper sizes and types is possible, but more time and effort may be involved in order to rearrange the fields and controls to create a professional and useful invoicing format and layout that is printable on a single page.

Here are the steps to do this customization.

  1. Backup the template. This customization does not change the underlying database, so it is not required to back up the database file.
  2. Open the invoice template.
  3. Click the "Design Mode" button on the "Invoice" ribbon tab to push it down. Uniform Invoice Software must be installed in order to show this ribbon tab. Uniform Invoice Software is free within the trial period (30 days). After the trial period, you need a valid license in order to keep it.
  4. Go the Excel "Page Layout" ribbon tab. Click "Size" in the "Page Setup" group and choose our target paper size "B5 7.17 inch X 10.12 inch" from the list.
  5. Go to Microsoft Excel "View" ribbon tab. Choose "Page Break Preview". In this preview screen, Excel shows how many pages will be printed for the currently defined print area, and what content / fields will be on each page. In this sample, Excel shows that the invoice form that we copied from c4051 Simple Invoice Template - Discount Amount Field will be printed using 4 pages after the paper size changed to B5.
  6. On the horizontal direction, The "Line Total" column cannot be fit into the first page. To make it fit, we narrow download the width of the "Line Total" column a bit. You can adjust the widths of the other columns too. In this sample, we try to narrow column F, G, H and J too. If Excel finds the content of the printable invoicing form could fit into one page on the horizontal direction, it removes the vertical page break line (blue dashed line) automatically.

    If the page break cannot be removed by narrowing the column widths, you need to consider removing some columns from printing.

  7. On the vertical direction, Excel shows that there are 4 rows need to be printed on the second page. This is not a big number. So we could first to try hide some empty rows. In this sample, R40, R41 and R46 are all empty. Since we hope to leave some space between the "Total" cell and the "Thank you for your business" label, we hide R40 and R41, and then narrow the height of R46. To hide a row, right-click a row heading and then choose "Hide" from the shortcut menu. To narrow a row, just drag the bottom-border of the row and move it up (slightly).

    There are still 2 rows left to be put onto the second page. Check the entire printable form we found that R6, R7 and R20 are all empty rows and could be narrowed. So we make them smaller. If this is still not enough to make the form be printable on a single page, you may need to consider narrow the heights of those non-empty rows.

  8. Before finish, check the entire form carefully and make sure everything is in order. In this example, we need to adjust the width of the decorative line underneath "Phone Number,Web Address, etc.", which is named "oknWidget_1" in this sample. To do this, we click to select the object, drag the right-side of the selection mark (push the SHIFT key on keyboard to force it either vertical or horizontal) to make it fit into the page break mark.
  9. Go to Excel menu File / Print to see the print preview.
  10. If everything is OK, return to normal view by pushing down the "Normal" button on Excel "View" ribbon tab.
  11. Exit design mode by clicking the "Design Mode" button again on the "Invoice" ribbon tab.
  12. Save the customization result by clicking the Save button on Excel quick access toolbar.

If the difference between the new and original paper size is major, the basic techniques - applied in this tutorial - hide or narrow rows / columns - may be not enough. You need to consider other options such as removing / hiding fields.

Also, you may need to switch between several views many times - normal view, page break view and print preview etc.

Changing the paper type and size of an existing invoice template is usually a time-consuming job, like it in the real / physical world. Sometimes it even results in redesign of forms. Hope this simple tutorial, and the simple invoice template created in this tutorial, give you some ideas and a good starting point.

Like other form designs here on InvoicingTemplate.com, Simple Invoicing Form - Changing Paper Size 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#c4052
NameSimple Sample - Changing Paper Size
CategorySales Invoice Template
Release DateThursday, January 28, 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$47
Printable with Papaer Size / OrientationA5 (148 mm x 210 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Sample Templates