You might not get the information you need depending on your data set, but for quick analysis, it can be handy.To create one, highlight the data source (the range of cells in the workbook that contains the data you want to analyze.) Then select the Insert tab, and then Recommended Pivot Tables.Enter your mobile number or email address below and we'll send you a link to download the free Kindle App.Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.This course will give you a simple but powerful introduction to the most powerful tool in Excel.Feel free to take a look at the free previews of this course. I am Kawser Ahmed, father of two beautiful angels (Marissa and Arissa), a full-time data analysis blogger (using Excel & other tools), corporate Excel trainer, & entrepreneur.
Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 1,900 episodes of his daily video podcast, Learn Excel from Mr Excel.
This tip (8731) applies to Microsoft Excel 2007, 2010, and 2013.
You can find a version of this tip for the older menu interface of Excel here: Maintaining Formatting when Refreshing Pivot Tables.
He has more than 15 years of experience consulting and developing Office solutions.
Mike has been named a Microsoft MVP for his ongoing contributions to the Excel community.