Delete a blank worksheet in excel

cherry76

Am having problem deleting a blank work sheet in excel  office 2010.  I have tried the option of printing current page and still get the other page printed with some gridlines,  A waste of paper it is not complete blank.  I have followed some advice on the internet and still cannot delete.  Thanks.

Neil_Jones

Right-click on the tab of the empty worksheet on the bottom and delete.

Robin9

Do you mean page as in a second page of a document  or a second sheet as Neil has said above.?
If a page - anything in any one of the cells will cause it to be printed. Highlight the page and clear contents of cells.

Flash32

I've had the same problem - when printing a worksheet, a load of apparently blank columns or rows also prints causing either blank pages or blank grids to be printed.  The cause is usually a character in a cell, but not always - a format change or fill in a cell that is not visible - e.g. fill->white etc., - can also do it.  The answer is to first make certain you've saved the workbook, then select a load of columns to the right of your data or rows underneath of your data, then delete the selected columns or rows (right-click any selected column or row, then click delete in the small menu that appears).  You should find this fixes the issue.  Good luck!

victor2

You can find where Excel thinks the botom right corner of the current sheet is by tapping the End key, then the Home key. A cell in that row or column will have something in it. If it isn't wanted, delete it. Or just delete that column/row.

Do save a copy of the worksheet under another name before you start deleting columns or rows though!

Neil_Jones

Setting the print area might be useful too.  Excel by default tries to be clever in this regard, but is rarely any good.  If you set the print area to a range of cells it will only print those cells.  Make use of Print Preview as well.