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.
filter results & the underlying data that was hidden.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
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
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
P
Pete_UK
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
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
G
Guest
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.
problem--even when I follow your instructions. The visible cells only option
doesn't seem to work either.
G
Guest
I am using Office 2007. Everything was fine in 2003. Now, I see this
problem--even when I follow your instructions.
problem--even when I follow your instructions.