How to Float a Row on Excel 2007

1. Click the 'View' tab in the Ribbon.
2. Click the 'Freeze Panes' button in the Window group. This opens a drop-down menu. Click 'Freeze Top Row' to freeze the first row at the top of the spreadsheet. All other rows will disappear when you scroll through the spreadsheet, but the first row will stay in place.
3. Select an entire row in your spreadsheet by clicking its number in the left-most column, then click the 'Freeze Panes' button in the Window group. Select 'Freeze Panes' in the drop-down menu. All rows above the selected row will be frozen in place; all others, including the one selected, can be scrolled.