Call Support: +1 (647) 557 5884

How do you configure headers and footers within the Custom Excel conversion option?


For multi-page reports, users may want to exclude the headers or footers from the table. This is controlled by the horizontal lines at the top and bottom of the page. The headers and footers appear as black lines that go completely horizontally across the top and bottom of the page.

To adjust the header, click on the Edit Header icon on the conversion panel. Then use your mouse and left click the header, hold, and move the mouse up and down to move where the header falls. To adjust the footer, click on the Edit Footer icon on the conversion panel, left click the footer line, and adjust accordingly.


In addition to manually adjusting the Headers and Footers, you can also enable or disable them throughout the selected page range through the Settings... option. This is helpful for tabular data that spans across multiple pages. You can decide to keep the first header, or you can opt to keep the data in the last footer.

Clicking on Settings... will give you the following Header/Footer Settings dialog:


Page Range: select the page range across which to apply your Header and Footer settings.

Check Enable Headers to adjust the Headers on the active page range and remove them from the output file. When only this option is checked, it will allow you to remove the (adjusted) headers from the output file. If at the same time you select Keep First Header, this will enable you to include only the first header on the page range. This can be useful when you need to keep a header at the beginning of a spreadsheet, but not throughout the rest of the document.

By putting a check in the Enable Footers options, you adjust the Footers so as to exclude their content from the converted file. You then have the option to select Keep Last Footer to keep only the last footer, but not the rest of the document. In some cases, these footers may contain a table summary or sums from the data set. This option will let you retain that content in the spreadsheet.



This article refers to Able2Extract and Able2Extract Professional.

Have more questions? Submit a request


Powered by Zendesk