Classic View – Pivot Tables


I’m Creating a Pivot table but the layout initially looks like what it did in version 2003. How do I change it to the modern layout?

Version 2003 Classic Pivot Table Display

Classic pivot.png

  1. In version 2013,2016 Select Analyze
  2. In Version 2007,2010 Select Options

pivot-ribbom

  1. Ensure your cursor is in the Pivot Table
  2. From the Analyze Tab/Options
  3. From the Display tab in the dialog box
  4.  Un-tick Classic PivotTable layout

 

options-classic-off

2007 to 2016 Pivot Table Standard Layout Display

Picture1.png

Related Topics

Dynamic data for pivot tables

Excel Training Courses Sydney – Power Pivots and Pivot Tables

Excel Course

 

 

Advertisements

About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: Info@azsolutions.com.au m: 0414 417 059 www.azsolutions.com.au
This entry was posted in Excel. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s