Copy Visible Cells Only in Excel

When you’re working with the data set that has hidden rows, and you select and copy the cells in this dataset, it is going to copy the visible cells as well as the hidden cells. That’s the default behavior in Excel. But what if you only want to copy the visible cells (and not the ... Read more

from Online Excel Tips – Blog – Trump Excel https://ift.tt/WCFRHg5