How do I print gridlines on my spreadsheet? They sometimes do if I had the sheet in Excel previously.

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 :

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

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

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

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

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

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!

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!!!

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