Enable automatic column filtering (Auto-filter): Check the check box if
you want to be able to AutoFilter columns of data in the Excel worksheet.
AutoFilter arrows will appear in columns that can be filtered to display a
range of data. For example, if you enable AutoFiltering for the Aged
Receivables report, in the Excel worksheet you’ll be able to filter the
report by customer ID; use the AutoFilter arrows at the tops of the
columns of data.
If you choose to show the header (title) information on the Peachtree report,
then you can also elect to
Send header to Page Setup in Excel: Select this option if you want the
Peachtree report header information to appear on the Header/Footer tab
of the Excel Page Setup window but not appear in the onscreen version of
Show header in Excel worksheet: Select this option if you want the
report header to appear in the onscreen version of the worksheet but not
be available for customizing in the Excel Page Setup window.
Finally, if you’re using Peachtree Complete Accounting or higher, you have
two more options:
Peachtree report layout: Select this option if you want the data to appear
in the Excel worksheet with columns and rows formatted as in the
original Peachtree report. The example box at the bottom of the Copy
Report to Excel window will give you a preview of how the report will
look when copied to Excel.
Raw data layout: Select this option if you want the data to appear in the
Excel worksheet with columns and rows unformatted regardless of the
formatting in the original Peachtree report. See the Example box for a
preview of the report in Excel.