Blank rows

[Guest]

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.

 

[Nick Hodge]

Mark

Select the area to print and then File>Print Area>Set print area

You may also want to check out. ' Resetting Excel's 'UsedRange' here

http://www.nickhodge.co.uk/tipstrick.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[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.