Using Multiple-Line Address in Invoice Form
The standard/default invoice template shipped withinstaller 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:
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 cell resides, so that the address line is able to hold multiple lines of address information.
- 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.
- 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 -> , 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 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 2000/XP/2003, or by clicking button -> in Excel 2007, or by clicking -> in Excel 2010.