Bacon Bits:

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.

RELATED STUFF

1. Getting Rid of Sticky Click
2. Flipping a Range Upside Down
3. Paste Special Skip Blanks
4. Avoiding Data Cut-Off in Excel
5. Why FIND when you can SEARCH
6. Formula Auditing Art
7. New Date Formatting Trick Kind Of
8. Jump to Last Cell Using Only the Mouse
9. Sort by Color in Excel 2003
10. Mimicking Scroll Lock

• Previous Entry: GoTo Special Non Blank Cells
• Next Entry: Draw a Perfect Circle in Excel