How to freeze rows in excel: If you scroll down your worksheet but

If you scroll down your worksheet but always see the same top rows , they're locked in place (frozen). Use the Unfreeze Panes command to unlock those rows . 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. How to lock cells in Excel to protect your data. You can also unlock a range of cells and grant permissions to others to edit. If the Print Titles ribbon button is grayed out, check to ensure that you’re not currently editing a cell or an area chart. Also, check to verify that at least one printer is set up in Windows. On the Sheet tab, in the Rows to repeat at top box, type "$1:$1" (as shown in the figure).