hat
Nan Excel, lè yo ale nan kopi ak kole kèk done nan yon ranje ki te filtre oswa gen ranje kache / kolòn, li pral kole nan sa yo filtre oswa selil kache tou. Èske nou ka jis kole done nan selil vizib sèlman nan Excel? Kutools pou Excel'S Paste nan Range vizib ap ede ou jwenn li fè byen vit.
eng
In Excel, when going to copy and paste some data into a range which has been filtered or contains hidden rows / columns, it will paste to those filtered or hidden cells too. Can we just paste data into only visible cells in Excel? Kutools for Excel’s Paste to Visible Range will help you get it done quickly.