6 Replies Latest reply: Apr 29, 2011 4:01 PM by Jerrold Green1
mbfromlatham Level 1 Level 1 (0 points)

I'm trying to print a spreadsheet showing the gridlines. Gridlines will print if I previously defined it in Excel but not on all my new sheets. Can't find the appropriate spot in the menu to do this.


MacBook
  • Level 8 Level 8 (41,780 points)

    This question was asked and answered several times.

    A simple search with the obscure keyword "gridlines" would have give you links to the threads listed in the box "More Like This" without creating a new thread.

    You are supposed to know the Terms of Use in which we may see :

     

    2011_04_25d.jpg

     

    Yvan KOENIG (VALLAURIS, France) mercredi 27 avril 2011 17:06:50

  • Jerrold Green1 Level 7 Level 7 (29,855 points)

    MB,

     

    There is a terminology issue, as often happens.  The lines around and within a Numbers Table are called Borders. If you are going to print lines that identify the cells in your table, you must have set Borders in either the Format Bar or the Table Inspector.  Borders have a number of parameters; line type, width, and color, or None. Even with the Borders set to None, you will have grid lines as you edit the table, but these are non-printing lines.

     

    Selecting the table, or a range of cells, or just some of the lines will cause the selection to be highlighted by a change in color.  Don't mistake this for a permanent change in the lines.  Permanent change will only occur with an edit of the parameters mentioned above.

     

    Jerry

  • JBSpSt Level 1 Level 1 (0 points)

    Hi Jerry!  Hoping you can help me!  I followed your advice above and changed the borders using the inspector, but my question is how can you make borders inside and outside the cells?  In other words, I want the whole table to have borders but there is not a button for all, only outside, inside, etc...

     

    thanks!

  • JBSpSt Level 1 Level 1 (0 points)

    Jerry!  The only way I could figure out how to do it was to change the style of the table.  On the left hand side there is a section titled "Style" with choices such as Basic (which is what it defaults to), Basic (no grid), Grey, etc...I chose "Grey" and I now have lines inside and outside!!!

  • Level 8 Level 8 (41,780 points)

    I'm always puzzled when user are unable to set borders.

    Examine carefully the active items in the Inspector on these two screenshots.

    step one, set the internal grid

    2011_04_29h.jpg

     

    step 2, you may see the defined internal grid and set the external borders :

    2011_04_29i.jpg

    I always thought that it's a really simple process.

     

    Yvan KOENIG (VALLAURIS, France) vendredi 29 avril 2011 21:30:30

     

    Please :

    Search for questions similar to your own before submitting them to the community

  • Jerrold Green1 Level 7 Level 7 (29,855 points)

    JBSpSt wrote:

     

    Jerry!  The only way I could figure out how to do it was to change the style of the table.  On the left hand side there is a section titled "Style" with choices such as Basic (which is what it defaults to), Basic (no grid), Grey, etc...I chose "Grey" and I now have lines inside and outside!!!

    Whatever works for you

     

    I suggest that you open a new template and experiment with the borders in the Table Inspector and the Graphic Inspector.

     

    You will note that if you want all the lines to be the same, you may click the table name in the Sheets Pane and change the line type, weight and color in either the Table Inspector  Cell Borders or the Graphic Inspector Stroke.  If you do want all the line to be the same, the Graphic Inspector has the simpler interface.

     

    In the Table Inspector, you can individually set line characteristics for  every line segment in the Table.

     

    Jerry