Printing multiple pages per sheet

I'am trying to create a document which automatically prints the next page on the same sheet.

I have created a spread sheet which prints the first 5 rows in the top of every page, but I can't figure out how to make excel print two A4's on one A3 side-by-side.

Any suggestions how to do this? Is it even possible?

Best regards,
Fusse

This is printer functionality.

Look at your printer setup.

you need to select two pages on a sheet with sheet size a3, layout Landscape.

But then I get my header on every sheet twice.