If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. . |
#6
|
|||
|
|||
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. . |
#7
|
|||
|
|||
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. . |
Thread Tools | |
Display Modes | |
|
|