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

B

Benjamin

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?
 
G

Gord Dibben

F5>Special>Visible cells only>OK.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert name and adress from a list in a word document 1
Filter, Copy and Paste 2
Copy and paste area not same in filtered mode . 8
copy and paste problem Excel 2007 3
Filtered copy and paste error 1
COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6
Excel 2010 not allowing me to paste as formula 8
Copy and pasting values of filtered rows 1

Top