Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Pivot tabels - auto foramtting when doubleclicking

0 views
Skip to first unread message

H. Rye

unread,
Nov 17, 2003, 12:19:23 PM11/17/03
to
When I doubleclik in my pivot table, a new sheet is created, showing the
details behind the cell content in the pivot table.

When this new sheet is created, a kind of auto formatting is applied to the
new sheet. My question is: How can I control this formating? Where does
Excel get theese formats from? Some times I get quite weird results...

I´m using Excel 2000.

Hope anybody out there can help me.

Håvard


Dave Peterson

unread,
Nov 17, 2003, 8:43:21 PM11/17/03
to
I don't think you can control them (or at least I can't!).

But maybe you can go back to the raw data worksheet and select your range and
use the Format|painter icon to use the same format again.

--

Dave Peterson
ec3...@msn.com

Debra Dalgleish

unread,
Nov 17, 2003, 9:37:39 PM11/17/03
to
Or select one of the formats from Format>AutoFormat (when you extract
data from the pivot table, it seems to apply List3 format)


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Dave Peterson

unread,
Nov 17, 2003, 9:46:12 PM11/17/03
to
It does look like it's list3 (but I don't like list3!). <vbg>

--

Dave Peterson
ec3...@msn.com

Debra Dalgleish

unread,
Nov 17, 2003, 10:03:35 PM11/17/03
to
Oh no! Too colourful for you? Maybe 'Simple' is more your style.

Sub FormatPivotDetail()
Selection.ShowDetail = True
Selection.AutoFormat _
Format:=xlRangeAutoFormatSimple
End Sub

Dave Peterson

unread,
Nov 17, 2003, 10:08:01 PM11/17/03
to
I it to use the same formatting as the original data--I want the same wraptext
options, colors, bolding, everything.

But that sounds pretty difficult. Maybe I shouldn't ask. (hehehe).

--

Dave Peterson
ec3...@msn.com

H. Rye

unread,
Nov 25, 2003, 7:15:10 AM11/25/03
to

Debra Dalgleish

unread,
Nov 25, 2003, 7:34:05 AM11/25/03
to
Dave Peterson answered your question a few days ago. You can see the
thread in the Google archives:

http://groups.google.com/groups?&threadm=3FB97939.94402802%40msn.com


H. Rye wrote:
> When I doubleclik in my pivot table, a new sheet is created, showing the
> details behind the cell content in the pivot table.
>
> When this new sheet is created, a kind of auto formatting is applied to the
> new sheet. My question is: How can I control this formating? Where does
> Excel get theese formats from? Some times I get quite weird results...
>
> I´m using Excel 2000.

--

0 new messages