Repeating Rows in Excel. When your Excel spreadsheet spans several pages, the data is easier to follow when you print the column titles at the top of every page. Instead of manually repeating the ...

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.

Alternatively, you could put the header row data in the document header. Thereby avoiding having to redo it every time. Merging into tables is a huge PITA, especially for a repeating report.

How to Make Excel Continue to Count Up for Each Row. Entering a series of sequential numbers into an Excel spreadsheet, one per row, can be a time-consuming and repetitive task.

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?