ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing/Displaying Gridlines (https://www.excelbanter.com/excel-discussion-misc-queries/112511-printing-displaying-gridlines.html)

Pat

Printing/Displaying Gridlines
 
When a cell is filled with color the gridlines do not show for that cell on
the screen or when printed. When multiple adjacent cells are filled with
color it would be nice to be able to see the gridlines. Can the gridlines be
made to be in front of the color? Any ideas?

Trevor Shuttleworth

Printing/Displaying Gridlines
 
Use Borders

Format | Cells ... | Border tab | choose the weight, etc., of the border you
want.

Regards

Trevor


"Pat" wrote in message
...
When a cell is filled with color the gridlines do not show for that cell
on
the screen or when printed. When multiple adjacent cells are filled with
color it would be nice to be able to see the gridlines. Can the gridlines
be
made to be in front of the color? Any ideas?




Earl Kiosterud

Printing/Displaying Gridlines
 
Pat,

In a word - no. Fill color paints over the gridlines. You'll need to use
borders (Format - Cells - Borders) to simulate the gridlines.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Pat" wrote in message
...
When a cell is filled with color the gridlines do not show for that cell
on
the screen or when printed. When multiple adjacent cells are filled with
color it would be nice to be able to see the gridlines. Can the gridlines
be
made to be in front of the color? Any ideas?





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

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