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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

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...
Different Ways to Filter an Excel Slicer Excel Slicers are the best thing since sliced bread!They are a new feature from Excel 2010 onward and Mac for Excel 2016 and are visual buttons that shows you what items have been filtered or selected in a Pivot Table.There are several ways that you can filter an Exce...
Icon Sets In A Pivot Table An Icon Set is a Conditional Formatting icon/graphic that you can include in your cells or Pivot Tables.The icon will depend on the cell´s value so you can highlight key variances or trends.  There are a few icon sets that you can include, like:DIRECTIONAL (Change in valu...
50 Things You Can Do With Excel Pivot Tables Pivot Tables in Excel are one of the most powerful features within Microsoft Excel.   A Pivot Table allows you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, "pivot"/change the report layout with the ease of dr...