I agree, it is annoying.
Like... Excel, import my data. Don't assume you know better than I do how it should be formatted...

I digress...
I did find that you can shift-click the first/last column and apply-all rather than going column by column when picking formatting.

That certainly made it suck 8% less.