| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep pivot format
Hi,
When double clicking a field in a pivot table, it opens the original data. Is there a way to keep the format the data is in? Let's say, if the pivot has different coloured lines, if I double click, how can I keep the same lines coloured? Thanks, Assaf. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keep pivot format
No, the extracted data won't retain the formatting from the pivot table.
There's no setting that will change this behaviour. assaf1978 wrote: Hi, When double clicking a field in a pivot table, it opens the original data. Is there a way to keep the format the data is in? Let's say, if the pivot has different coloured lines, if I double click, how can I keep the same lines coloured? Thanks, Assaf. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Format | Excel Worksheet Functions | |||
| Format a pivot | Excel Discussion (Misc queries) | |||
| pivot table format | Excel Discussion (Misc queries) | |||
| Keep format after pivot | Charts and Charting in Excel | |||
| format pivot table | Excel Worksheet Functions | |||
Linear Mode
