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

K

klam87

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.
 
P

Pete_UK

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Blank Sheet with Gridlines 11
How do I PRINT gridlines? 8
gridlines in pivot table 1
Gridlines won't show up in excel 2007 6
Restoring Gridlines 3
GRIDLINES 7 FILL COLOR 4
Table Gridlines 5
How can I print gridlines? 1

Top