4. Customizing Excel
The Excel Options dialog offers dozens of changes you can make in Excel. One of the primary changes available in Excel Options is customizing the ribbon and the Quick Access Toolbar. Back in Excel 2003, you could easily customize the menus and toolbars. In Excel 2007, customization was severely limited. Starting in Excel 2010, it was back, although not as flexible as in Excel 2003.
This chapter walks you through examples of customizing the ribbon and discusses some of the important option settings available in Excel.
Performing a Simple Ribbon Modification
Suppose that you generally like the ribbon, but there is one icon that seems to be misplaced. For me, that icon is the PivotTable command. I have no idea why this is on ...
Get Excel® 2013 In Depth now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
