copy

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
SF1055Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
grogmanConnect With a Mentor Commented:
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
 
reitzenCommented:
You could use an advanced filter and use "Copy to another location", which could be column B
0
 
Rob HensonFinance AnalystCommented:
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
 
dlmilleCommented:
I always select the visible rows, manually, then copy/paste seems to work for me.

Dave
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.

All Courses

From novice to tech pro — start learning today.