Adding Postcode Cells Manually to Invoice Template
Starting with 2.11.1015,offers a new option "ZIP/Postcode in separate cell". Without this option, "City State" and "Zip" fields are combined in one cell. If you check the " " option on the window, or will use a separate cell. This feature might be helpful if you want to create UK or Canadian style invoice templates.
The name of the cell isin the section; it is named in the section.
The invoice templates included in the versions prior to 2.11.1015 don´t have theand cell names defined, so the " " option is invisible on the window.
Here are the steps to define the cell names manually in your existing template to make the "" option available.
- First make a backup copy of your existing template that you need to customize. This allows you to start again in case the template is damaged in the following steps.
- Now open your template in Excel.
- Unprotect the How?) worksheet. (
- Switch to design mode. (How?)
- Display gridlines and row/column headers. (How?)
- Right-click on the header of the row above which you will insert a new row to place the new ZIP/Postcode cells.
- Choose from the menu.
- Click the merged cell next to the label " " in the section to select it.
- Click the button. In Excel 2007/2010, this button is in the group, ribbon tab. In Excel 2000/XP/2003, you can find the button on the toolbar.
- Click the first cell on the row where you will place the postcodes. This applies the formatting of the unlocked. cell to the new cell, i.e. the cells below will be merged and
- Now name the newly merged cell by entering the name into the name box at the left side of Excel formula bar.
- Repeat the above steps 8, 9, 10 and 11 but for the section to format and name the cell.
- Since a new row has been inserted, the
, and buttons may not be in the right place. To move the controls/buttons:
- Click to select the control/button you want to move.
- Move the control/button to a proper place by using the arrow keys on your keyboard.
- Once finished, exit design mode.
- Hide gridlines and row/column headers.
- 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.
- Close and reopen the invoice template.
- Click the button on the worksheet. You should see the " " option on the Workbook tab now.