All the formatting is done in your Excel template.
This applies to cell formatting (bold, color, etc.), cell vertical and horizontal alignments, etc.
You can even use conditional formatting. In this case, make sure you apply the formatting to at least the first 2 rows (same tick as for your totals, see How to add totals/calculations to your reports). The Demo Opportunity report uses conditional formatting on the total column.