example: here is my list.
I want to know just which items are yellow, so I go to the Data menu and filter the list. I choose yellow in the color column as my filter. the problem is when I highlight the data, copy, and paste it, the ENTIRE list is copied, not just the banana, bowl, and bucket rows.
to get around this:
highlight the data
hit control g
choose "special" and then "visible cells"
this highlights (or selects) only the visible cells
then you are free to copy and paste just those rows that you have filtered for!
|ctrl G > visible cells only (highlights only visible cells) > ctrl c will only copy visible cells |