Mysterious "Arc" appearing at the bottom of the page
 

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.

Mysterious "Arc" appearing at the bottom of the page
 

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" wrote:

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.

Mysterious "Arc" appearing at the bottom of the page
 

Sean,

Thanks for replying.

"Sean Timmons" wrote:

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.


"PlarfySoober" wrote:

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.

Mysterious "Arc" appearing at the bottom of the page
 

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 deleteentire
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

On Fri, 13 Nov 2009 12:49:01 -0800, PlarfySoober
wrote:

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.

Mysterious "Arc" appearing at the bottom of the page
 

Gord,

Thanks for your reply.

"Gord Dibben" wrote:

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.

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 deleteentire
row.

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

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

On its way.
gorddibbATshawDOTca make the chages.


Gord Dibben MS Excel MVP

On Fri, 13 Nov 2009 12:49:01 -0800, PlarfySoober
wrote:

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.

.

Mysterious "Arc" appearing at the bottom of the page
 

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" wrote:

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 deleteentire
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

On Fri, 13 Nov 2009 12:49:01 -0800, PlarfySoober
wrote:

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.

.

Mysterious "Arc" appearing at the bottom of the page
 

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


On Fri, 13 Nov 2009 15:11:01 -0800, PlarfySoober
wrote:

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" wrote:

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 deleteentire
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

On Fri, 13 Nov 2009 12:49:01 -0800, PlarfySoober
wrote:

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.

.