Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    a line in worksheet (Office XP)

    hi, there is a line in between column P1:P16 and Q1:Q16 and cannot be deleted by no border selection. attached is the line between A1:A16 and B1:B16. if the line is brought to left by keep deleting columns, the line will dissappear. since there are data and formulas from A1:S5000, i may have another thought. anyone knows how to delete the line in column P and column Q? THANK YOU VERY MUCH.

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    312
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: a line in worksheet (Office XP)

    I was able to delete the contents from selecting the column and right-clicking, delete contents, and it disappeared.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: a line in worksheet (Office XP)

    The line has been drawn in by the drawing tools. Click on the line and delete it. It is not a border as stated.
    I hope I understand your question correctly?!
    Regards,
    Rudi

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: a line in worksheet (Office XP)

    There are 2 rectangles with text that have been shrunk to a "line". You can select and delete them or expand them if desired

    Steve

  5. #5
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: a line in worksheet (Office XP)

    hi Steve and others helpful persons, it is true; 2 lines are 2 text boxes shrunk into 'line'. i deleted them. THANK YOU.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •