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.

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

Select the cells and FormatCellsPatternNo color.


Gord Dibben MS Excel MVP

On Tue, 27 Nov 2007 10:11:02 -0800, errolt
wrote:

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.

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!

"Gord Dibben" wrote:

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

Select the cells and FormatCellsPatternNo color.


Gord Dibben MS Excel MVP

On Tue, 27 Nov 2007 10:11:02 -0800, errolt
wrote:

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.