How can I print area with Freeze panes selected
If you are just cutting out a section in the middle, you can just select the
rows and hide them, use the fit to option in page setup and do the print,
then unhide them.
If you are just printing the bottom section and you only head a row or two
from the top, then select the bottom section alone and do File=>Print Area
=> Set Print Area
Then go to File=>Page Setup, go to the last tab, click in rows to repeat at
the top, then select the rows you want at the top.
In the first tab, select Landscape and Fit to 1 by 1
> I have a spreadsheet that has more info on it then I need for a report my
> boss needs. I thought that was easy enough to do, I freeze the pane and
> just what shows up after I move everything. Well it didn't let me set a
> print area. Is that even possible. Or I should ask, how do I select an
> for printing so it would fit on a landscape printer selection and show
> the stuff I need.