WIIW - Classic Pivot Layout - 1058 - Learn Excel Podcast
Where’s is it Wednesday? Where the heck did I move that icon? It used to be right there. Hey, aright, welcome back to Mr. Excel netcast, I’m Bill Jelen. It’s been a while since we talk about Pivot Tables. Let’s create a quick Pivot Table here in Excel 2007. Insert Pivot Table. And one of the things in 2007, it’s kind of easier to build Pivot Tables, because you’re simply dragging fields around these drop zones over here. So it’s kind of obvious, you know, what you’re building. As you drag that field around, you get a nice clean summary report over there on the left hand side. Now the problem with people who had been using Pivot Tables for a long time is they miss the fact that we used to be able to just drag fields and drop them on the report. And I got a nice note today from Michael, who said, you know, hey, if you really like to drop fields on the report, there is a way that you can still do that in Excel 2007. Now we want to do is we want to go into the Pivot Table options. Now there’s five tabs. Now we want to go back to the third tab, the display tab, where there’s a setting here called classic Pivot Table layout. Click OK. And now we have drop zones, where we can simply drag the field and drop it in their appropriate spot, just like we could do in Excel 2003. So I want to thank Mike for that great tip about the classic mode. For those of you who are old time Pivot Table fans, you rather drag and drop, great way to go. If you’re new to Pivot Tables, then go ahead and just learn how to use the drop zones over here. Much easier, you’re not going to drop a field in the wrong place. Alright, hey, I want to thank you for stopping by. We’ll see you next time for another netcast from Mr. Excel.