ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   no grid lines when colouring in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/98858-no-grid-lines-when-colouring-cell.html)

stevec

no grid lines when colouring in a cell
 
what do I have to do to get the gridlines displayed and printed in cells that
have been coloured in?

CLR

no grid lines when colouring in a cell
 
Right click on the cell then FormatCells BorderTab select a line style,
and the Preset Square Outline ok

Vaya con Dios,
Chuck, CABGx3




"stevec" wrote:

what do I have to do to get the gridlines displayed and printed in cells that
have been coloured in?


tony h

no grid lines when colouring in a cell
 

the colour will take precedence over the grid BUT if you format the
cells with borders then the borders will print - and look just like
gridlines !


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=560748



All times are GMT +1. The time now is 12:49 AM.

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