The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
430 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.


The screen shot for 1/2 Page Invoice Template


This template demonstrates how to design a form that is printable on a half page.

This template is based on the Discount Amount Field (c4051).

Note: The sample at Two Invoices On One Template (c4067) shows how to print two forms on a single page.

Note: The sample at Two Receipts on One Sheet (c1012) shows how to create the second copy by using linked images, which offers a simpler way for creating an identical copy.

Let's see the steps involved in creating this 1/2-page template.

  1. Backup the template.
  2. Open the template.
  3. Switch to design mode by clicking the "Design Mode" button on the ribbon tab.
  4. Go to the Excel "Page Layout" ribbon tab and choose "Size" from the "Page Setup" group. Note the paper size of the current template. In this example, it is "Letter 8 1/2 inches by 11 inches." Half of it would be "8.5 X 5.5" inches.
  5. Click "Margins" and then "Custom Margins" in the "Page Setup" ribbon command group. This opens the Excel "Page Setup" dialog box with the "Margins" tab activated.
  6. From the "Center on page" group, uncheck the "Horizontally" and "Vertically" options. Click OK to close the "Page Setup" dialog box.
  7. Go to the Microsoft Excel "View" ribbon tab. Push down the "Page Layout" option on the "Workbook Views" group. This switches the worksheet into page layout view. The rulers are on the top and left of the worksheet window.
  8. Note that at this time the form occupies the entire printable area of the paper, i.e., it is 8 1/2 inches in width and 11 inches in height. To make sure the form can be printed on only half of the paper, we need to make sure the printable form occupies only 5.5 inches (half of the total height of 11 inches).
  9. To do this, we first hide 8 lines at the bottom of the detail section, so that only 4 lines are left.

    To hide a row, right-click on the row heading and then choose "Hide" from the shortcut menu.

  10. We also adjust the line heights to make sure each line occupies less space in the vertical direction. In the original design, the row height of most lines was 0.25. In this example, we change this to 0.20.

    To adjust the height of a row, right-click the heading of a row and choose "Row Height" from the shortcut menu.

  11. In this example, we also moved several rarely used cells out of the printable area, such as "Country" in the "Bill To" section and the "Ship To" section.
  12. If you are following this tutorial, make sure the last row in the printable area (in this example, row 40) does not exceed a half sheet of paper (5.5 inches). If it does exceed it, hide more rows.
  13. If necessary, go to the Excel menu "File" and then "Print Preview" to check the printing result. Make further modifications and customizations as needed.
  14. Switch back to "Normal" view by pushing down the "Normal" button in the "View" ribbon tab.
  15. Once finished, exit design mode.
  16. Save the template.

Format and Specification

Belongs to



Format (XLS or XLSX).xlsx
Line Height (Points)14.25
Print Area$D$2:$K$39
Papaer OrientationPortrait
Default Margins (Points)