Cell lines

[errolt]

How do I restore cell lines that have disappeared after a copy and paste from
another program; ie not general gridline display and non-display which one
sets from Tools/Options/View/Gridlines.

 

[Gord Dibben]

Perhaps the copy/paste brought over some cells that were formatted to "white"
which wipes out the gridlines.

Select the cells and Format>Cells>Pattern>No color.


Gord Dibben MS Excel MVP

 

[errolt]

Thanks! That did not do the trick! I copied and pasted a new sample (from
internet banking). If I select all and set it as general and then set the
first column to "date", that worked. Then I tried again and could not repeat
the miracle!