Can't Copy and Paste when I'm using a filter List.. hmmm
 

I can't copy and past when I'm using a filtered list.
I've got only some rows showing in my list.
It won't let me copy and paste. I'm trying to copy a filtered column,
(meaning only selected rows, say 1, 4, 7, 8, 50, 54)
and then paste the values of those rows on top of it after I no longer need
the formula.

The error messge I keep getting is:
the copy area and the paste are are not the same shape.
Try one of the following: click a single cell,
Select a rectangle that's the same size and shape and then paste.

or error message:
The command cannot be used on multiple selections.

Any tips, explanations, or fixes?

Can't Copy and Paste when I'm using a filter List.. hmmm
 

F5SpecialVisible cells onlyOK.

Copy those selected.

Paste to another sheet or below the existing data.

Remove filter and delete what you don't want.


Gord Dibben MS Excel MVP

On Tue, 22 Sep 2009 08:55:01 -0700, Benjamin
wrote:


I can't copy and past when I'm using a filtered list.
I've got only some rows showing in my list.
It won't let me copy and paste. I'm trying to copy a filtered column,
(meaning only selected rows, say 1, 4, 7, 8, 50, 54)
and then paste the values of those rows on top of it after I no longer need
the formula.

The error messge I keep getting is:
the copy area and the paste are are not the same shape.
Try one of the following: click a single cell,
Select a rectangle that's the same size and shape and then paste.

or error message:
The command cannot be used on multiple selections.

Any tips, explanations, or fixes?