This means that no matter where you scroll in the spreadsheet, those rows or columns always stay visible.Īlong with the freeze feature in Excel is a lock option. One small feature that makes it easier to manage all of that data is the ability to freeze rows and columns.

With thousands upon thousands of rows and columns, it can get pretty unwieldy.

You can fit a lot of data into an Excel sheet.