Learn Excel from MrExcel – “Pivot to Range”: Podcast #1456

October 25, 2011 at 1:11 pm

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.

"Learn Excel 2007 through Excel 2010 from MrExcel" by Bill Jelen…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: , , , , , , , , , , , , , , , , .

Learn Excel 2010 – “Drag Formula Reference”: Podcast #1455 Learn Excel 2010 – “Excel Outside The Box”: Podcast #1457

Learn Excel from MrExcel

Learn Excel Podcast Splash Screen

The Excel Beginners Book:

"Don't Fear The Spreadsheet" - by Tyler Nash, Bill Jelen, Tom Urtis and Kevin Jones

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 742 other followers

Live Lessons Excel 2010 DVD

"Live Lessons Excel 2010" DVD

RSS MrExcel Recent Articles

  • An error has occurred; the feed is probably down. Try again later.

Recent MrExcel Tweets

MrExcel Podcast Archive

%d bloggers like this: