This version of the document, "Using Multiple-Line Address in Invoice Form", was written for Excel Invoice Manager, which was now renamed to Uniform Invoice Software. For the latest version of this document, please download Uniform Invoice Software.
The standard/default invoice template shipped with Excel Invoice Manager installer displays only one line in both the BILL TO and SHIP TO 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:
If you prefer to customize your existing template yourself, here are the steps:
- Copy your invoice template to make a backup, and then open the invoice template 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 Address cell resides, so that the address line is able to hold multiple lines of address information.
(Click to enlarge)
- This step is required only when you are using a template that was released prior to Excel Invoice Manager version 2.10.1014.
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, choose Format Cells from the menu.
Go to the Alignment tab.
(Click to enlarge)
In the Text alignment section, choose Left (Indent) from the Horizontal list, choose Top from the Vertical list; in the Text control section, check the Wrap text option.
Click OK to close the Format Cells dialog box.
- Try to enter sample text into the new address cells. To start a new line when entering text, press ALT + ENTER keys on your keyboard.
- Click Excel menu File -> Print Preview, 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.
- Drag and drop to move the buttons, such as the Save As New Customer and View Customer Info 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 Invoice worksheet.
- Save the template by clicking Excel menu File -> Save in Excel 2000/XP/2003, or by clicking Office button -> Save in Excel 2007, or by clicking File -> Save in Excel 2010.