This "Adding Postcode Cells Manually to Invoice Template" document was written for Excel Invoice Manager. If you are using Invoice Manager for Excel, we recommend you to download ready-to-use templates from InvoicingTemplate.com.
The name of the cell isin the section; it is named 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 required cell names manually in your existing template to make the "" option available.
- First make a backup copy of your existing template that will be customized. 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.
- 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 Excel worksheet.
- Save the template.
- Close and reopen the invoice template.
- Click the