You can set options to preserve the formatting of a report when
exporting to Excel. Then when you view the report in Excel, the fonts, colors, and other formatting match your original QuickBooks
Open the report you want to export.
Click the Excel drop-down arrow at the top of the report.
Select whether you want to create a new worksheet or use the report data to update an existing worksheet.
About exporting data to an Excel or CSV file
In the Send Report to Excel window, click the Advanced button.
In the Advanced Excel Options window, select the formatting options you want.