View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Line printing that is not a border or drawing

I've had this occasionally in the past - a very stubborn line. The way
I solved it was to copy a larger range of blank cells over the affected
cells - eg if it was at the bottom of B23:F23, I copied, say, A60:G61
into A23. Obviously this will overwrite your data and formulae, so you
will need to re-instate them.

Hope this helps.

Pete

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!