I work in Excel on and off throughout the day. Like right now for instance I have 6 spreadsheets open and have looked and more than likely modified each of them today. One thing that I do from time to time is use subtotals – a lot of times it’s to get totals by size for some shirts for You and Who.
I don’t know why I didn’t figure this out sooner but I now know how to copy only visible cells – which is important when copying subtotals because all of the data is really there when you’re looking at it rolled up so if you copy it you copy all the rows, which you probably didn’t want to do. Here are a few images to show what I mean.
Now we’ll roll up to just show subtotals (clicking the 2 on the left side)
Now, that’s what I’m looking for – just the subtotals by shirt design. So, to copy them here’s what you do:
Highlight the rows/columns you want to copy (which I did in the above photo) then click Edit -> Go To … -> click the Special button -> Select Visible Cells only.
Now when you paste them somewhere you’ll get just the subtotals. Nice.