HOw can I paste data into a column with autofilter?

G

Guest

Working on an XLS s/sheet with over 10,000 rows. Have filtered one of the
columns and now need to change that data by pasting from another s/sheet (
the columns are the same size) However, when I try to paste the new data,
because the column is filtered, it seems to paste into the rows hidden
"behind" the filter as well. E.G my filtered column has 830 rows, the data
that I want to paste into it is also 830 rows ( I want to change the whole
column), but when I try to paste the data, it only pastes 27 rows ( because
it seems to paste to the rows that are hidden by the filter too).
Help??
 

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

Filter-Copy-Paste Problem 3
Excel copy only visible rows from autofilter 2
Pasting into a filtered sheet 3
Filter, Copy and Paste 2
Copy/Paste with Hidden Rows/Columns Excel 2007 3
Filtered Data 2
How do I Copy and Paste onto Same Rows after filtering out rows. 2
Copy and pasting values of filtered rows 1

Top