The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.
How to use:
This applies the green gradient effects to various titles and headings, resulting in a pastel and sophisticated design. The layout supports Excel themes, so you can change the colors easily.
This template has two columns: "Description" and "Line Total". The two columns are manually editable. A "Taxable" checkbox is also provided for each item, which allows you to control separately whether each item is taxable. If all your items are taxable (or not taxable), you may not need the "Taxable" options. If this is your situation, you can easily remove the "Taxable" options and then modify the tax formula to ignore this option.
To remove the "Taxable" options, follow the steps below:
- Backup your template.
- Click the "Design Mode" button on the ribbon tab.
- Click a "Taxable" checkbox to select it.
- Hit the DEL key on your keyboard to delete the selected checkbox control.
- Repeat the above steps to delete other "Taxable" controls.
- Exit design mode and save the template.
If you want to modify the tax formula to ignore the "Taxable" options, in design mode, click to select the tax cell (which is named "oknTax1"). The Excel formula bar shows the current tax formula, like this:
=ROUND( IF ( oknTaxType=0, 0 , oknTax1Rate * ( oknLineTotalTaxable + IF( oknTaxTotalIncludingShippingCost = 0 , 0 , oknShippingCost ) ) ) , 2 )
To have it ignore the taxable options, simply replace "oknLineTotalTaxable" with "oknSubtotal", so that the formula looks like this:
=ROUND( IF ( oknTaxType=0, 0 , oknTax1Rate * ( oknSubtotal + IF( oknTaxTotalIncludingShippingCost = 0 , 0 , oknShippingCost ) ) ) , 2 )
Format and Specification
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||36.00|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|