Using PDF-eXPLODE™ with Microsoft® Excel®

Use one of the following alternative procedures to explode and send worksheets in an Excel workbook. The first procedure uses Excel's built-in page header feature but requires Excel 2007 if you want the PDF-eXPLODE tag to be hidden by changing the color to white. The second procedure offers a workaround that simulates a page header by repeating the top row of the worksheet on each page. This approach allows you to hide the PDF-eXPLODE tag by applying a white color in any version of Excel. The reason for offering both alternatives stems from the fact that while early versions of Excel allowed you to modify header and footer colors, the capability was removed beginning in Excel 4.0 and not replaced until Excel 2007.

Procedure A: Using an Excel Page Header

1. On the File menu, click Page Setup, and then click the Header/Footer tab.
2. Click Custom Header.
3. In the Left Section, enter the PDF-eXPLODE tag, for example: name@company.com
4. To add another PDF-eXPLODE tag, press enter to begin the tag on a new line.
5. If you are using Excel 2007, you may select the tag and click the Format Text button to apply the color white, thereby making the tag invisible.
7. Click OK twice.
8. Repeat for each worksheet in the workbook.
9. On the File menu, click Print.
10. Set the printer to PDFeXPLODE.
11. Use the Print what option to control which worksheets to explode. For example, to explode and e-mail all worksheets in the workbook, select Entire workbook, and then click OK.

Procedure B: Simulating a Page Header

1. On the first row of a worksheet, enter the PDF-eXPLODE tag, for example: name@company.com
2. To hide the tag, click the arrow next to the Font Color button on the Formatting toolbar, and then click the White color sample on the palette.
3. To add another PDF-eXPLODE tag, enter it on the next row.
4. On the File menu, click Page Setup, and then click the Sheettab.
5. To repeat the first row(s) on every page, use the Print titles option to select the Rows to repeat at top. For example, to repeat the first row the entry will be $1:$1. Finish by clicking OK.
6. Repeat for each worksheet in the workbook.
7. On the File menu, click Print.
8. Set the printer to PDFeXPLODE.
9. Use the Print what option to control which worksheets to explode. For example, to explode and e-mail all worksheets in the workbook, select Entire workbook, and then click OK.

There is a more powerful method of using Excel with PDF-eXPLODE by using VBA code which is described here: Update Excel Header or Footer with Cell Values

For more information, contact info@PDF-eXPLODE.com.

Microsoft and Excel are registered trademarks of Microsoft Corporation in the United States and/or other countries.