Pinterest Pixel

Classic Pivot Table Layout View

For all of you old schoolers out there who used to use the drag and drop Pivot... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

For all of you old schoolers out there who used to use the drag and drop Pivot Table option in Excel 2003 or prior, well you still have that option in Excel 2010 and onwards.

To activate this option you need to Right Click in your Pivot Table and choose Pivot Table Options.

Then under the Display tab you need to “check” the Classic Pivot Table Layout box.  This will enable you to drag your Fields from the Field List straight into the Pivot Table, just like the good ol’ days!

Classic Pivot Table Layout View | MyExcelOnline
Download workbookClassic-Pivot-Table-Layout.xlsx

This is our starting Pivot Table showing our sales totals:

Classic Pivot Table Layout View

STEP 1: Right click in the Pivot Table and select PivotTable Options

Classic Pivot Table Layout View

STEP 2: Go to Display > Classic PivotTable Layout and check that option

Classic Pivot Table Layout View

STEP 3: Let us have some fun! Now you can drag fields into the Pivot Table

Drag the Year away to remove it from the Pivot Table

See also  Logarithmic Scale In An Excel Chart

Classic Pivot Table Layout View

STEP 4: You can now drag the Customer field to your Pivot Table

Classic Pivot Table Layout View

You have now customized your Pivot Table the good old Classic way!

Classic Pivot Table Layout View

HELPFUL RESOURCE:

728x90

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!