Print only unhidden rows
 

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?

Print only unhidden rows
 

If the rows are hidden, they shouldn't print if you print normally.

In article ,
fstone09 wrote:

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?

Print only unhidden rows
 

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?

"JE McGimpsey" wrote:

If the rows are hidden, they shouldn't print if you print normally.

In article ,
fstone09 wrote:

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?

Print only unhidden rows
 

Sorry, that should have been "I cannot move the blue line..."

"fstone09" wrote:

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?

"JE McGimpsey" wrote:

If the rows are hidden, they shouldn't print if you print normally.

In article ,
fstone09 wrote:

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?

Print only unhidden rows
 

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.



In article ,
fstone09 wrote:

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?

"JE McGimpsey" wrote:

If the rows are hidden, they shouldn't print if you print normally.

In article ,
fstone09 wrote:

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?

Print only unhidden rows
 

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!


"JE McGimpsey" wrote:

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.



In article ,
fstone09 wrote:

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?

"JE McGimpsey" wrote:

If the rows are hidden, they shouldn't print if you print normally.

In article ,
fstone09 wrote:

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?

Print only unhidden rows
 

Can't you just hide the blank rows?

In article ,
fstone09 wrote:

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!


"JE McGimpsey" wrote:

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.



In article ,
fstone09 wrote:

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?

"JE McGimpsey" wrote:

If the rows are hidden, they shouldn't print if you print normally.

In article ,
fstone09 wrote:

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?

Print only unhidden rows
 

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.)

"JE McGimpsey" wrote:

Can't you just hide the blank rows?

In article ,
fstone09 wrote:

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!


"JE McGimpsey" wrote:

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.



In article ,
fstone09 wrote:

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?

"JE McGimpsey" wrote:

If the rows are hidden, they shouldn't print if you print normally.

In article ,
fstone09 wrote:

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?

Print only unhidden rows
 

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.



fstone09 wrote:

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!

"JE McGimpsey" wrote:

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.



In article ,
fstone09 wrote:

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?

"JE McGimpsey" wrote:

If the rows are hidden, they shouldn't print if you print normally.

In article ,
fstone09 wrote:

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?



--

Dave Peterson

Print only unhidden rows
 

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.

"Dave Peterson" wrote:

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.



fstone09 wrote:

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!

"JE McGimpsey" wrote:

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.



In article ,
fstone09 wrote:

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?

"JE McGimpsey" wrote:

If the rows are hidden, they shouldn't print if you print normally.

In article ,
fstone09 wrote:

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?



--

Dave Peterson

Print only unhidden rows
 

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!


"fstone09" wrote:

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.

"Dave Peterson" wrote:

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.



fstone09 wrote:

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!

"JE McGimpsey" wrote:

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.



In article ,
fstone09 wrote:

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?

"JE McGimpsey" wrote:

If the rows are hidden, they shouldn't print if you print normally.

In article ,
fstone09 wrote:

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?



--

Dave Peterson

Print only unhidden rows
 

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

fstone09 wrote:

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!


"fstone09" wrote:

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.

"Dave Peterson" wrote:

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.



fstone09 wrote:

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!

"JE McGimpsey" wrote:

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.



In article ,
fstone09 wrote:

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?

"JE McGimpsey" wrote:

If the rows are hidden, they shouldn't print if you print normally.

In article ,
fstone09 wrote:

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?



--

Dave Peterson


--

Dave Peterson