How to Freeze Panes in Excel: Rows, Columns and Both
- Tahir Abbas
- November 18, 2026
When a worksheet has hundreds of rows, the column headings scroll out of view and you forget which column is which. Freeze Panes solves this by keeping chosen rows and columns on screen while the rest of the sheet scrolls. It takes only a few clicks and makes large tables far easier to read, check

