How to Float a Row on Excel 2007

Save

"Floating" a row in Microsoft Excel 2007 refers to holding it in place so it remains visible in your spreadsheet while you scroll through it. This is also known as freezing a row in place. The ability to do this can be found in the Ribbon user interface at the top of the spreadsheet.

  • Click the "View" tab in the Ribbon.

  • 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.

  • 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.

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!