Adding blank "separator" Rows in a Pivot Table

  • Thread starter Thread starter Bucko
  • Start date Start date
B

Bucko

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
 
You're wonderful! Thank you Debra!

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
Click to expand...
 
Back
Top