Do you still like your Classic View in Pivot Tables in Microsoft Excel?

Classic View:

If you are creating a Pivot table but the layout initially looks like what it did in version 2003. “How do you change it to the modern layout?”. In version 2013, 2016 you will find in the Microsoft Excel Ribbon that it is now called Analyze instead of Options. Look for the options command usually found to the left of the Ribbon.  Remember in Microsoft Excel versions 2007 and 2010 you will find it under the tab call Options and then again you are looking for a command button called Options. From the Display tab in the dialog box, you will need to Un-tick or Tick as you like “Classic PivotTable layout”
which enables you to drag and drop fields into the Column and Row items area.

If you work often in Microsoft Excel’s Pivot Tables, then you might like to know about the new feature in Microsoft Excel versions 2010, 2013 and 2016 which now has “Format as Tablethis feature allows your data to increase as you add more records – “rows of data” and add new fields – “columns of data”.  This means you don’t have to go to the data sources consistently to add those few extra rows of data or  new column of data.

Microsoft Excel Version 2003 Classic Pivot Table Display


Microsoft Excel Version 2016 Ribbon


Microsoft Excel Options Diaog Box


Microsoft Excel Version 2007 to 2016 Pivot Table Standard Layout Display


Related Topics

Dynamic data for pivot tables

Excel Training Courses Sydney – Power Pivots and Pivot Tables

Excel Course


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: m: 0414 417 059
This entry was posted in Excel and tagged , , , . Bookmark the permalink.

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s