Figure E Quickly applying a few formats to the subtotals and grand total in Excel helps them stand out a bit from the data by moving them to a column of their own.