Skip to main content main content

Settings / Incell-lookup Tab

- Document for Excel Invoice Manager

 Share This Page

This version of the document, "Settings / Incell-lookup Tab", was written for Excel Invoice Manager, which was now renamed to Uniform Invoice Software. For the latest version of this document, please download Uniform Invoice Software.

Click the Settings button on the Invoice worksheet to open the Settings window.

Invoice settings - incell lookup
Incell lookup(Click to enlarge)

The In-Cell Lookup feature allows you to retrieve a customer, a product or an invoice by typing the corresponding ID value right within the Invoice worksheet. For example, if you want to enter information about a product, which has an ID value of "345789", into the second line of the invoice body, all you need to do is to type "345789" into the "Product ID" cell on that line.

The in-cell lookup feature is also useful for users who use barcode as the product IDs. Simply activate/click the cell in which you want to place the product ID, and then scan the barcode as usual. You don't need to bring up the product selection box again and again.