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.

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

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.