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
I need my Hidden Rows to stay hidden when I print the sheet. 2
I cannot delete the extra rows or columns in Excel 2007 2
Printing Hidden Cells 8
How do I display a list of the rows or columns that I've hidden? 1
Copy/Paste with Hidden Rows/Columns Excel 2007 3
Dynamic Print Range with cells containing formulas ! 1
Unhiding rows in Excel 2007 5

Top