Blank rows

M

Mark

How can I stop blank rows from printing at the bottom of the spreadsheet. I
try to delete the empty rows but they still print.
 
D

Dave Peterson

You could check to see if what excel sees as the last used cell is the same as
what you think it should be.

You could reset it by using techniques at Debra Dalgleish's site:
http://www.contextures.com/xlfaqApp.html#Unused

Another technique would be to explicitly set the print range.
File|print area|set print area

And if you have formulas in cells that evaluate to "" so the cell's look empty,
but really aren't, you may want to consider using Data|filter|autofilter. Then
you could show only the non-blank values in a certain column.
 
Top