You can also use panes to freeze headings in the top rows and first columns so. Freezing them on the screen, you can keep the column headings in row 2 that.
How to freeze multiple rows and / or columns in (Excel tips #6) Looking for a full training course on Excel? Go to Excel University Follow me on other media: ►Website: ►Facebook: ►Twitter: ►Google+: Music used: Funky Junky (audionautix.com) Annotations: Select the cell that's in the first column and row you don't want to be frozen. In this case 'C3'.
Click 'View' → 'Freeze Panes' and click the first option, 'Freeze Panes'. You now have multiple rows and columns frozen. This means they'll stay visible when you scroll.
To unfreeze the rows and columns, it doesn't matter which cell you select. Simply click 'Freeze Panes' in the 'View tab'. The first option is now replaced by 'Unfreeze panes'. Click this to unfreeze the panes.