What is this sample for?
This document "Multiple-Line Address in Invoice Form" was written for Excel Invoice Manager. If you are using Invoice Manager for Excel and newer versions of Excel, some command names and their locations may vary.
The standard/default invoice template shipped with installer displays only one line in both the and address fields on the invoice form.
If you prefer to use a template that supports multiple lines of address, click the following links to download it:
Steps of customizations
If you prefer to customize your printable invoice template yourself, here are the steps.
- Copy your template to make a backup, and then open it in Microsoft Excel.
- Unprotect the Invoice worksheet. (How?)
- Switch to design mode. (How?)
- Display gridlines and row/column headings. (How?)
- Drag the border of the row heading where the
- This step is required only when you are using a template that was released prior to
Push the CTRL key on your keyboard; click the two address cells in turn to select the cells.
Right-click one of the selected cells, choosefrom the menu.
Go to thetab.
In thesection, choose from the list, choose from the list; in the section, check the option.
Clickto close the dialog box. version 2.10.1014.
- Try to enter sample text into the new address cells. To start a new line when entering text, press keys on your keyboard.
- Click Excel menu printable invoice forms for more information. -> , to make sure the invoice form can be printed on a single page. If it isn't, try to decrease the heights of the other lines. Visit
- Drag and drop to move the buttons, such as the and buttons, to make sure they don't overlap those cells where you need to enter data.
- Once finished, exit design mode.
- Hide gridlines and row/column headings.
- Protect the worksheet.
- Save the template by clicking Excel menu -> in Excel 2003, or by clicking button -> in Excel 2007, or by clicking -> in Excel 2010 and higher versions.