Blank rows
 

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.

Mark

Select the area to print and then FilePrint AreaSet 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
HIS


"Mark" wrote in message
...
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.

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.

Mark wrote:

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.

--

Dave Peterson