Dynamically Scaling pages based on page breaks

[Kalvas]

Is there anyway I can make excel scale a set amount of information between page breaks fit 1 page wide 1 page tall? using a macro.

FT000010	SPAX SCREWS 1000pc TRADE PACK	Llandeilo	4	0	0	0.1725	2	6
FT000010	SPAX SCREWS 1000pc TRADE PACK	Ammanford	0	0	0	0.0515	0	1
FT000010	SPAX SCREWS 1000pc TRADE PACK	Home centre	0	0	0	0	0	0
FT000010	SPAX SCREWS 1000pc TRADE PACK	Ystradgynlais	0	0	0	0.5567	4	9
FT000010	SPAX SCREWS 1000pc TRADE PACK	Carmarthen	0	0	0	0.5117	0	16
FT000010	SPAX SCREWS 1000pc TRADE PACK	Llanelli	0	0	0	0.5994	0	21
FT000010	SPAX SCREWS 1000pc TRADE PACK	Port Talbot	0	0	0	0.0001	0	4
FT000010	SPAX SCREWS 1000pc TRADE PACK	Pembroke Dock	0	0	0	0.5714	2	15
FT000010	SPAX SCREWS 1000pc TRADE PACK	Swansea	0	0	0	0.0231	0	0
FT000010	SPAX SCREWS 1000pc TRADE PACK	Cardigan	0	0	0	0.0011	0	12
FT000010	SPAX SCREWS 1000pc TRADE PACK	Neath	0	0	0	1.5262	0	21
FT000010	SPAX SCREWS 1000pc TRADE PACK	Caseys Roofing	0	0	0	0	0	0
FT000010	SPAX SCREWS 1000pc TRADE PACK	Maesteg	0	0	0	0.2162	1	2
FT000010	SPAX SCREWS 1000pc TRADE PACK	Total Plumbing Port Talbot	0	0	0	0	0	0
FT000010	SPAX SCREWS 1000pc TRADE PACK	Total Plumbing Pembroke Dock	0	0	0	0	0	0
FT000010 Total			4	0	0	4.2299	9	107

<tbody>
</tbody>

I essentially have this data repeated multiple times depending on how many products I am looking at, I would like this repeated 3 times per page, which is where the page breaks are currently being placed. When i tried to set Width 1 page the automatic page breaks would only allow two of these per page at 100% scaling.

any help you could give me with this would be greatly appreciated.

 

[Kalvas]

Oh and if its entirely possible to scale the length of the cells to use the full width.