Copying and pasting into a filtered list

[grphillips]

Hi,

Does anyone know how to copy and paste into a *actual filtered * lis
without. i.e only paste items over the filtered rows specified. It
annoying because when you try it pastes over the rows in between th
rows actually filtered.

Please explain in simple english.

Greg

 

[Dave Peterson]

I think I'd use a helper column that allows me to sort/group the rows that would
have been visible after the filter is applied.

Then paste into that range. You can paste into the range if it's contiguous.

Then sort it back.

You could use one additional column to put a "sort key" so that you can put the
data back into its original order. Just put a formula like =row() and drag
down. Convert this helper column to values. Then use this as the key for the
final sort.