Additional Pages

I keep having to format reports for my boss in excel and when I go in to page setup and change certain things, such as margins etc.. It creates extra pages and when I go to print preview I have to scroll up to get it to pull it to the appropriate number of pages. For example: I had a document that I changed to Landscape and changed the margins. When I did that it created like 20 extra pages and I had to hold the left pointer down at the bottom of the pages and scroll all the way up (very slowly I might add) to get it to show only the couple of pages I needed. The question is: Is there any easier way to do this?? HELP !!

Highlight the area that you want to print, then click File - Print Area - Set Print Area