You can let either Smart View or Excel control grid formatting.
Using Smart View Formatting
Using Excel Formatting