Your are viewing a read-only archive of the old DiS boards. Please hit the Community button above to engage with the DiS !
if you hover your mouse over the ribbon then the mousewheel will scroll between the different tabs.
I wrote a macro that solves it. It was a morning well spent.
£495 (don't worry, I'm not VAT registered)
so I learnt where each one goes. It's amazing. Not only have I stopped having the annoying pressing-alt problem, I now know what to do when it crops up!
alt->N->V->T pivot table
alt->H->V->T paste transposed.