Mysterious "Arc" appearing at the bottom of the page

[PlarfySoober]

When I either Print Preview or print my spreadsheet (I got it from another
guy who is sort of nutsoid), I get a large, wide-line arc printing at the
bottom of each page. It obscures part of the footer and several lines of the
data.

I looked in footer, comments and would have looked in watermark but could
not find mention of it.

There WAS a footer, but I deleted it in desperation. No help. There don't
appear to be any comments anywhere. Yet this large arc, ~ 1/2 circle,
protrudes.

Does anyone know how this could happen? BTW, maybe not relevant, but the
previous owner made the spreadsheet 655 pates long. The actual data is on 5
printed pages.

Thanks.

 

[Sean Timmons]

1) nutsoid! hah!

2) to enter a "watermark" in Excel, you'd just enter a picture into the
header and formwat to washout - purely an FYI

3) size of file wouldn't matter. Just someone who doesn't know how to delete
whitespace.

4) sounds like a drawing toolbar object. Assuming your header and footer
truly do not have anything in them at all, check your code. Right-click on
the tab and look for any kind of code that would enter anything in the header
or footer section of the document...

 

[PlarfySoober]

Sean,

Thanks for replying.

1) nutsoid! hah!

2) to enter a "watermark" in Excel, you'd just enter a picture into the
header and formwat to washout - purely an FYI

3) size of file wouldn't matter. Just someone who doesn't know how to delete
whitespace.

Like me, I'm afraid. There's a way to do it?

4) sounds like a drawing toolbar object. Assuming your header and footer
truly do not have anything in them at all, check your code. Right-click on
the tab and look for any kind of code that would enter anything in the header
or footer section of the document...

I actually deleted all three of the footer "objects", by deleting all the
text that was visible in the Footer Creation window. Although they only had a
text title, update date code, and pagination codes. They're all gone now, but
the arc remains. Hope the arc doesn't triumph. ;-)

As for "right-click on the tab", I'm not sure what tab you mean.

And, BTW, somehow this object doesn't translate into Quattro Pro, because it
disappears when I view it in the Corel program. Probably the sort of code
that doesn't end up translating.

 

[Gord Dibben]

Not a graphic in the footer for sure?

To print a watermark requires VBA so probably not that, but do you get a
macro warning when opening the workbook?

The 655 pages could have been from earlier and nutsoid had some data that he
cleared.

To get rid of those, select all rows below your data range and delete>entire
row.

Now save the workbook...................the used range will be reset to your
real range.

As far as the arc............if you want to send me the workbook via email I
will have a look.

gorddibbATshawDOTca make the chages.


Gord Dibben MS Excel MVP

 

[PlarfySoober]

Gord,

Thanks for your reply.

Not a graphic in the footer for sure?

AFAIK. There is nothing visible in the footer "fields" and now that they are
empty, the Footer window says "none" or some such.

 

[PlarfySoober]

Gord,

Tried blocking all the lines below 256 (the end of the data) and found it
went on and on. Stopped at 20,000+ and tried deleting it, but no joy.

 

[Gord Dibben]

To select all rows below 256, select row 257 then SHIFT + End + Downarrow.

This should take you to end of sheet.

Now delete entire rows and SAVE the workbook.

But I'll have a look at the workbook.


Gord