View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.