Previous 1 2 Next 19 Replies Latest reply: Aug 16, 2009 1:43 AM by Barry
Tim Murray2 Level 1 Level 1 (95 points)
This is not the same as custom borders on cells -- I'm referring to the soft gray cell grid on the screen. I'm doing some work requiring screen shots, and they would look better without the lines.

PowerBook G4, 1.7 GHz, Mac OS X (10.4.11), 2 GB
  • pw1840 Level 3 Level 3 (840 points)
    Tim,

    Does setting all cell borders to "white" solve your problem?

    pw
  • Ashka Level 4 Level 4 (3,785 points)
    You could also set them to transparent by selecting the table in the sidebar > using the format bar for borders > setting the colour box to the white coloured square with the red diagonal line .

    Message was edited by: Ashka
  • Tim Murray2 Level 1 Level 1 (95 points)
    Thanks, but no. That's why I said it's the gridlines, not borders, I'm trying to hide.

    Message was edited by: Tim Murray2
  • Tim Murray2 Level 1 Level 1 (95 points)
    That solution removes any borders I wanted to retain. I think the core problem with Numbers is that it does not differentiate between a grid line and a cell border ... they are one in the same.

    Message was edited by: Tim Murray2
  • pw1840 Level 3 Level 3 (840 points)
    Tim,

    I don't see the problem here. Yes, gridlines can be considered as borders and one may think of them as one in the same. However, this is not an all-or-nothing situation. You just need to white-out, or if you prefer, make transparent any of the portions of your table you choose. The table at the left below has all grid lines whited out. In the table at the right, gridlines in the lower portion were made transparent.

    pw

  • Ashka Level 4 Level 4 (3,785 points)
    It doesn't matter if you are setting borders over gridlines or removing gridlines the system is the same.
    The easiest way would be to remove all the gridlines by setting the line option to NONE then set the borders you require.
    If the line is set to NONE instead of changing the colour the grid will show faintly when selected.

    Copy of Setting Borders Post:
    The Border options are on the format bar but the Border options in Inspector might be easier to follow.

    NOTE: Blue double lines show which borders are selected, they disappear when the borders have been changed.

    Inspector > Tables > Cell Borders or Format bar
    First select the cell / cells in your Table or select the Whole table in the sidebar > select which borders you want to change in the Inspector > Then select the line but remember Thin will not allow you to change the next box which is the point size of the line. > next box is color.

    If you just want to select separate lines in the table select "allow border selection" on the Menu bar Table dropdown.

    If you get a mess which we all do at times Select the whole table in the side bar and set the Line option box to None and start again.
  • Tim Murray2 Level 1 Level 1 (95 points)
    I understand the process. But the thing is that I get sent large Excel sheets with a number of custom borders already in place. Sure, I could travel around the sheet and deal with specific areas where I don't want borders, but it would take forever. And select-all, followed by changing the borders, ends up changing everything.

    What I was hoping to hear was there was a setting I had missed similar to Excel's Preferences > View > Show Gridlines.
  • pw1840 Level 3 Level 3 (840 points)
    Tim,

    Now I see where you are coming from and understand why you consider gridlines and borders to be separate entities. Regretfully, i am unaware of any such feature in Numbers -- hopefully other Forum members will have an answer. Not knowing what your tables look like in terms of the positioning and quantity of the borders to be retained, I can think of only three options -- none of which you will find palatable:

    1) White-out all gridlines and replace border as suggested in an earlier response by Ashka
    2) White-out the areas not involving borders
    3) Leave the table "as is" with gridlines showing

    A fourth option is to white-out all gridlines and not replace borders, but I assume this is totally unacceptable. Sorry.

    Best wishes and Good Luck,

    pw
  • Level 8 Level 8 (41,790 points)
    Hello all of you

    I looked in the AppleScript's dictionary.
    Alas, it doesn't offer access to attributes like cell borders.
    So, we have no way to treat the problem.
    I will look in the Index.xml if we may do the job the brute force way.
    I think that it will be difficult as there are numerous default items defined and it would be unsafe to change them.

    Yvan KOENIG (from FRANCE samedi 14 février 2009 16:14:25)
  • Looter Level 1 Level 1 (55 points)
    Grid lines and borders are different.

    OP: *If you click out of a layout gridlines disappear.* But I don't see a way to turn them off.

    Gridlines cover borders and make it difficult to see if you have borders on certain cells.

    As much as I try to use Numbers instead of Excel. Sometimes I'm not sure why. Excel works pretty well for many things.
  • Badunit Level 6 Level 6 (11,400 points)
    Looter wrote:
    As much as I try to use Numbers instead of Excel. Sometimes I'm not sure why.


    Because it is Microsoft Excel?
  • wbweston Level 1 Level 1 (0 points)
    I am really surprised that Apple missed this very handy feature, which I use all the time in Excel. In fact my defaul option in Excel is to have my gridlines turned off, then I make my borders accordingly.

    A single button or selection to show or not to show gridlines (NOT borders) is a very fundamental feature of spreadsheets for many people.

    I guess I am going to have to go back to using Excel because having to make my gridlines transparent simply will take too much time.

    I really like Apple's iWork programs but it is unfortunate when your run across features like this that aren't available as it causes users to go back to the dark side .
  • wbweston Level 1 Level 1 (0 points)
    Ok, I just did what the person recommended above which was to highlight the particular cell(s) that I do not want gridlines(borders) and make them white. Yikes, took me 5 minutes to do that. In Excel it took me 3 seconds.

    Apple... you are doing great but we need at least comparable functionality to switch.
  • dsacgt Level 1 Level 1 (0 points)
    Copy from Numbers and Paste into Keynote or Pages and the gridlines disappear!
Previous 1 2 Next