![]() ![]() Pursuant to that, the Pivot Table Analyze tab is a contextual tab which does not appear until you are active in an existing Pivot Table. Click in the data range, then either widen the Excel window or click the arrow on the right edge of the Tables control & select Pivot Table or use one of the Recommended Pivot Tables. As a result, only a single button labeled Tables appears in that group at the left end of the Insert tab, but note the ▼ on its right edge. What you're running into is that your window is not wide enough to display all three of the controls in the Tables group on the Insert tab. ![]() It sounds like you do have the Table feature applied to the data range but you want to create a Pivot Table as well. ![]() These are the contextual tab sets that exist in Excel 2007-2016. To customize contextual tabs we use the same ribbon extensibility (RibbonX) model that you. For example, select a chart to reveal the Chart Design and Format ribbon tabs, or select a sparkline to reveal the Design tab. You can display additional ribbon commands by selecting specific items in your workbook. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |