ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Gridlines Hidden by Shading (https://www.excelbanter.com/excel-discussion-misc-queries/182573-gridlines-hidden-shading.html)

prana1

Gridlines Hidden by Shading
 
Hi,

I have selected gridlines to be displayed when printing via File, Page
Setup, Sheet.

Those gridlines disappear on the screen and in print if I have cells shaded.

Without "overriding" this by using of Borders, does anyone know to to
prevent this and show the gridlines on shaded cells on the screen and print?


Thanks,

Eric

T. Valko

Gridlines Hidden by Shading
 
You'll have to use borders.

--
Biff
Microsoft Excel MVP


"prana1" wrote in message
...
Hi,

I have selected gridlines to be displayed when printing via File, Page
Setup, Sheet.

Those gridlines disappear on the screen and in print if I have cells
shaded.

Without "overriding" this by using of Borders, does anyone know to to
prevent this and show the gridlines on shaded cells on the screen and
print?


Thanks,

Eric





All times are GMT +1. The time now is 05:17 AM.

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