split table header row

I've searched on this, but everyone is working with bom tables, not general:

I've a design table with 150 configurations. In the Excel file, I've used Custom Views to get the spreadsheet/table to look the way I want.

Since I need to split the table over several pages of the drawing, I'm creating a general table, and then copying in the Excel data (version 2016, btw).

When I split the table, the header row doesn't copy along. Is there a way to make this happen? (other than inserting a row and copying the header over cell by cell)

I watched a Hawkridge video where this worked, but they were messing with a BOM table for an assembly, not a part table.

SolidworksConfigurations/design Tables