Print only unhidden rows

F

fstone09

How do I print only the unhidden rows on a worksheet?
I've tried custom views and print selection only, but neither of those
worked.
Anything else I'm missing?
 
F

fstone09

You're right. But what I'm trying to do is print something on one page
without all the blank pages in between. I'm printing rows on page 1 and page
9, and I can move the blue line in page preview to show it as one page. Any
ideas?
 
J

JE McGimpsey

So what rows are hidden?

If all the rows between pages 1 and 9 are hidden, only one (or two,
depending on how many unhidden rows are in those pages) will print.
 
F

fstone09

All 9 pages print. Pages 2 thru 8 are blank except for the header row. My
solution was to print page 1 and then page 9. That'd be okay if I didn't
have 40 files to print with similar problems.

What's really strange is that on a couple of files, I could print the eight
non-contingent rows I needed on one page. On another couple of files I could
move one or two of the blue lines for page break but not the others.
Obviously something is controlling or blocking what I want to do on most of
my files.

Now my boss wants me to copy and paste the rows to a new spreadsheet so
they're all together. Here goes another day!
 
J

JE McGimpsey

Can't you just hide the blank rows?

fstone09 said:
All 9 pages print. Pages 2 thru 8 are blank except for the header row. My
solution was to print page 1 and then page 9. That'd be okay if I didn't
have 40 files to print with similar problems.

What's really strange is that on a couple of files, I could print the eight
non-contingent rows I needed on one page. On another couple of files I could
move one or two of the blue lines for page break but not the others.
Obviously something is controlling or blocking what I want to do on most of
my files.

Now my boss wants me to copy and paste the rows to a new spreadsheet so
they're all together. Here goes another day!
Click to expand...
 
F

fstone09

The hidden rows are not blank; they do have data. However, even though they
are hidden, they are still generating the printed blank pages on pages 2 thru
8.
(Perhaps I'm not explaning this clearly.)
 
D

Dave Peterson

If you add manual pagebreaks to your range, then those pagebreaks will cause
those pages to be printed--even if they're between hidden rows.

Maybe you can remove the manual pagebreaks and print.

Or maybe you can copy the visible rows to a different worksheet and add the
pagebreaks that you want.
 
F

fstone09

Thank you, Dave. There probably are manual page breaks on most of the files.
That explains why it was printing multple pages. I'm in the process of
copying the worksheets and deleting the rows I don't need. It's a slow
process that I was hoping to avoid.
 
F

fstone09

Solution: In "Page Break View" right-click any cell and select "Reset All
Page Breaks" to remove the manual page breaks. The worksheet can then be
printed as viewed.

Thanks to all who contributed to this discussion. It has been a tremendous
help!
 
D

Dave Peterson

I'm surprised that you wanted to remove all the pagebreaks. But glad it worked
for you.

You can also remove the pagebreaks via
select all the cells
Insert|Reset all page breaks
 
Top