How to Copy and Paste Visible Cells only in Excel

preview_player
Показать описание
In this video you will learn how to copy and paste Visible cells only. The hidden rows/ Columns/ cells will not be available in pasted data.

File to Download:

#ExcelSessionsbySaurabhJain
Рекомендации по теме
Комментарии
Автор

Thank you sir! I wasn't aware about it and I was using the delete approach so far whenever I used to copy something from hidden data. :)

enuarora
Автор

Shortcut Key to select visible cells is ALT + ;

chetanagarwal