How to Cut and Paste Visible Cells only in Excel

Maybe you've used the Group and Outline tool or the Subtotal tool and you wish to make a report using the high level numbers - here's the trick to enable you to 'select visible cells only' before you hit copy and paste!