Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I know there must be a way of achieving this without writing a macro, and just doing a straight paste.

I have two columns (Column A and Column B) that contain 10 records. 5 records are filtered out; so, currently, only 5 records are visible. Now I have another column with 5 records on a separate sheet that is unfiltered. I want to copy those 5 records, and paste the data in Column C next to filtered data.

Excel pastes all 5 records, but some of the 5 records are not visible because they are in rows that have been filtered out.

How can I simply paste the 5 records, so to insert only into the rows that are currently visible without using a macro or a vlookup? I am using Excel 2008, although it shouldn't matter in this case.

share|improve this question
up vote 1 down vote accepted

It doesn't seem there is any built-in Excel functionality to do this. Your only recourse will be writing a VBA routine to paste into visible cells.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.