7 Excel tips for huge spreadsheets: Split Screen, Freeze Panes, Format Painter and more The bigger and uglier your spreadsheet is, the more you need to keep a handle on the data.