That worked. Still need to do a bunch of formatting due to cell size
differences but the page breaks are gone. Thanks, Bob

"Gus" wrote:

In the goto box click on the special button in the bottom left corner.


I tried F5 as noted but it takes me to the Go To page. I don't see
anything
to click on for visible cells only?

Bob

"Jaleel" wrote:

After selecting and before copying the data, press F5 - special - visible
cells only - OK. Then copy and paste. Try this

"BobG" wrote:

I have a large database that I have sorted and selected out data that
meets
certain criteria and want to print the culled out set. The database
has page
breaks included which remain in the culled set but aren't wanted and
cause
the printing to print a few records and then hit a page break causing
the
print out to be many pages longer than what is viewed on the screen.
How can
I print just the view on the screen without the embedded page breaks
without
deleting the page breaks from the data set as they have functionality
when
the whole data set is viewed?
Thanks