Excel: Options in 2010 is Analyze in 2013

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


When you create a pivot table, Excel displays two contextual ribbon tabs. In Excel 2010, they were called Options and Format. In Excel 2013, they are called Analyze and Format. When this book talks about the Options tab, if you have Excel 2013, you should go to the Analyze tab.