Excel Guide - Copy and Paste Values only in Filtered Cells

#SS - Smart Search - Live up to mark

The video demonstrates how to copy and paste only filtered values in a specific column in Excel.

To copy values only to the filtered cells the following procedure can be followed.

1. You can either use a formula for the first cell and click and drag or double click after filling the first cell.

2. Or Based on keystrokes Select the columns that have to be filled and press Alt + ; and type the formula in the first cell and click ctrl + Enter.

[RahulGupta]

Very nice way of presentation.. like me a lot of people are always confused with this.. thanks

[Lone_wolf_]

God bless you coach ! You saved me lot of time

[ahmedfarhad]

I'm looking for this trick for 1 year. And finally got. Applause 👏

[fransdany]

Thank you for saving my life. Dhanyavad

[vilasphadnis]

Looking for this for long time.. finally got it.. Thanks..

[nv]

How to copy data from filtered cell from different sheet..

[akshanshdwivedi]

if i need to copy from 1 filtered file to another filtered file if the rows and collumns are same?

[piotrkuchta]

Thank you for the great guide! I have a question, how to paste Copy and Paste in Filtered Cells but as Values only (meaning if I wanted to delete the column copied from (i.e. J) afterwards)?

[pramothj]

I need know how to work vlook up function