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

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