| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot clears cell fill color
I am having trouble with the format of my pivot table...
I drag a data element down into the table and it looks fine. When I return that element to the top, the white fill color I have applied to all of the cells is gone and it then shows grid lines where the table was. I just want a white background to remain no matter how I pivot. Any suggestions? thanks, Chris |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot clears cell fill color
Right click on the table and select table options - preserve formatting...
-- HTH... Jim Thomlinson "CG" wrote: I am having trouble with the format of my pivot table... I drag a data element down into the table and it looks fine. When I return that element to the top, the white fill color I have applied to all of the cells is gone and it then shows grid lines where the table was. I just want a white background to remain no matter how I pivot. Any suggestions? thanks, Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the fill color of a cell using an "IF" function | Excel Worksheet Functions | |||
| cell fill color | Excel Worksheet Functions | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Linear Mode
