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

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 ...
Repeat All Item Labels In An Excel Pivot Table Whenever you create a Pivot Table the default layout is in Compact Form, which puts all the data in one column. Many people do not like this layout as you cannot copy and paste the data and do further analysis in another worksheet. The best layout to use is either the Outli...
Connect Slicers to Multiple Excel Pivot Tables Pivot Table Slicers were first introduced in Excel 2010 for Windows and Excel 2016 for Mac. They are a visual filter in the form of an interactive button.  There are several cool things that you can do with Slicers, like customize them, filter them and connect them to mult...
Excel Chart Line Styles There are several line styles that you can include with your Excel Line Chart to make it stand out or tell a story. You can adjust the WIDTH of the line to make it as thin or thick as you like. You can make your line chart have a COMPOUND or DASH effect. You can also add...