Learn Excel from MrExcel – “Pivot to Range”: Podcast #1456
Two Pivot Table questions today from my ‘Power Excel’ Seminar in Detroit, MI yesterday. First, when you drill down on a pivot table in Excel 2007, you are getting the Table Format instead of just a Range. How can I just get the Range? Second, when you convert a Pivot Table to Values, you lose the Formatting and the Formulas. How do I mitigate this when trying to get back to the Data Field? Follow Bill in Episode #1456 to learn the solutions.
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!
“The Learn Excel from MrExcel Podcast Series”
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Entry filed under: Excel 2007, Excel 2010, Learn Excel 2010, Learn Excel from MrExcel, MrExcel Podcast, MrExcel Products, New MrExcel Publication, Pivot Tables. Tags: 2007, 2010, accounting, Bill Jelen, business, Data, Excel 2007, Excel 2010, Formatting, formulas, MrExcel, Pivot Table, Range, spreadsheets, technology, tutorial, Worksheet.