I have a spread sheet with various columns in use. I cut and pasted a
formula from a different location into all of the cells of one column.
The formula calculates the correct answer however the 4 lines that make
up the cell (so to speak) vanish.

How do I get them back? I tried changing the size of the cell but the
lines do not come back. Hard to explain without seeing so I hope its
clear.

Any help would be appreciated. Thanks Peter


--
pgruening
------------------------------------------------------------------------
pgruening's Profile: http://www.excelforum.com/member.php...o&userid=26011
View this thread: http://www.excelforum.com/showthread...hreadid=465702

The cell you copied may have been filled with white colour, and that
would cover the gridlines.

Select the column where you pasted the formula
On the Formatting toolbar, click the arrow at the right of the Fill
Color button
Select No Fill

pgruening wrote:
I have a spread sheet with various columns in use. I cut and pasted a
formula from a different location into all of the cells of one column.
The formula calculates the correct answer however the 4 lines that make
up the cell (so to speak) vanish.

How do I get them back? I tried changing the size of the cell but the
lines do not come back. Hard to explain without seeing so I hope its
clear.

Any help would be appreciated. Thanks Peter




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

pgruening,
I'm going to make the assumption that the two spreadsheets are
formatted differently. Possibly the second one has the option for
gridlines turned off

TOOLSOPTIONSVIEWGridlines

But the easiest fix might be to highlight your cells that no longer
have a border and then go to

FORMATCELLSBORDER and select a Line style and select Outline. See if
that helps.


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=465702