Can Excel show the column headers on every screen? How to freeze panes and split screens How to freeze and unfreeze columns and rows in Excel.

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.

Sometimes it's necessary to split cells in a spreadsheet, and Microsoft Excel makes it easy enough to do.