Skip navigation

Cell border will not hold.

664 Views 10 Replies Latest reply: Oct 25, 2012 11:35 AM by Jeff Shenk RSS
keirby Calculating status...
Currently Being Moderated
May 11, 2012 12:49 PM

A cell will not maintain a border.  When I try to select which line to use, it immediately goes back to "none", thoughts?

Numbers '09, Mac OS X (10.6.8)
  • Wayne Contello Level 6 Level 6 (12,625 points)
    Currently Being Moderated
    May 11, 2012 1:48 PM (in response to keirby)

    I suggest looking at the Numbers Users' Guide which you can download here:

     

    http://support.apple.com/manuals/#productivitysoftware

     

     

    The section on formatting cell boarders is on page 87.

     

    My guess is you are not setting all the selections.  You have to select:

    1) The edge(s) you want to modify

    2) the weight of the line to use and

    3) the color

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    May 11, 2012 2:33 PM (in response to keirby)

    Hi keirby,

     

    Border format controls may be found in the Format bar near the top of the document window (top image) and in the Table Inspector (bottom image).

    Picture 16.png

    Note that there are four controls in the Format bar. The Inspector splits the first one, the border selection menu, into three sets of buttons. The remaining controls are uses to set the border Style, the border Width, and the Border Colour. If you use only the first (which is what I suspect you have done), you will have Selected the border that you want to change, but haven't specified what changes you want to make.

     

    Here are the steps to set a wide, dashed red border on a set of three cells:

     

    1. Select the cells to which the border will be applied.
    2. In the Format bar, select the bottom border, using the first pop-up menu button.
      Picture 17.png
      When you release the mouse button,the blue Selection rectangle showing the three selected cells (above) will be replaces by a blue Selection line showing the bottom edge of these cells in selected. No change has yet been made to the border.
    3. Use the Style button to choose the dashed line.
    4. Use the Stroke Thickness button to choose 2 pt.
    5. Click the Stroke Color Well and choose a Red from the Color Palette that opens.
      The selection line will change to reflect each of these choices as it is made and applied to the selected border.
      Picture 18.png
    6. Click any unselected cell on the table to deselect the cells just changed, or click away from the table to deselect the whole table and view the changes.
      Picture 19.png

     

    Regards,

    Barry

  • Captain Slocum Level 1 Level 1 (0 points)
    Currently Being Moderated
    Oct 25, 2012 3:54 AM (in response to Barry)

    Actually, there is a bug in Numbers, and this may be confusing you, as it did me for a long time..

     

    If you select a group of cells and then use the right-most two icons in the inspector to add a border to each of the internal cells and then try to add a border around the whole thing, it will not stick, even though you have told the outer border to be a colour. If you look up at the tool bar however, you will see that there the border colour is still white, and thus does not show up. Alter this, and it will work.

  • Jeff Shenk Level 4 Level 4 (2,000 points)
    Currently Being Moderated
    Oct 25, 2012 5:02 AM (in response to Captain Slocum)

    Actually, it does stick here, with Numbers 2.1 on OSX 10.6.8.

  • Captain Slocum Level 1 Level 1 (0 points)
    Currently Being Moderated
    Oct 25, 2012 7:55 AM (in response to Jeff Shenk)

    I am using Numbers 2.2, Lion.

     

    Here is what I mean:

     

    Select a group of cells

    In the inspector, click the 7th border icon from the left (select all internal lines)

    Coose a thick line type and size

    Click the colour box and choose a colour

    Now click on the last icon from the left (select the outer border)

    Repeat the above steps, including clicking the colour box and altering it.

    Click anywhere on the page to deselect the cells.

    The inner lines have been drawn, but the outer border has not.

     

    To make it work with the inspector, it is necessary to deselect the cells completely after having made the first change, reselect the cells, and then go back into the inspector and go through the steps again for the outer border.

     

    It took me a while to work this out, so I just thought I would share this with you. The other thing that threw me for a while is that if you choose a thin line for the border and the default grey, there appears to be no difference in the display, as the printable borders and the non-printing display borders are exactly the same, so it looks like it has not worked.

     

    Of course once you know about this (shall we say quirk, if you don't like bug?) it is easy enough, but confusing I think and not up to Apple's normal high standard of usability.

  • Jeff Shenk Level 4 Level 4 (2,000 points)
    Currently Being Moderated
    Oct 25, 2012 8:38 AM (in response to Captain Slocum)

    When I follow your procedure, the outer border is drawn. (Except for the time I forgot to click on the colour box.)

     

    I have, in some cases, found that applying a colour works more reliably by dragging a swatch from the colour picker to the colour box, instead of clicking on the box and then changing the setting in the colour picker.

  • Jerrold Green1 Level 7 Level 7 (28,150 points)
    Currently Being Moderated
    Oct 25, 2012 8:40 AM (in response to Captain Slocum)

    I have found that you must pay close attention to the status of the selector buttons and the selection lines in the table. It's easy to think that you should click, say, the color button when it is already active, which of course deactivates it.

     

    Jerry

  • Jeff Shenk Level 4 Level 4 (2,000 points)
    Currently Being Moderated
    Oct 25, 2012 8:45 AM (in response to Jerrold Green1)

    Great point, Jerry, I don't think I ever noticed that.

  • Jerrold Green1 Level 7 Level 7 (28,150 points)
    Currently Being Moderated
    Oct 25, 2012 8:54 AM (in response to Jeff Shenk)

    Jeff,

     

    Why the buttons toggle instead of sticking down is another question. I can see no reason that you would want to deactivate a button by hitting it twice.

     

    Jerry

  • Jeff Shenk Level 4 Level 4 (2,000 points)
    Currently Being Moderated
    Oct 25, 2012 11:35 AM (in response to Jerrold Green1)

    Jerry,

     

    It's funny you should say that; I'd been thinking pretty much the same thing.

     

    I suppose you might want to play with the color picker without changing your active selection? I don't see any real reason why this couldn't simply be active any time there is a selection. If you ever needed to play with the colors with it inactive you could just click outside a table so there isn't a selection. (So you just made a complicated, discontiguous selection that it would be a pain to re select, and you don't want to save and revert and you just have to fiddle with the color picker…I think this is getting way beyond the 80% rule here.)

     

    Anyhow, thanks for pointing it out, I'll know to pay more attention to the "highlight" around that color well in the future.

     

    Jeff

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.