+ Reply to Thread
Results 1 to 8 of 8

Simple cell border??

  1. #1
    Registered User
    Join Date
    12-09-2014
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    30

    Simple cell border??

    What should be one of the easiest things to do is causing me grief.
    I am simply trying to place a border around a cell.
    I can do this on most cells, but the odd one just does not seem to allow it - nothing shows where the border should be. It also prints with no border on these cells (others are fine).
    The cell is empty (as far as I can tell).
    I have selected 'no fill'.
    Any suggestions?
    Common problems?
    Thank you.

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Simple cell border??

    send the file with no sensitive data to take a look...

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Simple cell border??

    Click in a cell that has the formatting that you want then click on the cell that you want to change. The formatting should "take" if it doesn't upload a workbook with the problem.

    This is how:
    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  4. #4
    Registered User
    Join Date
    12-09-2014
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    30

    Re: Simple cell border??

    I have attached the worksheet.
    Only certain cells have a problem when trying to add a border. eg. P5, R5, J20, etc

    Thanks again.
    Attached Files Attached Files

  5. #5
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Simple cell border??

    look at your Conditional Formatting rules specially "in-between columns" like Column Q - delete the Cf in the entire column of Q then check the border in column P and R. same goes with the remaining columns.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  6. #6
    Registered User
    Join Date
    12-09-2014
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    30

    Re: Simple cell border??

    Thanks Vlady.
    Will look at your solution.

  7. #7
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Simple cell border??

    It is as vlady says a Conditional Formatting problem. I entered CF and clicked in the first rule and hit F2 then clicked in each rule until I found the one affecting the blank cells without borders. Once identified, I edited the rule, Format, Border and corrected the border settings.

    Applied the changes then selected one of the cells with the problems (now had for some reason top and bottom borders) I selected a properly formatted cell in a vacant column and the double clicked the format painter and painted out the "defective" cells.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    12-09-2014
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    30

    Re: Simple cell border??

    Vlady and newdoverman - thank you both.
    Appreciate the help.
    Mike

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Mysterious additional border to left of rows border?
    By Oppressed1 in forum Excel General
    Replies: 2
    Last Post: 10-10-2012, 03:22 PM
  2. Remove extra border and put all border in last row of generated output
    By cruise.alter in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-05-2012, 01:21 AM
  3. Replies: 1
    Last Post: 03-29-2011, 08:22 AM
  4. Replies: 2
    Last Post: 10-05-2005, 04:05 PM
  5. Replies: 0
    Last Post: 01-12-2005, 10:50 AM

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