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