Why does Excel keep printing blank cells?

J

John

I used to have that problem all the time too. After you
delete your rows or columns. Click back on cell A1 and
save your changes.
 
N

Nick Hodge

Dave and John

It is important you select the entire rows/columns that are blank and select
Delete NOT clear and then save the workbook. This resets the true UsedRange
in Excel.

Of course, for printing, you could use File>Print area>set print area to set
the area to print.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top