View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
pixiecat
 
Posts: n/a
Default Phantom Line on Worksheet

I've been battling the same problem. Thank you for a solution. It was
driving me crazy!

"Eric" wrote:

Rita,

My guess is that Don was right that it was a drawing object that had been
reduced to a height of zero because the rows beneath it were deleted.
Another way to check for this would be to click on the arrow ("Select
Object") on the Drawing toolbar then draw a 'select' box around the whole
line. This will select it if it is an object and you can then either enlarge
it to see what it is or just delete it.

Eric

"Rita Palazzi" wrote:

I finally got rid of it. I had to insert a whole blank page worth of
rows, then copy the surrounding information to the new page, then delete
the page containing the phantom line. What a pain!

If anyone knows what caused it, let me know so I don't do it again.
Thanks!!




Rita Palazzi wrote:

Windows XP Professional
Office 2000

I have an Excel worksheet that is set up to actually be a memo. Several
of the cells are the text portion and then there are several graphs. In
the middle of one of the "pages", there is a line that I cannot get rid
of. It is not a drawn line such that it cannot be selected to delete.
It is not a border for any of the cells that it is near. If I delete
entire rows above and below the line, it still remains. How can I get
rid of this line????

Thanks in advance for any help or suggestions. This is so frustrating
as I've never seen this issue before!!

Rita Palazzi
Senior Engineer / Global Trade Services
FedEx Express