free excel invoice templates
You are here: HOME  >>>  Excel Invoice Manager

Adding Postcode Cells Manually to Invoice Template

Starting with 2.11.1015, Excel Invoice Manager 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 "ZIP/Postcode in separate cell" option on the Settings window, ZIP or Postcode 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 is oknWhoZipPostcode in the Bill To section; it is named oknShipZipPostcode in the Ship To section.

The invoice templates included in the versions prior to 2.11.1015 don´t have the oknWhoZipPostcode and oknShipZipPostcode cell names defined, so the "ZIP/Postcode in separate cell" option is invisible on the Settings window.

Here are the steps to define the cell names manually in your existing template to make the "ZIP/Postcode in separate cell" option available.

  1. 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.
  2. Now open your template in Excel.
  3. Unprotect the Invoice worksheet. (How?)
  4. Switch to design mode. (How?)
  5. Display gridlines and row/column headers. (How?)
  6. Right-click on the header of the row above which you will insert a new row to place the new ZIP/Postcode cells.

    Insert a new row into the invoice template
    Insert a new row into the invoice template (Click to enlarge)

  7. Choose Insert from the menu.
  8. Click the merged cell next to the label "City, ST ZIP" in the Bill To section to select it.
  9. Click the Format Painter button. In Excel 2007, this button is in the Clipboard group, Home ribbon tab. In Excel 2000/XP/2003, you can find the button on the Standard toolbar.
  10. Click the first cell on the row where you will place the postcodes. This applies the formatting of the oknWhoCityStateZip cell to the new cell, i.e. the cells below oknWhoCityStateZip will be merged and unlocked.

    Format the postcode cell
    Format the postcode cell (Click to enlarge)

  11. Now name the newly merged cell oknWhoZipPostcode by entering the name into the name box at the left side of Excel formula bar.
  12. Repeat the above steps 8, 9, 10 and 11 but for the Ship To section to format and name the oknShipZipPostcode cell.
  13. Since a new row has been inserted, the Save As New Customer, View Customer Info and Same As Bill To 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.
  14. Once finished, exit design mode.
  15. Hide gridlines and row/column headers.
  16. Protect the Invoice worksheet.
  17. Save the template by clicking Excel menu File -> Save in Excel 2000/XP/2003, or by clicking Office button -> Save in Excel 2007.
  18. Close and reopen the invoice template.
  19. Click the Settings button on the Invoice worksheet. You should see the "ZIP/Postcode in separate cell" option on the Workbook tab now.

    Workbook tab of the Settings window
    Workbook tab of the Settings window (Click to enlarge)

 
EXCEL INVOICE MANAGER Free Download and Try
LEARN MORE Excel Invoice Manager Home What's New Difference between Editions Quick Start Introduction Setting up Company Information, Tax Invoice Template Working with Excel 2007 Installing / Upgrading Settings Workbook Taxes Misc Data Interface Database In-Cell Lookup Print Customers Creating Customer Editing Customer Customer Detail Products Creating Product Editing Product Product Detail Invoices Creating Invoice Editing Invoice Invoice Detail Payments Adding Payment Editing Payment Payment Detail Reports Generating & Printing Reports Setting Visible Columns Extracting Reports Common Tasks Using the Search Bar Using Data List Windows Importing Data into Excel Invoice Manager Networking Working with Form Properties File Free Invoice Form with Support for Incomplete Lines on Invoice Body Using Credit Note or Credit Memo Copying Report Worksheets from One Invoice Template to Another Two Versions of Customer Statement Report Custom Fields Custom Fields - Overview Custom Invoice Fields - Tutorial Customizing the Invoice Template Customizing the Invoice Template Tutorial: Creating an Invoice Template with Additional Rows Tutorial: Adding a Notes Field to Your Invoice Template Tutorial: Adding or Removing the "Same As Bill To" Button Tutorial: Adding a Clear button to the Report Worksheets Tutorial: Displaying Summary Information on Customer Statement Tutorial: Creating a Receipt Form Using Multiple-Line Address in Invoice Form Printable Invoice - Invoice Printing in a Flexible Way Adding Postcode Cells Manually to Invoice Template More Topics Registration and Services Reference
Online-Only Articles Billing Software Powered by Excel Buttons in the Template Don't Work Sample Invoice Template: Using handwriting Signature Sample Invoice Template: Using Drop-Down List Sample Invoice Template: Long Product Descriptions Sample Invoice Template: Using Line# as Product IDs How to: Password-Protecting an Invoice Template How to: Transferring Excel Invoice Manager to a New System How to: Removing Auto-created Macros from Your Invoice Template Creating a Packing Slip Template Modifying Standard Fields with Database Designer Sample Invoice Template: Replacing the Product IDs with Line Numbers Invoice Template with Support for Product-Type Specific Tax Rates Editing Paid Invoices Working with Multiple Companies or Currencies Sharing/Linking Tables between Access Databases Tutorial: Adding New Fields to Reports Sample Invoice Template: Displaying 'FREE' for Zero Values Customizing Header and Footer of Printed Invoices Customizing Invoice Template for Pre-printed Invoice Forms Charging GST Tax on Shipping Cost Invoice Form with Fixed or Static Product / Service Items
Home Contact Us Privacy Link to Us
copyright © Office-Kit.com, all rights reserved