Navigate To exactly where you should paste the data and press Ctrl + V. Only your filtered data will seem. Sharing reviews: If you are sending a file to some colleague or consumer, pasting your key calculations as values makes the data cleanse and prevents them from unintentionally modifying formulas. http://ruaxecongtrinh.com/2013/08/29/new-client-landed/