In another show of the old passive aggressive spirit, here’s a new way to limit what the end users can do.
The Subtotal feature in Excel often comes in handy when I need a quick way to inject ‘Total’ lines into your tables. But I don’t really want them to use the drilldown thingies that Subtotals come with.
Here is the simple fix. Simply press Ctrl+8 on your keyboard to hide the drilldown thingies.
Your subtotals remain but the user cannot change the drill level. Neato!
To make them come back, simply press Ctrl+8 again.
I just KNEW that the technical term was “Thingy”. Great Tip. I’ve been using command button.