Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.

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.

While the method we're about to outline is intended to work with the modern version of Excel, you can freeze rows in older Excel versions roughly the same way. Open a spreadsheet in Microsoft Excel.