Forum Discussion
Feature Request: Repeat Rows at Bottom of Printed Pages
Until Excel has that option, the footer gets you closest, because it prints on every page no matter how many rows the query returns.
In Excel for Windows: Page Layout tab > Page Setup dialog launcher > Header/Footer tab > Custom Footer. Click in the Left section and type one line, for example:
Item: ...................... Qty: ........
Press Enter and repeat it for as many lines as you need. Five lines like that come to about 220 characters, and a header or footer holds 255.
Then on the Margins tab raise Bottom (we tried 1.9 inches with Footer at 0.3 on a 180-row list) so the lines print below the data instead of over it; the footer distance has to stay smaller than the bottom margin. It's page setup, so it survives every Power Query refresh. The catch is that footer lines are text, not cells, so no borders or column alignment.
For the request itself, Help > Feedback inside Excel is the route Microsoft gives for suggestions.
(Drafted with AI assistance and checked before posting.)