I have a spreadsheet that when printed covers six pages, some pages reach the margins some don't.

How can I make it that each page fills the A4 page?

in FILE there is an option to set the print area.

Also check that you have it on landscape as if you try to print out a 'wide' sheet a portrait page will not fit.