How to Have Excel Freeze Row and Column Data It's often useful to freeze header rows or columns in Excel while navigating through a spreadsheet.

In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...

To freeze a specific row, first, select the row immediately below the one you want to freeze. For example, if your headers occupy rows 1 and 2, select row 3 to keep the top two rows visible.

You use Microsoft Excel 's built-in function to freeze specific rows and columns (often row or column headers), so when you’re scrolling through, these cells remain stationary on the page.

Your Excel 2013 spreadsheets can benefit from page headers and fixed column titles, also called description rows. They allow readers to follow your pages and understand content easier, because the ...