ok small problem...
and before i explain it I cannot HIDE columns for this requirement because MS restricts you to a certain number of columns to hide. So I cannot accept the answer "hide those columns". What I need to do is select specific columns to print. So I do that while holding down the ctrl key. Then I select File->Set Print Area.

Now that works fine...but when I preview it each section that I want printed gets placed on a new page!!! I dont want that...I want excel to fit as much of those sections on a single page. I cant find any option that allows for that.

Surely there has to be a way....


Jon