ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How do I get all gridlines to show up on a table? (https://www.excelbanter.com/setting-up-configuration-excel/172532-how-do-i-get-all-gridlines-show-up-table.html)

klam87

How do I get all gridlines to show up on a table?
 
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.

Pete_UK

How do I get all gridlines to show up on a table?
 
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

On Jan 10, 5:29*pm, klam87 wrote:
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.



Gord Dibben

How do I get all gridlines to show up on a table?
 
Can you see the gridlines on the worksheet but they won't print?

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

Gridlines is not checked under FilePage SetupSheet

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


Gord Dibben MS Excel MVP

On Thu, 10 Jan 2008 09:29:00 -0800, klam87
wrote:

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.




All times are GMT +1. The time now is 05:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com