Input new field information - name: DescriptionManual size: 100.

Click the 'Invoices' button on the ribbon tab.

Starting from Invoice Manager for Excel version 5.25, the 'Design Mode' button takes care of the 'locked' property so that you don't have worry about this.

Click the 'Design Mode' button again to exit design mode.

This formula means that, if 'oknDescriptionManual' is empty, then show the default value 'Print documents, A4 paper' otherwise show the text from the 'oknDescriptionManual' cell. =IF(oknDescriptionManual='','Print documents, A4 paper',oknDescriptionManual)

Click to select the first 'Description' cell on the invoice detail section.

Click the 'Merge and Center' button on Excel 'Home' ribbon tab.

Choose an empty (not used) area outside of the printable invoice form to place the editable field.

Switch to design mode by clicking the 'Design Mode' button on the 'Invoice' ribbon tab.

Before you begin, make sure you have created a backup copy of the template, so that you can restore to a working version easy.

Sales Invoice Template with Discount Amount Column Sales Invoice Form with Discount Percentageįive Price Percentage Levels (Service, Custom Column)Ĭonsulting Invoice Template (2nd Sample of Customization) Hotel Receipt Format with Blue Gradient Design Hotel Guest Folios with Satisfied Business Traveler Here are our templates closely related to Excel Invoice Template With Automatic Numbering.

Without Invoice Manager for Excel, you have to use Excel macros, as detailed on Generate invoice numbers in Excel, or at Excel - A macro to perform the automatic numbering of invoices.

You can set the 'Next Number', 'Prefix' and 'Numbers of Digits in ID' options on the 'Database' tab of 'Settings' window. This automatic numbering generator is based on a counter stored in the backend database. When you click the 'Save Invoice' or 'Save To DB' button, Invoice Manager for Excel generates a unique, sequential and progressive (increment) invoice / receipt number if the cell is left blank.

Modern excel invoice template