You can freeze a row in Excel through the "Freeze Panes" menu. This lets you scroll through a spreadsheet without that frozen data leaving the screen.
It's easy to divide in Excel to make calculations and analyze data in a spreadsheet. Here's what you need to know to do it.