Solved

copy

Posted on 2011-09-08
4
147 Views
Last Modified: 2012-05-12
Hi.

1) After filtering on a certain column, I'm trying to copy and paste the subset of values from column a into column b. For some reason all I get is the columns the original values w/o filtering.

2) Same question with hidden columns and rows. I hide columns B and I want to copy and paste columns A and C
0
Comment
Question by:SF1055
4 Comments
 
LVL 4

Accepted Solution

by:
grogman earned 125 total points
ID: 36506339
Highlight your data. Then, on the Home tab, go to the Editing group, click "Find & Select", then click "Go To". In the Go To dialog, click "Special". Under "Select", click "Visible cells only", then click OK.

This will highlight only the visible cells in your selection, which you can now copy and paste to a new location.
0
 
LVL 6

Expert Comment

by:reitzen
ID: 36508162
You could use an advanced filter and use "Copy to another location", which could be column B
0
 
LVL 32

Expert Comment

by:Rob Henson
ID: 36509126
How are you selecting the area to be copied?

When filtered, if you are selecting the whole column by clicking the column header, then the whole column will copy. If you are selecting just the data then it should just copy the visble cells.

With hidden (manually rather than filtered out), the copy will take the whole area copied. If you were to select the whole column/row it would copy the whole again but when pasting it would apply the column/row formatting which in this case is "hidden" so the pasted column/row would also be hidden.

Thanks
Rob H
0
 
LVL 41

Expert Comment

by:dlmille
ID: 36515329
I always select the visible rows, manually, then copy/paste seems to work for me.

Dave
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

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

861 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

25 Experts available now in Live!

Get 1:1 Help Now