Excel Pivot Table Format Messed up

  • Thread starter Thread starter Tim879
  • Start date Start date
T

Tim879

Hi,

Recently (I'm not sure why) the pivot tables I create have no lines on
them (more technically -- all of the lines are white and you can't see
them)? I am not sure what setting I changed or why this has started
happening.

Does anyone know how to change this back to the default settings?

thanks
Tim
 
Reselect some other parameter in the pivottable should auto-refresh. I
couldn't find anything else that would affect this.
 
As a guess you selected the auto format option from the pivot table menu and
selected the final option None which removes all formatting. To go back to
the default autoformat select Auto Format from the pivot table menu and then
select Pivot Table Classic (second last choice) to go back to standard lines.
 
You must log in or register to reply here.

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

Pivot Table - Changes 5
Original Pivot Table Defaul Format 2
Pivot Table date format 1
Pivot Table Default Setting 1
Pivot Table - NUMBER FORMAT option does not appear in field settin 3
Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
Duplicating Pivot Tables 2
Refreshing a pivot table 1

Back
Top