8 Replies Latest reply: Jun 30, 2013 7:38 PM by Wayne Contello
John Clouse1 Level 1 Level 1 (5 points)

Using Excel I am easily able to tell the printer whether or not to print gridlines.

Using Numbers, I find that this is not the case.

I've read numerous of the previous answers to this question which mostly recommended "reading the Manual."

I can't find this answer in the Manual.

Furthermore, from what I can discern from many of the answers, printing gridlines is not as easy as checking or unchecking a box. It seems that one is required to creat special formulas for one's sheet.

Am I wrong?

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

    John,

     

    Numbers, like the other iWork apps, is a What You See Is What You Get app. You don't turn onything on or off just for printing. If you want to print gridlines, you've got to be seeing them on your display prior to printing. Gridlines are called Borders in Numbers Tables. See Formatting Table Cell Borders on page 87 of the Numbers User Guide.

     

    Jerry

  • Wayne Contello Level 6 Level 6 (16,160 points)

    Adding to Jerry's post:

     

    You'll want to make selections from each of the 4 items in the tool bar:

    Screen Shot 2013-06-25 at 4.22.56 PM.png

    1) selects which borders

    2) selects the border type

    3) selects the weight

    4) select the border color

  • John Clouse1 Level 1 Level 1 (5 points)

    This helps a lot, if I want to creat each grid one at a time.

    I do appreciate your detailed answer and especially the illustration.

    Now, if there was just a simple way to cause all those gridlines, which I already see, to be printed!

     

     

     

     

    "In this forum your question has been asked many times."

  • John Clouse1 Level 1 Level 1 (5 points)

    "If you want to print gridlines, you've got to be seeing them on your display prior to printing."

     

    I do see them, they just don't print!

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

    John,

     

    When the table is activly being edited, there are some faint lines to help you navigate. That's an exception to the rule I stated. However, when you click off the table, you see what you will get when you print.

     

    There's a simple and quick way to add lines to all your cells:

     

    1. Click the table name in the Sheets Pane

     

    2. Go to the Graphics Inspector and set the Storke line type, weight and color.

     

    Your graphics stroke settings will apply to all the borders in the table at once.

     

    Jerry

  • Wayne Contello Level 6 Level 6 (16,160 points)

    John,

     

    Are you still having trouble with this topic?

  • John Clouse1 Level 1 Level 1 (5 points)

    I am now able to print grid lines, though not as easily as I would like.

    Apparently the secret (as explained above) is to highlight all the cells one wants to create grid lines for.

    They only are created where one wants them, not everywhere on the page, and they need to be created each time a new project is undertaken.

     

    Thanks for all your help.

  • Wayne Contello Level 6 Level 6 (16,160 points)

    John,

     

    Once you get a table in a sheet set up the way you like you can use the menu item "File > Save As Template…" so you can start with that document.