Question: how to copy and paste just subtotals in excel 2016?
Answer: After subtotalling, click on the 2 square on the left to just see the subtotal lines. Highlight the subtotal lines you want to copy. Press F5 on your keyboard, click Special, and choose Visible Cells Only. Click OK. Then click Copy, and Paste the lines to a new location.