I use excel constantly, and some things I require are freezing panes, autofitting the columns, adding auto filters, and standardizing the row heights. Here's the code for the macro I use, and I shortcut it with Ctrl+J.
' MakeSpreadsheetReadable Macro
' Macro recorded 5/23/2011 by Gullo, Joseph T. *HS
' Keyboard Shortcut: Ctrl+j
ActiveWindow.FreezePanes = True
ActiveWindow.Zoom = 70
Selection.RowHeight = 12.75