View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
PlarfySoober PlarfySoober is offline
external usenet poster
 
Posts: 8
Default 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.


.