ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Gridlines (https://www.excelbanter.com/excel-discussion-misc-queries/142061-gridlines.html)

Scott

Gridlines
 
In my spreadsheet, I format it to have gridlines in print setup. I need to
format the headers of each columns and rows to have a gray color background.
Once I use color background, the gridlines on that area become disappeared.
Can someone advise how to restore the gridlines with the gray color
background.

Thanks,

Scott



Jim G

Gridlines
 
You should be able to format each cell on your header rows to have a border.
Right click and choose "Format Cells" from the menu and select weight, colour
etc for your borders or use the command button on the standard menu to make a
quick change the highliighted cells.

HTH
--
Jim


"Scott" wrote:

In my spreadsheet, I format it to have gridlines in print setup. I need to
format the headers of each columns and rows to have a gray color background.
Once I use color background, the gridlines on that area become disappeared.
Can someone advise how to restore the gridlines with the gray color
background.

Thanks,

Scott





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

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