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!

DOWNLOAD WORKBOOK

Classic Pivot Table Layout

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

Share on Google+

Google+

Related Posts

Customize an Excel Slicer   Excel Slicers are very boring looking and there are only 14 different Slicer Styles to choose from, ranging from Light to Dark and with a few colors to choose from. What if you wanted to create your own Slicer using your creative mind with super cool colors and f...
Pivot Table Calculated Field Pivot Table Calculated Fields allow you to do mathematical calculations with your Field List.  You can use any of the Excel mathematical equations, like /*+-%. The only limitation is that you cannot reference any cells.  Pivot Table Calculated Fields can be used to calculate p...
Show The Difference From Previous Years With Excel... Excel Pivot Tables have heaps of calculations under the SHOW VALUES AS option and one that gets the most use is the DIFFERENCE FROM calculation. You can show the values as the Difference From previous months, years, day etc.  This is just great when your boss asks you how you ...
Pivot Charts & Slicers In a previous post I showed you how to Insert a Pivot Chart.  Now we will take this concept once step further and insert a Slicer.  The cool thing about this is that the Slicer will control both the Pivot Table and the Pivot Chart. See how you can start creating some awesome i...