You use Microsoft Excel 's built-in function to freeze specific rows and columns (often row or column headers), so when you’re scrolling through, these cells remain stationary on the page.

Rows in an Excel worksheet can be repeated a specified number of times with user-defined functions. The Selection.insert command can be used to insert rows in an Excel sheet and there is no need to ...

Use Excel's "Freeze Panes" functionality to lock rows or columns in place. Use Excel sort features to organize data in alphabetical or numerical order.

If you have an Excel table that's longer than one page, it's often helpful to repeat the header row at the top of every page or the row labels on the left side of every page—a feature that's ...

If your Excel table is longer than one page, it's often helpful to repeat the header row at the top of every page.

If you have an Excel table that's longer than one page, it's often helpful to repeat the header row at the top of every page or the row labels on the left side of every page—a feature that's ...

You will definitely need to copy the "group" header info into fields for each row, or else you'll lose that information if you try to sort it.<BR><BR>Are you averse to using/writing a macro?