How to show cell borders?

[Brett]

I've pasted an HTML table into Excel. Everything formatted fine.
However, the cells in that area no longer have borders. The lines are
gone and everything there is white. How do I get these borders/lines
back?

Brett

 

[Guest]

Hi Bret
Is it "Borders" that are missing, or do you mean the gridlines? Select one of the cells and go to Format>Cells>Pattern. The Pattern is probably set to white, change it to "no color"

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- Brett wrote: ----

I've pasted an HTML table into Excel. Everything formatted fine.
However, the cells in that area no longer have borders. The lines ar
gone and everything there is white. How do I get these borders/line
back

Bret

 

[Stephen Bye]

Use Paste Special instead of Paste.
Select 'Text' instead of the default 'HTML format'

 

[Brett]

That was it. Thank you.

Brett

 

[Brett]

This causes it to format poorly. The above post solved the problem. Thanks.

Brett