How to freeze rows in excel: Freeze columns and rows

Freeze columns and rows to keep them in view while you scroll through your data. Select the cell below the rows , and to the right of the columns you want to freeze . If you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Tap View > Freeze Panes, and then tap the option you need. How to hide and unhide columns and rows in an Excel worksheet. Restrict access to only the data you want to be seen or printed. 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 .