BoostExcel main content

Simple Sample: Moving Balance and Payment Cells

Template#: c5075



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.
388 KBDownload

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


The screen shot for Simple Sample: Moving Balance and Payment Cells


The default template includes two payment-related fields on the bottom of the form: "PAID" and "TOTAL DUE". If you take advance payments, these cells would be useful as they tell your customer how much they owe. If you don't take advance payment, you may not want to show these two cells on your invoices.

Let's see how to move the cells out of the printable area.

  1. Open the template as usual.
  2. Switch to design mode.
  3. Now drag your mouse to select all the cells you want to move. Once all the cells are selected, release your mouse key.
  4. Push your mouse key on the border of the selected area and drag it to a location outside the printable form.
  5. Once finished, click the Design Mode button on the ribbon tab again.

Note that it is not recommended to delete the "oknPayments" and "oknBalanceDue" cells.

Format and Specification

Belongs to
Format (XLS or XLSX).xlsx
Line Height (Points)18.00
Print Area$D$4:$K$48
Papaer OrientationPortrait
Default Margins (Points)


Invoice Template with Credit Card Payment Option Thumbnail
Advance Payment Invoicing Format Thumbnail
Invoice Sample with Partial Payment and Payment History Thumbnail
Service Invoice with Payment Advice Thumbnail
PayPal Payment Button Using Custom Image Thumbnail