How do I get all gridlines to show up on a table?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

klam87 - 10 Jan 2008 17:29 GMT

I want to create a table that has columns with titles in the cells. I want
to print the table with blanks below each title, to be filled in by hand. I
don't know how to get Excel to print all the gridlines, not just the ones
around the titles.

Reply to this Message

Pete_UK - 10 Jan 2008 17:43 GMT

Highlight the cells making up the table, including the blanks, then
click on Format | Cells | Borders tab, and then you can decide where
you want your lines, as well as the thickness and colour of the lines.

Hope this helps.

Pete

> I want to create a table that has columns with titles in the cells. I want
> to print the table with blanks below each title, to be filled in by hand. I
> don't know how to get Excel to print all the gridlines, not just the ones
> around the titles.

Reply to this Message

Gord Dibben - 10 Jan 2008 17:52 GMT

Can you see the gridlines on the worksheet but they won't print?

If so, then................

Gridlines is not checked under File>Page Setup>Sheet

The lines around the titles are borders so they will print.

Gord Dibben MS Excel MVP

>I want to create a table that has columns with titles in the cells. I want
>to print the table with blanks below each title, to be filled in by hand. I
>don't know how to get Excel to print all the gridlines, not just the ones
>around the titles.

Reply to this Message