+ Reply to Thread
Results 1 to 4 of 4

How can I do away with the border line here?

  1. #1
    Registered User
    Join Date
    07-19-2010
    Location
    Hong Kong, China
    MS-Off Ver
    Excel 2003
    Posts
    12

    How can I do away with the border line here?

    Please check the file. For some cells, I cannot get away the lower border lines for column I. This happened after I have deleted the conditional formatting of that cell.
    Have tried every possible way but no sign of success. Please help out! Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,497

    Re: How can I do away with the border line here?

    Have tried every possible way...
    What did you try? I selected the entire sheet and applied No Borders & No Fill options. Some of the cells seem to have a white background fill.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    07-19-2010
    Location
    Hong Kong, China
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: How can I do away with the border line here?

    Quote Originally Posted by protonLeah View Post
    What did you try? I selected the entire sheet and applied No Borders & No Fill options. Some of the cells seem to have a white background fill.
    Yes, in fact some of the cells are filled white. Supposedly, after filled white the border lines should disappear but it turns out the other way round.

    I have tried to use the "eraser function" to erase it manually, unfilled it and fill it white again, no border option selected, all sorts of stuffs. It look very strange when I tried to paste it as picture in my powerpoint file, having the stupid border lines beneath.

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,497

    Re: How can I do away with the border line here?

    It seems like you mean gridlines not borders. Try selecting your area, and formatting it with white border lines. Copy the cells and use paste special> bitmap in PP.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1