How to copy paste only visible cells

if you are interested in our trainings check below link
linktr.ee/datacense

[@jinsooked]

Short and right to the point. Thank you.

[@datacense]

Glad it was helpful!

[@elainebelzDetroit]

thank you! This helped immensely.

[@russelllsy]

Thank you it worked on my mac and Alt is the Option key

[@patilpankajprakash6397]

Best info

[@nabanitaseth7288]

thank you

[@cristelarts]

This is amazing, thank you! 👏

[@datacense]

Glad you like it!

[@vikaspareek847]

Thanks

[@jayaprakasharjunan]

Thank you❤, so what is alt+; what will happen after click alt+; thanks in advance!! 🎉

[@pooja.p.lonari1061]

Thank you so much guruji , it's helpful I have tried it

[@datacense]

Glad, It helped!

[@sonalisoni7715]

Not working

[@khadarkhan72]

Thank you🙏

[@sumitnagar9470]

Yes sir this is amzin thanku 🎉

[@datacense]

Thanks Sumit!

[@rajigompa6999]

Thank you bro.
🎉

[@datacense]

Welcome 😊

[@abcdefghijkl396]

Good

[@bpk8737]

I want to paste data into filtered data, is it possible

[@Yadavji65678]

When we select a cell and extend it to the whole table(range), the value or data in first cell gets copied to each cell automatically, please solve

[@sayediftekharraheman6324]

Sir amezing information.
Thankyou sir
I have a question.
Sir I'm having 20 rows with data validation drop-down, so I want to copy all the rows ,but paste only which cell having data and black cell will not be pasted.
Only paste cell value not blank cell.
⚠️All rows are having data validation drop-down⚠️
Please sir help me

[@datacense]

Select the range and press ctrl G then go to special, this will give you various options to select blank or non blank cells . After that you can copy and paste.

[@mohazzamsaeed9454]

thanks

[@gauravisbest18]

Thanks bro

[@datacense]

Welcome

[@dhananjaywankhede3854]

Thank👌👌

[@FREAKYYYT]

😮

[@localvigilante979]

Then How to paste it to only visible cells in the same row?

[@johannestshwene2018]

How do you paste back incase you worked on pasted work

[@JojoEsteban-zl8zx]

@nothing:￶ ￶@nothing:￶ ￶

[@srinivasrao1886]

Not working

[@user-vo8qn4ck6q]

Thank you🙏

[@datacense]

You're welcome

[@MukeshYadav-wb5uo]

Not working

[@tracyhampp6042]

It didn't work for me either I've tried EVERYTHING and nothing is working! Frustrating!!!