BoostExcel main content



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:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
334 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.


Standard On-sheet Buttons


This document summarizes the button names on the sheet. It also shows how to add the standard buttons to the sheet if you're using a very old version.

If you are using a template that does not have buttons on the sheet, here is how to add them.

  • Backup your template.
  • Open it as usual.
  • Switch to design mode by clicking the "Design Mode" button on the ribbon tab.
  • Go to the Excel "Insert" ribbon.
  • Click "Text Box" in the "Text" group, and click the location on the sheet where you want to put the button. Excel creates a new text box on the sheet and puts the control in text editing mode.
  • Enter the button caption text, such as "Customers".
  • Click the corner of the text box. This exits text editing mode and selects the text box itself.
  • Go to the "Format" ribbon tab (This tab shows only when the shape object is selected).
  • In the "Shape Styles" group, click the "More" down-arrow on the preset style list to show the list of all preset theme fill effects. Choose one of the fill effects you like.
  • Name the text box by entering the name in the name box located on the left end of the Excel formula bar. For example, the text box labeled "Customers" should be named "oknCmdCustomer".
  • Now right-click the control and choose "Assign Macro".
  • Enter the following macro command:


    Note: You don’t have to create this macro command. It is provided by our invoicing app.

  • Repeat the above steps to add all the other buttons. See the table below for button names and captions.
  • Once done, exit design mode.
  • Save the template.

The following table shows all the button names and captions assigned to each button.

1Clear & NewoknCmdClear
2Save To DB (Save Invoice)oknCmdSave
3Extract / EmailoknCmdExtract
13As As New CustomeroknCmdSaveAsNewCustomer
14Customer EditoknCmdCustomerEdit
15About / RegistrationoknCmdAbout
16Same As Bill TooknCmdSameAsBillTo
17Pick Customer 
18Pick Shipping Address 
19Pick Sales Rep. Name 
20Pick "Ship Via" / Shipping Method 
21Pick Payment Term 
22Pick Product / Item 

Format and Specification

Belongs to


Format (XLS or XLSX).xlsx
Line Height (Points)18.00
Print Area$D$3:$K$46
Papaer Size / OrientationPortrait
Default Margins (Points)
PriceFree (0.00USD)


Standard Business Invoicing Template with Oval Button
Standard Invoicing Template with EAN
Advanced Sample: Macro-Enabled Invoicing Template
Standard Invoice with Double Border
Simple Sample: Changing Paper Size
Freight Invoice
Invoice with Remittance Slip