![]() |
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 |
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