| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
reapply cell gridlines after removing background color
When I apply a background color to a group of cells, then later remove the
background color, the cells' gridlines (or borders) disappear. The rest of the spreadsheet has the default gridlines; applying a border of any kind (through Format|Cells|Border) does not match the rest of the cells. How do I get the default border back around the "un-bordered" cells, so that it looks as though a background color was never applied? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
reapply cell gridlines after removing background color
Make sure that when you remove the background color, you don't just pick
White. You must select No Color -- Gary''s Student - gsnu200832 "Ray_and_Jan" wrote: When I apply a background color to a group of cells, then later remove the background color, the cells' gridlines (or borders) disappear. The rest of the spreadsheet has the default gridlines; applying a border of any kind (through Format|Cells|Border) does not match the rest of the cells. How do I get the default border back around the "un-bordered" cells, so that it looks as though a background color was never applied? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
reapply cell gridlines after removing background color
Thank you, it worked just as I hoped it would. I appreciate your help. Ray_and_Jan "Gary''s Student" wrote: Make sure that when you remove the background color, you don't just pick White. You must select No Color -- Gary''s Student - gsnu200832 "Ray_and_Jan" wrote: When I apply a background color to a group of cells, then later remove the background color, the cells' gridlines (or borders) disappear. The rest of the spreadsheet has the default gridlines; applying a border of any kind (through Format|Cells|Border) does not match the rest of the cells. How do I get the default border back around the "un-bordered" cells, so that it looks as though a background color was never applied? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Gridlines over cell background color. | Excel Discussion (Misc queries) | |||
| Removing patterns without removing gridlines | Excel Discussion (Misc queries) | |||
| Restoring Excel gridlines after removing background shading? | Excel Discussion (Misc queries) | |||
| Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) | |||
| Gridlines into excel spreadsheet after changing background color | Excel Worksheet Functions | |||
Linear Mode
