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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA For excel 0
Pivot Table Jam 1
Pivot Tables in Excel 2007 vs 2003 1
adding rows into the table 1
Conditional Formatting not holding in pivot table querying Access 2
Exported data to Excel 2007 has spaces between rows 1
Pivot table group dates 3
Pivot Table - problem with repeated fields 5

Back
Top