• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 53
  • 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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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