Excel2007: copying filtered table values, how can I copy ONLY thefiltered values

A

AC

Hi

I am new to excel 2007.

In previous versions of Excel if I :

- added filters to a table,
- filtered it (eg all names starting with ABC),
- highlighted the filtered table,
- copied it,
- pasted values to another sheet....

it only pasted the filtered values. Which is exactly what I want.

However when I do exactly the above steps in 2007, the paste seems to
paste the *entire* table, not just the filtered rows.

Can someone explain?
Is there a way to do this using the above process? Eg is there a
setting or something that I need to turn on?

Thanks in advance

AndyC
 
R

Ron de Bruin

Hi AC

See :

Copy the filter result to a new worksheet:

1) Select the whole data range or if you not have empty rows/columns in the range
you can use Ctrl * to select all data or use F5>Special>Current region>OK with
one cell selected in the data range.
If it copy all the data (there are a few reports of 2007 users) use also the shortcut
Alt ; or F5>Special>Visible cells only>OK to select only the Visible cells.

2) Ctrl c in all Excel versions or:
Excel 97-2003: Edit>Copy
Excel 2007: Home tab>Clipboard group>Copy

3) Shift F11 in all Excel versions to insert a worksheet or:
Excel 97-2003: Insert>Worksheet
Excel 2007: Home tab>Cells group>Insert...Sheet
Or use button next to the last tab

4) Ctrl v in all Excel versions or:
Excel 97-2003: Edit>Paste
Excel 2007: Home tab>Clipboard group>Paste

5) Select the worksheet with the filter

6) Press Esc
 

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

Top