Navigate To where you should paste the data and press Ctrl + V. Only your filtered data will seem. Sharing reports: If you are sending a file to some colleague or customer, pasting your critical calculations as values would make the data clear and prevents them from unintentionally modifying formulas. https://mattzappa.com/cropped-763-c-2-jpg/