How To Paste Values To Visible/Filtered Cells Only In Excel?

preview_player
Показать описание
In Excel, if you have filtered data or hidden some cells, and when you paste values into the filtered or hidden range, the hidden cells will be also filled with pasted values. Here I will tell you some tricks to paste values to visible cells only in Excel. For VBA code method, please go to:
Рекомендации по теме
Комментарии
Автор

Thank you very much, you also shared the free method

Greenwood
Автор

What if my excel without 'kutools'?

ellyong
Автор

mine cant do that even with kutools. why?

aqilahnabilah