Printing & Print review?

[Richard]

I have 168 pages of excel to print on legal paper (14 inch) and I'm using
2002 or XP excel with Vista Ultimate. I change the margin and do a auto Fit
on the ROW (I have to do a hundred of them) and nothing happens so I do a
manual like changing it form 85 to 75 but when I print it, it has a big gap
in the cell where another sentence should be. I go and do a print review and
sure enough there is a big gap but on my spread sheet it looks OK, so I
guess I need to do an auto fit that works. Can anyone help?

Richard

 

[damorrison]

Is the print area set, for each sheet?

 

[Richard]

Is the print area set, for each sheet?

It's one file with 168 pages so when you set the print area, it's for the
entire file which contains 168 pages