Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 54
  • Last Modified:

how to copy a filter range to another column

Dear excel experts,

How can I copy data in a filtered range into one of the columns next to it?

thanks,
0
tony01excel tony
Asked:
tony01excel tony
  • 2
1 Solution
 
Rob HensonFinance AnalystCommented:
With the filter in place, start in the first visible cell of the column where you want the copy with a formula:

=B2   assuming data coming from column B and first row is row 2

Then highlight down to the bottom of the destination column and use Ctrl + D to fill down; this will only populate in the visible cells.

Now remove the filter and highlight the column. Copy and paste values to break the links.

Thanks
Rob H
0
 
YamaafgCommented:
Hi,

here is a simple way to do this:

1. selectyour desired range
2. Hold control button and select column and area you wan to paste
3. While still holding control button, Press "R".

Hope this helps.
1
 
Rob HensonFinance AnalystCommented:
@Yamaafg - well done, that does it; as doing Ctrl + D only affects the visible cells I should have realised that Ctrl + R would do the same.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now