Donate SIGN UP
Home > Technology > Computers > Excel - Copy and Paste with Autofilter On

Excel - Copy and Paste with Autofilter On

Avatar Image
funkylad20 | 09:46 Thu 05th Nov 2009 | Computers
4 Answers
I have filtered some data on a spreadsheet and want to copy and paste data from another spreadsheet into these cells only. However, when I do, it takes into account the 'hidden' cells that are not filtered and only pastes about 10 lines worth of data. How do I overcome this?
prev Google
  
next outlook express
Gravatar

Answers

1 to 4 of 4rss feed

Best Answer

No best answer has yet been selected by funkylad20. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Avatar Image dipee65
I think it will work if you use "Paste Special" instead of "Paste"
11:16 Thu 05th Nov 2009
Avatar Image dipee65
Should have said select "values" on radio button
11:18 Thu 05th Nov 2009
Avatar Image funkylad20
Question Author
No, it still doesn't work...
:o/
11:34 Thu 05th Nov 2009
Avatar Image TTG
Copy/Pase your filtered sheet to a new worksheet. This should only paste in the filtered rows.
Now copy in your data into the new worksheet.
12:28 Thu 05th Nov 2009

1 to 4 of 4rss feed

Do you know the answer?

Excel - Copy and Paste with Autofilter On

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.