Or maybe you want to quickly compare data from two rows that are pages apart. This is where freezing rows will help you get to a more organized spreadsheet. Also: How to create a drop-down list in Excel
How to freeze rows in Excel
Step 1: Select the row below the one you want to freeze
If your table’s header is on row 3, then select row 4. The row above the one selected is the one that will freeze.
Step 2: Go to View and click Freeze panes
That’s it!
