How can I print area with Freeze panes selected 
Author Message
 How can I print area with Freeze panes selected

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 show
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 area
for printing so it would fit on a landscape printer selection and show only
the stuff I need.


Mon, 12 Jul 2004 03:40:51 GMT  
 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

Regards,
Tom Ogilvy


Quote:
> 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
show
> 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
area
> for printing so it would fit on a landscape printer selection and show
only
> the stuff I need.



Mon, 12 Jul 2004 04:03:02 GMT  
 How can I print area with Freeze panes selected
Ahhhhhhhhhhhhh, many many thanks Tom, it worked.................Peter


Quote:
> 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

> Regards,
> Tom Ogilvy



> > 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
> show
> > 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
> area
> > for printing so it would fit on a landscape printer selection and show
> only
> > the stuff I need.



Mon, 12 Jul 2004 04:51:39 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Freeze Panes - How to Freeze multiple panes ???

2. Freezing multiple panes OR freezing pane and splitting simultaneously

3. selected area within a print area

4. selected area within a print area

5. Frozen Pane snaps back when selecting cells across it

6. Splitting panes and Freezing panes simultaneously

7. Printing Frozen Panes in multiple pages

8. Printing Frozen Panes headings top of every page

9. Printing/freeze pane

10. printing "freeze panes"


 
Powered by phpBB® Forum Software © phpBB Group