Top Tip on 26th February 2016 Coopa Friday, 26th February 2016 TweetPinShare0 SharesExcel, Copy Subtotals 1. Create Subtotal & goto level 2 2. Select subtotal cells 3. Ctrl+C 4. F5, Special, Visible cells only, ok 5. Ctrl+V TweetPinShare0 Shares