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

Using Multiple-Line Address in Invoice Form

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:

  1. Copy your invoice template to make a backup, and then open the invoice template in Microsoft Excel.
  2. Unprotect the Invoice worksheet. (How?)
  3. Switch to design mode. (How?)
  4. Display gridlines and row/column headings. (How?)
  5. 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.

    Increase the height of the Address row to create an invoice form allowing multiple-line address
    (Click to enlarge)

  6. 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.

    Set cell format for the invoice form
    (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.

  7. 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.
  8. 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.
  9. 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.
  10. Once finished, exit design mode.
  11. Hide gridlines and row/column headings.
  12. Protect the Invoice worksheet.
  13. Save the template by clicking Excel menu File -> Save in Excel 2000/XP/2003, or by clicking Office button -> Save in Excel 2007.

 
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 Applying Discounts
Home Contact Us Privacy Link to Us
copyright © Office-Kit.com, all rights reserved