You may try experimenting with View>Page Break Review...
This allows you to manually set the print area visually. You may drag the
page boundaries (indicated by broken lines) to suit your needs. Actually you
can also print both landscape and portrait areas within a single worksheet.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.