How do I get rid of auto pg breaks in doc with hidden rows in Exce

G

Guest

When I try to print my doc, Excel puts auto page breaks like it was
reading/printing all the rows (including the hidden rows). I don't want to
print anything but the rows that are showing and I want to have everything on
one page.

Any suggestions?

Thank you
 
G

Guest

Select the range you want to print, click on File|Print, Select Preview, and
then tick the option to fit to 1 page tall and 1 page wide. Now click on
Print, while in Preview. Your document's size will be reduced to make it fir
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ignore page breaks for hidden rows 1
How do I print with hidden rows without gaps? 1
Weird auto page breaking that I can't get rid of... 6
Page Breaks - Can they be ignored? 2
Hiding rows and printing 1
Counting rows in a spreadsheet, but I don't want to count hidden r 1
Hidden rows in worksheet also hide borders 6
Excel Newbie - page break problem. 2

Top