Copy Filter Results only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I set the filter so that I can copy only the filter results vs. the
filter results & the underlying data that was hidden.
 
Autofilter results?

My Excel 2003 you just select the rows you see and copy/paste.

If you can't do that for dome reason, F5>Special>Visible cells only>ok.

Copy/paste.


Gord Dibben MS Excel MVP
 
Once you have filtered your data, highlight the visible cells that you
want to copy (plus maybe the headings) and click <copy>. Then move
your cursor to where you want the data to be copied to (maybe in
another sheet) and just press <Enter>. You should see only the
filtered data in the pasted range.

Hope this helps.

Pete
 
I am using Office 2007. Everything was fine in 2003. Now, I see this
problem--even when I follow your instructions. The visible cells only option
doesn't seem to work either.
 
I am using Office 2007. Everything was fine in 2003. Now, I see this
problem--even when I follow your instructions.
 
You must log in or register to reply here.

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

Macro to copy value in field and insert it into filter 2
Copying four filtered cells 1
copy and paste filtered cells 1
questions on advanced filter 4
Using the Autofill, with filtered lists 1
Filtering issues? 2
Find Duplicate names and delete problem 2
Dynamic Filtering 2

Back
Top