View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Vera Lemon Vera Lemon is offline
external usenet poster
 
Posts: 11
Default Line printing that is not a border or drawing

Thanks Dave!! Suggestion #3 Worked!! Yeah! Edit/goto/special/objects fixed it!

You're the best!

"Dave Peterson" wrote:

Some other guesses...

Could the line be caused by format|conditional formatting?

Could the line be an object (like a button) that was squished when some rows
were deleted?

If it's the only object on the worksheet, you may be able to delete it by:
edit|Goto|special|objects
and hit the delete key

(if the worksheet is protected, unprotect it first. You may need to go into
design mode (an icon on the Control toolbox toolbar) so that the object can be
selected.)

Vera Lemon wrote:

There is a line that shows up on my worksheet (& prints) that is not
formatted in as a border, it's not drawn in, I can't select it & I can't get
rid of it even if I delete the columns and/or rows that is showing up
in...mysterious!


--

Dave Peterson