Lock specific rows or columns in place by freezing panes, so you can scroll through an Excel spreadsheet and still see the top row or left column. You can freeze just the top row and first column or multiple rows and columns.
To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.
Freeze panes to lock the first row or column in Excel for Mac
Freeze panes to lock the first row or column in Excel for iOS
SlashGear: How To Freeze A Row In Microsoft Excel And Google Sheets
Business Insider: How to freeze a row in Excel so it always stays on the screen, even when you scroll away
You can freeze a row in Excel so it's easier to compare data as you scroll through the spreadsheet. You can choose to only freeze the first visible row in your Excel sheet, or freeze multiple rows. To ...
How to freeze a row in Excel so it always stays on the screen, even when you scroll away
USA Today: Learn to organize your data: Here's how to freeze a row or column in an Excel spreadsheet
Learn to organize your data: Here's how to freeze a row or column in an Excel spreadsheet
It's often useful to freeze header rows in place in Microsoft Excel to remember what type of data is in various columns as you scroll or search through a lengthy spreadsheet. You can also make sure ...