BoostExcel main content

Proforma (3rd Sample of Customization)

Template#: c7013

Download

DescriptionSizeDownload

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

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

Screenshot

The screen shot for Proforma (3rd Sample of Customization)

Detail

This is the third sample on how to create a new design for a pro forma invoice template, focusing on creating a drop-down list using the data validation feature of Microsoft Excel.

This template now has a lightweight (simplified) version. Visit it at Lightweight Proforma Invoice Format (c7039).

The original version (c7012) has a currency field that is manually editable. In this tutorial, we'll change it to a drop-down list. Here are the brief steps:

  1. First, choose a column (or row) to place the possible values.

    This should be an empty (not-used) area outside the printable form.

    In this example, we choose the range on the right side of the shipping address section.

    The possible currency types are the US Dollar, Euro, Pound Sterling, and Japanese Yen.

    You can enter more in the column; just make sure there are no blank (empty) cells between valid possible values.

  2. Select the cell where you want to implement the drop-down list. In this example, you select the currency field (the cell next to the label "Currency").
  3. Go to the Excel "Data" ribbon tab.
  4. In the "Data Tools" group, click "Data Validation".
  5. In the "Allow" box, click "List".
  6. To specify the location of the list of valid entries, do one of the following:
    • If the list is in the current worksheet, enter a reference to the list in the "Source" box, or click in the Source box and then select your list in the current spreadsheet to populate the reference automatically.
    • If the list is on a different worksheet, enter the name of the list into the "Source" box.
  7. Make sure that the In-cell dropdown check box is selected.
  8. To specify whether the cell can be left blank, select or clear the "Ignore Blank" check box.
  9. Optionally, display an input message when the cell is clicked.
  10. Specify how you want Excel to respond when invalid data is entered.

Tip: To delete a drop-down list, select the cell. Click the "Data" ribbon tab, and then click "Data Validation". On the "Data Validation" dialog box, click the "Settings" tab, and then click "Clear All".

Tip: The width of the drop-down list is determined by the width of the cell. You may need to adjust the width of that cell to prevent truncating the drop-down items.

Format and Specification

Template#c7013
Belongs to
Format (XLS or XLSX).xlsx
Columns7
Lines20
Line Height (Points)12.75
Print Area$F$3:$O$64
Papaer OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree

Related

Proforma Invoice Format in Excel Thumbnail
Lightweight Proforma Invoice Format Thumbnail
Proforma Invoice with Printable Earth Map Background Thumbnail
Pro forma Invoice for Collection Business in Thailand Thumbnail
Simple Proforma Invoicing Sample Thumbnail
Proforma (1st Sample of Customization) Thumbnail
Proforma (2nd Sample of Customization) Thumbnail