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 Print Orientation. Double-click the downloaded file to extract all files.
  2. Open the template "simple-invoice-template-print-orientation.xlsx" or "simple-invoice-template-print-orientation-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 Print Orientation

Simple Sample - Changing Print Orientation (c4053)

c4053 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-print-orientation-uis.xlsx.

Simple Sample - Changing Print Orientation (UIS Edition)

Simple Sample - Changing Print Orientation - UIS edition

Download Simple Sample - Changing Print Orientation (c4053)

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

To allow more content in each field, and to have less lines on the invoice detail section, print using "Landscape" orientation. This simple invoice template details the steps and issues that could occur.

Most template available here on InvoicingTemplate.com using "Portrait" paper orientation / print orientation. In the real business world, there is no one template fits all. Different businesses have very different requirements regarding their invoicing forms. Some businesses need relatively long content on each field, such as address, description etc., and they need less lines on the invoice detail section. This tutorial, based on the result of c4051 Simple Invoice Template - Discount Amount Field, demonstrates how to change the orientation option of the invoicing form to "Landscape".

As you can see from this tutorial, Microsoft Excel provides complete tool set for customizing invoice form layouts. This, combined the flexibility of Uniform Invoice Software, make it possible to build an invoicing system that is very specific to your business.

If you have just started your business and have limited budget for invoicing / accounting, using a free invoice template like the simple invoice template created in this tutorial could produce professional invoices with easy and quick. If you need a more powerful invoicing tool, install Uniform Invoice Software, which works with any / all templates published here on InvoicingTemplate.com.

Now let's see how to change the paper orientation of an invoice format.

  1. Back up your template. Whenever you want to modify the layout or format of a template, or even simply change the fonts / colors / borders / back colors, or Excel formulas, it is always a good idea to back the original template first.
  2. Open the template in Microsoft Excel.
  3. Switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab. The "Invoice" ribbon tab is created by Uniform Invoice Software. If you cannot find it, make sure you have installed our invoicing software app Uniform Invoice Software. The trial version, which can be downloaded from here on InvoicingTemplate.com, is completely free and fully functional within trial period.
  4. Go to the "Page Layout" Excel ribbon tab.
  5. Click "Page Orientation" from the Page Setup command group. Choose "Landscape".
  6. Go to Excel "View" ribbon tab. Push down "Page Break View".
  7. Excel shows that the content of the printable form need 3 pages to print on the vertical direction after we change the paper orientation to "Landscape". There are in total 12 lines run over the first page. If we can reduce the number of rows on the vertical direction by 12, the invoicing format could be printable on landscape orientation.

    Look at the invoice form. We can adjust the number of lines on the invoice detail section from 12 to 6. This will save 6 rows / lines.

    The fields on the "Bill To" and "Ship To" sections could be rearranged to be tiled on the horizontal direction. This will save 3 rows / lines.

    We still need to save 3 or more rows. This could be done by hide some empty rows on the form.

  8. To hide the last 6 rows on the invoice detail section, drag your mouse on the headings from R33 to R28 (this makes the last 6 rows selected), right-click one of the selected row heading and choose "Hide" from the shortcut menu. By hiding instead of deleting the rows, we make sure that the formulas on the template still work.
  9. Now to rearrange the fields on the "Bill To" and "Ship To" section. Right-click G column heading and choose "Insert". This insert a new column. Do this 3 more times.
  10. Drag your mouse to select all the fields in the "Bill To" section (i.e. $F$3 to $L$16). Click the "Merge and Center" button on the "Home" ribbon tab to unmerge the selected cells.
  11. Select the cells starting from the label "Phone" to "Client#", including the fillable fields, i.e. E14:F16. Drag the border of the selected area and put it on the new location starting from H9.
  12. Select all the fields in the "Ship To" section, ranging from N9 to O14, click "Merge and Center" on the "Home" ribbon tab to unmerge the cells.
  13. Select the cells ranging from M8 to N11 (The label "Ship To", and the first 3 fields in the shipping address section). Drag the selected area to the new location starting from J8.
  14. Move the "Contact" and "Country" fields to the new location starting from M9.
  15. Hide the empty rows left by moving the "Bill To" and "Ship To" fields - R14, R15, and R16. To do this, drag your mouse on these row headings to select the rows, right-click on one of the selected row heading and then choose "Hide".
  16. Hide two empty rows on the bottom of the form, R40 and R41.
  17. Hide the empty row R7.
  18. If the worksheet is still in the "Page Break View" (Excel "View" ribbon tab, "Workbook Views" group), you can find now the entire printable form could be printed on a single page. If you are following this tutorial and find that Excel break pages on the horizontal direction, narrow some columns to fit into one page. In sample, we adjust the widths of column I, J, M and N.
  19. There are still complementary customization work to do. For example, the "Name" field, which has the cell name "oknWhoName" and located at $F$3, is unmerged. We need to merge it with the next cell G3 to create the new cell. To do this, select F3:G3 and then click "Merge and Center" on the "Home" ribbon tab. Do this too for the "Address", "City, State and ZIP" and "Country" too. Also, you want to make these fields left-aligned. To do this, select these cells, click the "Align Left" command on the "Alignment" group of the "Home" ribbon tab.
  20. Make the decorative line named "oknWidget_1" wider. To do this, click to select the line object, push down the SHIFT key on keyboard and drag the right-hand corner of the line till the line as wider as the whole printable section.
  21. The "Sales Rep. Name" fields occupies too many cells. So we unmerge the "Sales Rep. Name" fields. And by moving fields, use the "Merge and Center" tool, make all the fields on the line R18 and R19 occupy largely the same space on the horizontal direction.
  22. The invoice detail section lose its bottom border (since we have hide the row that show the border). We add it back by add the border to the last row (In this sample, R27).
  23. Go to Excel menu File / Print to see the print preview.
  24. If everything is OK, return to normal view by pushing down the "Normal" button on Excel "View" ribbon tab.
  25. Exit design mode by clicking the "Design Mode" button again on the "Invoice" ribbon tab.
  26. Save the customization result by clicking the Save button on Excel quick access toolbar.

This simple invoice template demonstrates how to create an invoicing form that is printable with "Landscape" orientation. The result of this customization could be downloaded for free.

Like other form designs here on InvoicingTemplate.com, Simple Invoicing Format - Changing Print Orientation 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#c4053
NameSimple Sample - Changing Print Orientation
CategorySales Invoice Template
Release DateFriday, January 29, 2016
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns4
Lines6
Line Height (Points)18.00
Print Area$D$2:$O$47
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Landscape
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Sample Templates