If Ace's suggestion doesn't produce the desired result then maybe consider (possibly with use of vba) copying the data to a new sheet laid out as it should be printed.