How do I print with hidden rows without gaps?

R

Rage for order

Office 2003 Excel. I've hidden certain rows from an excel sheet, but when I
print, the printout has large gaps where the hidden rows should be! I have
tried using Set Print Area to no avail. Does anybody know how I can print
whithout the gaps?
 
P

Pete_UK

I do this all the time and I don't get gaps (using XL 2000). I don't
know why you might be getting them.

Pete
 

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

How do I hide gaps in an Excel 2007 chart? 2
How can I print rows that go outside of the page without shrinking the text? 0
Text in 4-page Word 2016 table won't print 1
how can i print non adjacent pages from a worksheet 1
hidden rows, column copy-paste 0
Split Print Area: How to make it print to one page 3
Copy/Paste with Hidden Rows/Columns Excel 2007 3
I cannot delete the extra rows or columns in Excel 2007 2

Top