Pasted text has no gridlines

G

Gregg Hill

Hello!

When I copy text from a web page (my cell phone bill) and paste it into
Excel 2003, the section I pasted has no gridlines. I want to restore the
standard gridlines to the entire sheet. How do I do that?

Thanks for the help!

Gregg Hill
 
J

John P

Highlight the cells and press the borders button on the formatting toolbar
(the one that looks like a little four pane window!

HTH


John P
 
G

Gord Dibben

Gregg

The background color of the webpage is white. When you paste it into Excel,
the background wipes the gridlines.

Select the range and Format>Cells>Patterns. Select "no color" from the
options.

Gord Dibben Excel MVP
 
G

Gregg Hill

That does not do anything, but thanks for trying. To see the fix, read
Gord's response.

Gregg
 
G

Gregg Hill

Gord Dibben strikes again!!

Thank you, Sir! That did it.

Gregg Hill



Gord Dibben said:
Gregg

The background color of the webpage is white. When you paste it into Excel,
the background wipes the gridlines.

Select the range and Format>Cells>Patterns. Select "no color" from the
options.

Gord Dibben Excel MVP
Click to expand...
 
Top