Re: Excel 2007 auto format pivot table
- From: "BK" <nospam@xxxxxxxxxx>
- Date: Thu, 31 Jan 2008 07:26:46 -0600
Thank you for the info. I'll start playing around with these options and
see if I can duplicate the old "report 6" look. <grin> Will I be able to
save my design once I get it all figured out? I guess I'll know shortly.
"Roger Govier" <roger@technology4unospamdotcodotuk> wrote in message
news:FEDF5B93-A9AA-48BA-8FA1-D90736959BC1@xxxxxxxxxxxxxxxx
Hi
Yes, I am familiar with the XL2003 formats.
The same simple feature is not available.
But, on the Design Tab you can select from
Layout
whether you want Subtotals and/or Grand Totals,
whether you want the Report in Compact, Outline or Tabular format and
whether or not you want blank rows after each item.
Pivot Style Options
whether you want
Row Headers
Column Headers
Banded Rows
Banded Columns
and then choose any one of 72 or more Styles to apply to that result.
No, you don't get a few standard formats, but from those options you can
easily create any layout to match (or improve upon) the XL2003 layouts.
--
Regards
Roger Govier
"BK" <nospam@xxxxxxxxxx> wrote in message
news:es5jgM7YIHA.504@xxxxxxxxxxxxxxxxxxxxxxx
Roger
Yes, I saw the options on the design tab, but they are not really
reformatting the raw pivot table. It seems these light, medium, and
heavy styles don't actually format the report at all. Are you familiar
with the automatic formats available in 2003? That's what I'm looking
for.
"Roger Govier" <roger@technology4unospamdotcodotuk> wrote in message
news:BC4BDA5E-4A3A-4924-9DB4-B8F5FFCC87E2@xxxxxxxxxxxxxxxx
Hi
Click on any cell within the PT, click on the Design tab and then use
the dropdown at the far right to see 24 different Styles of Light,
Medium and Heavy.
As you hover over each Style, your PT shows up with that style.
When you see one that you like, double click that Style to apply.
If you don't like any of those, you can "roll your own" by clicking on
the New design icon at the bottom of the dialogue.
--
Regards
Roger Govier
"BK" <nospam@xxxxxxxxxx> wrote in message
news:##0Cvu4YIHA.2000@xxxxxxxxxxxxxxxxxxxxxxx
I am making the switch from Excel 2003 to 2007. There is one feature
that I cannot seem to find in the 2007 version.
When I create a pivot table in 2003, I then have a "format report"
button on the pivot table toolbar. When I click that button, an "auto
format" dialog box opens with pre-formatted selections. (Report 6
happens to be my favorite.)
I cannot seem to find this option in 2007. Even though I did find a
format section, there do not seem to be any pre-formatted selections
that correspond to the 2003 options.
Anyone know what I'm talking about???
.
- References:
- Excel 2007 auto format pivot table
- From: BK
- Re: Excel 2007 auto format pivot table
- From: Roger Govier
- Re: Excel 2007 auto format pivot table
- From: BK
- Re: Excel 2007 auto format pivot table
- From: Roger Govier
- Excel 2007 auto format pivot table
- Prev by Date: Re: incorrect graphics for print
- Next by Date: Excel work sheets to image.........
- Previous by thread: Re: Excel 2007 auto format pivot table
- Next by thread: Re: Formulas gone bonkers
- Index(es):
Relevant Pages
|
