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

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.

Use Excel's "Freeze Panes" functionality to lock rows or columns in place. Use Excel sort features to organize data in alphabetical or numerical order.

How to Disable Scroll Lock in Excel 2007. In Microsoft Excel, turning Scroll Lock on allows you to use the arrow keys to navigate your business spreadsheet without moving the cell that you have ...