Unwanted Pages

[Ed O'Brien]

I have a workbook with six sheets. Four of these sheets behave quite
normally.

However, one sheet, which should print on onto two pages, shows four pages
in Print Preview. The extra (unwanted) two pages have a continuous line down
the left hand side. No matter what I do I cannot get rid of this line. It
appears like a border but deleting all borders, highlighting all the cells
and deleting them and checking in Format/Cells/Borders shows nothing.

The other rogue sheet should should print on only two pages but shows six
pages in Print Preview. The last four are completely blank except for one
(Page 5) which has a couple of entries that mean nothing. No matter what I
do I cannot delete these rogue entries. I have unlocked all cells and the
sheet is Unprotected. The last sheet of these six shows nothing.

In both cases I have highlighted all cells below the legitimate entries
across double the width of the page and below by at least ten pages before
hitting "Delete".

Has anyone had this experience and resolved it that can help me?

TIA

Ed

[Ed O'Brien]

Not to worry....

I went into "Page Break" view, found the offending elements and was able to
selete them.

All is now okay.

Ed



"Ed O'Brien" <edward.j.obrien@deletebtinternet.com> wrote in message
news:%23Cs0H$ypGHA.4932@TK2MSFTNGP05.phx.gbl...
>I have a workbook with six sheets. Four of these sheets behave quite
>normally.
>
> However, one sheet, which should print on onto two pages, shows four pages
> in Print Preview. The extra (unwanted) two pages have a continuous line
> down the left hand side. No matter what I do I cannot get rid of this
> line. It appears like a border but deleting all borders, highlighting all
> the cells and deleting them and checking in Format/Cells/Borders shows
> nothing.
>
> The other rogue sheet should should print on only two pages but shows six
> pages in Print Preview. The last four are completely blank except for one
> (Page 5) which has a couple of entries that mean nothing. No matter what I
> do I cannot delete these rogue entries. I have unlocked all cells and the
> sheet is Unprotected. The last sheet of these six shows nothing.
>
> In both cases I have highlighted all cells below the legitimate entries
> across double the width of the page and below by at least ten pages before
> hitting "Delete".
>
> Has anyone had this experience and resolved it that can help me?
>
> TIA
>
> Ed
>