Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I stop cell borders dissappearing when pasting data?
When I paste data from information available on the web and paste it into
Excel the page view changes by removing the visible cell borders. This makes for a strange looking screen and makes cell selection tricky. How can I restore the worksheet to the standard format? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I stop cell borders dissappearing when pasting data?
John
I assume by "borders" you mean "gridlines". These gridlines disappear due to the fact that the cell background color has been changed to "white" by the pasted-in information. You cannot prevent this but you can fix it. The default for cell background in Excel is "No Color" Just select the cells and change the BG color to "no color". Gord Dibben MS Excel MVP On Thu, 20 Apr 2006 07:12:02 -0700, John Hallworth <John wrote: When I paste data from information available on the web and paste it into Excel the page view changes by removing the visible cell borders. This makes for a strange looking screen and makes cell selection tricky. How can I restore the worksheet to the standard format? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I stop cell borders dissappearing when pasting data?
Ding Ding Ding! Exactly the answer I needed, thanks Gord.
"Gord Dibben" wrote: John I assume by "borders" you mean "gridlines". These gridlines disappear due to the fact that the cell background color has been changed to "white" by the pasted-in information. You cannot prevent this but you can fix it. The default for cell background in Excel is "No Color" Just select the cells and change the BG color to "no color". Gord Dibben MS Excel MVP On Thu, 20 Apr 2006 07:12:02 -0700, John Hallworth <John wrote: When I paste data from information available on the web and paste it into Excel the page view changes by removing the visible cell borders. This makes for a strange looking screen and makes cell selection tricky. How can I restore the worksheet to the standard format? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Maximum data in cell | Excel Discussion (Misc queries) | |||
data in cell not corresponding with entry | New Users to Excel | |||
Why data in cell doesn't stay aligned with cell borders when prin. | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) |