Excel: Copy visible cells only – only took me a few years to figure this out!

Share?

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.

subtotals-showing-all

Showing all rows

Now we’ll roll up to just show subtotals (clicking the 2 on the left side)

Just subtotals

Just subtotals

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.

Voilà

Voilà

Now when you paste them somewhere you’ll get just the subtotals. Nice.

 

Share?

One thought on “Excel: Copy visible cells only – only took me a few years to figure this out!

Leave a Reply

Your email address will not be published. Required fields are marked *