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.

How Do You Create a Header Row & Description Row in an Excel Spreadsheet?. Your Excel 2013 spreadsheets can benefit from page headers and fixed column titles, also called description rows.