Excel FAQs
How Can I Use a Merge Feld within a Formula?
For merge fields that will be referenced by other fields using Excel formulas, we’ve found the easiest way to approach this is to place merge in a non-printing area of the worksheet or on a separate worksheet.
Then, in formulas elsewhere on the spreadsheet, use the cell coordinates to refer to the value.
Use =CONCATENATE(…)
to join field values together. The abbreviated (“&”) function is not supported. When converting from Excel to PDF, use CONCATENATE instead of CONCAT
Converting to CSV
Composer is not compatible with CSV as a template type. However, after merging an Excel template you can download the output file and save it as a CSV (comma delimited) file if desired.
How Do I St the Printable Area of the Spreadsheet?
You can flag the portion of the spreadsheet you want to print. To identify the part of the spreadsheet currently specified to print, choose
Word 2003: Choose
.Word 2007: On theSet Print Area. Choose to return to the previous view mode.
, and then clickHow Can I Determine which Sheets to Include in an Output PDF?
Excel will highlight the “selected” sheets in white, while the non-selected sheets will remain with a gray background.
In this example, “Sheet1” and “Sheet3” are selected and would be the sheets included in a PDF generated from this template.
What’s the Best Way to Format Text Paragraphs?