Somehow I lost the ability to format *all* the subotals in a Pivot table *at once*.
Normally you can just place the cursor at the left of a subtotal row in a pivot table, and it turns into a black arrow pointing to the right. If you click it, it'll select not only that particular subtotal row, but *all* subtotal rows. That allows you to, for example, format all subtotals as bold, or highlight them with the same color.
Well, I can't do that anymore! I did not change any option in Excel, it just stopped working.
Any ideas? I use Excel 2003, BTW. Thanks,
Normally you can just place the cursor at the left of a subtotal row in a pivot table, and it turns into a black arrow pointing to the right. If you click it, it'll select not only that particular subtotal row, but *all* subtotal rows. That allows you to, for example, format all subtotals as bold, or highlight them with the same color.
Well, I can't do that anymore! I did not change any option in Excel, it just stopped working.
Any ideas? I use Excel 2003, BTW. Thanks,