| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Pivot Table Format Messed up
Hi,
Recently (I'm not sure why) the pivot tables I create have no lines on them (more technically -- all of the lines are white and you can't see them)? I am not sure what setting I changed or why this has started happening. Does anyone know how to change this back to the default settings? thanks Tim |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Pivot Table Format Messed up
Reselect some other parameter in the pivottable should auto-refresh. I
couldn't find anything else that would affect this. "Tim879" wrote: Hi, Recently (I'm not sure why) the pivot tables I create have no lines on them (more technically -- all of the lines are white and you can't see them)? I am not sure what setting I changed or why this has started happening. Does anyone know how to change this back to the default settings? thanks Tim |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Pivot Table Format Messed up
As a guess you selected the auto format option from the pivot table menu and
selected the final option None which removes all formatting. To go back to the default autoformat select Auto Format from the pivot table menu and then select Pivot Table Classic (second last choice) to go back to standard lines. -- HTH... Jim Thomlinson "Tim879" wrote: Hi, Recently (I'm not sure why) the pivot tables I create have no lines on them (more technically -- all of the lines are white and you can't see them)? I am not sure what setting I changed or why this has started happening. Does anyone know how to change this back to the default settings? thanks Tim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL TABLE INTO AUTOCAD MESSED UP | Excel Discussion (Misc queries) | |||
| Excel 2007 Pivot table cells number format changes w/out user inpu | Excel Discussion (Misc queries) | |||
| How do I get word wrap format to remain in an Excel pivot table? | Excel Discussion (Misc queries) | |||
| How do you turn off pivot table auto format in Excel? | Excel Discussion (Misc queries) | |||
| Excel - pivot table - how do i format cells with data mm/dd/yyyy . | Excel Worksheet Functions | |||
Hybrid Mode
