Solved

how to copy a filter range to another column

Posted on 2016-09-20
3
41 Views
Last Modified: 2016-09-20
Dear excel experts,

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

thanks,
0
Comment
Question by:tony01excel tony
  • 2
3 Comments
 
LVL 32

Expert Comment

by:Rob Henson
ID: 41806496
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
 
LVL 5

Accepted Solution

by:
Yamaafg earned 500 total points
ID: 41806791
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
 
LVL 32

Expert Comment

by:Rob Henson
ID: 41806834
@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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Problem to With line 4 41
Vlookup nonexact IP address match 32 44
Auto populate in Cascade dropdown 3 27
Add a range in an Excel graph 5 35
Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now