copy and paste special while filter?

JohnSeito

Active Member
Joined
Nov 19, 2007
Messages
390
Hello,

Do anyone know that if excel can be copy and paste special value when some of the columns are filter? It seems that you can only do copy and paste special value when unfilter everything column.
thx
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Hello,

Do anyone know that if excel can be copy and paste special value when some of the columns are filter? It seems that you can only do copy and paste special value when unfilter everything column.
thx

Hi JohnSeito:

How about trying ... EDIT|Goto|Special > Select > visible_cells_only
 
Upvote 0
No that doesn't work, still can't paste special value after filter. My point is to get rid of the formula by paste special value. I wonder why you say edit, goto, select visible?
 
Upvote 0
Yogi's suggestions works for me.

EDIT|Goto|Special > Select > visible_cells_only
Ctrl-c to copy
Right click location where you want to paste
Paste special | Values
 
Upvote 0
Yogi's suggestions works for me.

EDIT|Goto|Special > Select > visible_cells_only
Ctrl-c to copy
Right click location where you want to paste
Paste special | Values

Datsmart,

I don't know what it did for you, I tried it again with the suggestion you provided above and it has not work for me. What I want to do is I have formulas in the sheet and is filter, I want to copy paste special value and make it not into formula without un-filtering it to do this.
 
Upvote 0
I built a worksheet, inserted a table of data with Formulas.
Filtered it with AutoFilter.
Then selected the Filtered table, clicked Edit, then Goto|Special
Click "visible_cells_only", OK
Ctrl-c to copy
Right click location where you want to paste
Paste special | Values

Can you post the exact steps you are doing when it does not work?
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top