You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
Screenshots and Images
The printed version.
Open the template in Excel.
This is the standard (default) invoice template shipped with Invoice Manager for Excel installer program but with double-border added. This sample template also demonstrates how to add row, column to an existing form and redefine the printable area.
Here by the word "standard" we mean the default invoice template shipped with Invoice Manager for Excel. All the invoice templates here on InvoicingTemplate.com are variants of the standard invoice template. As long as you adhere to the rules defined in Customizing Invoicing Templates, the result template will work with Invoice Manager for Excel. That means Invoice Manager for Excel is able to provide all the powerful functionalities such as the search bar for locating customers, products and invoices, reporting worksheets, etc.
The standard invoice template is a sales invoice template that is designed to be flexible and basic. The design contains only one logo image placeholder, some solid fill effects on the text titles. Adding decorations to this existing template could change the look and feel of the template quickly. Want your invoices differ from others like your business? Microsoft Excel provides powerful and easy to use tools for you to make your very own invoice formats.
Here we look at how to add a double border surrounding the entire printable invoice form.
Step 1: Before doing our customizing job, first you have to back up the template.
Step 2: Open the template as usual. Click the "Design Mode" button on the "Invoice" ribbon tab.
Step 3: Add one row to the top, one row to the bottom, one column to the left edge and another column to the right edge of the printable invoice template. For example, to add a row to the top of the printable form, you need to do the following steps.
- Make sure the "Invoice" worksheet is the active sheet. Click the "Down arrow" button on the name box located on the left side of the formula bar. Excel shows all the names in a drop down list.
- Scroll the drop down list till bottom.
- Click and select "Print_Area" from the list.
- Excel selects the cells that defined by the "Print_Area" name - this is the printable form that will be printed when you issue the "Print" command, or will be extracted when you click the "Extract/Email" button. When generating PDF invoices, the printable area defined by the "Print_Area" will also be respected.
- Right-click the heading of the first row on the printable area. Choose "Insert". This adds one row above the top of the current printable area.
To add a column to the left of the first column of the printable area, right-click the heading of the first column of the printable area, and then choose "Insert" from the shortcut menu.
You can add new row / column to the bottom, right edge of printable form, or skip this procedure since the right and bottom direction already have empty columns / rows there.
Step 4: Drag your mouse to select all the range for the new printable form - this is the area that has one row / column expanded to the top, bottom, left, right edge of the original printable form. In this sample, we selected the area addressed at $C$2:$L$48. Now go to Excel "Page Layout" ribbon tab and from the "Page Setup" group, click "Print Area" and then "Set Print Area". This defines our new print area.
Step 5: Add left-border to the left-most column.
- Drag your mouse to select the entire new "Print_Area". In this sample, it is $C$2:$L$48. Tip: you can just the the "Print_Area" name from the name box on the formula bar.
- Right-click one of the select cell and choose "Format Cells".
- Go to the "Border" tab.
- From the "Style" list, choose the double-border style.
- Choose a proper color.
- In the "Border" section, click the borders respectively.
- Click OK to close the "Format Cells" dialog box.
Step 6: Adjust the height of the newly added rows, adjust width of the newly added columns, to make proper margins between the borders and actual content.
Tip: You can click Excel menu File / Print. This shows the print preview of the current print area. Here you can change the column widths by dragging and dropping. Make sure to leave proper spaces between the double-border lines and actual content, and proper space between double-border lines and paper margins.
Once you have done the fine-tunes, exit design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab. Click Save command on Excel quick access toolbar to persist the customizations.
Format and Specification
|Name||Standard Invoice with Double Border|
|Category||Sales Invoice Template|
|Release Date||Friday, July 1, 2016|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||18.00|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|System||Windows 7 and later, and Excel 2007 and later.|
April 23, 2020
- Optimized the links to online resource.
- Linked to Invoice Manager on Microsoft Store.