Does anyone know how to insert blank rows into a pivot table (say,
between groupings, etc.)? There has to be a way, since some of the
various table formats that come with Excel include blank rows.

Double-click the field button that you want to format
Click Layout
Add a checkmark to Insert blank line after each item
Click OK, twice

Bucko wrote:
> Does anyone know how to insert blank rows into a pivot table (say,
> between groupings, etc.)? There has to be a way, since some of the
> various table formats that come with Excel include blank rows.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

You're wonderful! Thank you Debra!

On Thu, 20 Sep 2007 16:05:58 -0400, Debra Dalgleish
<(E-Mail Removed)> wrote:

>Double-click the field button that you want to format
>Click Layout
>Add a checkmark to Insert blank line after each item
>Click OK, twice
>
>Bucko wrote:
>> Does anyone know how to insert blank rows into a pivot table (say,
>> between groupings, etc.)? There has to be a way, since some of the
>> various table formats that come with Excel include blank rows.